centos 安装mysql8

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.12-linux-glibc2.12-x86_64.tar

tar -xvf mysql-8.0.12-linux-glibc2.12-x86_64.tar

tar xvJf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

mv mysql-8.0.12-linux-glibc2.12-x86_64 mysql

groupadd mysql
useradd -g mysql mysql
passwd mysql

mkdir -p appl/mysql/data
mkdir -p appl/mysql/run
mkdir -p appl/mysql/log
touch appl/mysql/log/mysql-error.log
chown -R mysql:mysql appl/mysql

/appl/mysql/bin/mysqld --initialize --user=mysql --basedir=/appl/mysql/ --datadir=/appl/mysql/data/ --lower-case-table-names=1

# The following options will be passed to all MySQL clients
 [client]
 #password       = your_password
 port            = 3306
 socket          = /tmp/mysql.sock
 #default-character-set = utf8
 host = localhost
 user = root
 password = root001
 # The MySQL server
 [mysqld]
 port            = 3306
 socket          = /tmp/mysql.sock
 skip-external-locking
 skip-name-resolve
 pid-file = /appl/mysql/run/mysqld.pid
 datadir = /appl/mysql/data
 basedir = /appl/mysql
 default-time-zone='+08:00'
 
 key_buffer_size = 128M
 max_allowed_packet = 32M
 table_open_cache = 512
 sort_buffer_size = 8M
 net_buffer_length = 8K
 read_buffer_size = 8M
 read_rnd_buffer_size = 8M
 myisam_sort_buffer_size = 128M
 character_set_server=utf8
 default-storage-engine          = InnoDB
 max_connections                 = 1024
 innodb_flush_method             = O_DIRECT
 innodb_buffer_pool_size         = 1G
 innodb_file_per_table           = 1
 interactive_timeout             = 100
 innodb_log_buffer_size          = 8M
 innodb_log_file_size            = 64M
 innodb_flush_log_at_trx_commit  = 2
 wait_timeout  = 100
 #table_cache = 2048
 thread_cache_size = 512
 relay_log_purge=0
 lower_case_table_names=1
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
 #log                            =/appl/mysql/log/mysql.log            
 log_error                      = /appl/mysql/log/mysql-error.log
 #log_queries_not_using_indexes  = 1
 #slow_query_log                 = 1
 #slow_query_log_file            = appl/mysql/log/mysql-slow.log
 # binary logging is required for replication
 log-bin=mysql-bin-9110
 replicate-ignore-db=mysql
 # binary logging format - mixed recommended
 binlog_format=mixed
 # but will not function as a master if omitted
 server-id       = 9110
 innodb_data_home_dir = /appl/mysql/data
 #rpl_semi_sync_master_enabled=1
 #rpl_semi_sync_master_timeout=1000
 #rpl_semi_sync_slave_enabled=1
 tmp_table_size = 128M
 max_heap_table_size = 128M
 innodb_buffer_pool_instances = 10
 innodb_read_io_threads = 8
 innodb_write_io_threads = 8
 innodb_thread_concurrency = 0
 innodb_purge_threads = 1
 #innodb_file_format = Barracuda
 innodb_use_native_aio = 1
 innodb_stats_on_metadata = 0
 [mysqldump]
 quick
 max_allowed_packet = 64M
 default-character-set = utf8
 [mysql]
 no-auto-rehash
 # Remove the next comment character if you are not familiar with SQL
 #safe-updates
 [myisamchk]
 key_buffer_size = 128M
 sort_buffer_size = 128M
 read_buffer = 2M
 write_buffer = 2M
 [mysqlhotcopy]
 interactive-timeout
 [mysqld_safe]
 err-log=/appl/mysql/log/mysql-error.log
 pid-file=/appl/mysql/run/mysqld.pid

cp /appl/mysql/support-files/mysql.server /etc/init.d/mysqldservice mysqld  start

vi /etc/profile
PATH=/appl/mysql/bin:/appl/mysql/lib:$PATH
Source /etc/profile

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root001';

CREATE USER 'username'@'ip.%' identified with mysql_native_password by 'passwd';
GRANT ALL PRIVILEGES ON db.* to 'username'@'ip.%' WITH GRANT OPTION;
flush privileges;