如何在CentOS7.6上安装MySQL8.0

在MySQL官方网站上下载包

选择相应的版本和操作系统

这里选择二进制包

上传包到服务器，进行解压。并把解压后的包传到/opt目录下tar zxf mysql-8.0.14-el7-x86_64.tar.gz mv mysql-8.0.14-el7-x86_64 /opt/mysql

创建mysql  datadir目录和用户useradd -s /sbin/nologin mysql -Mtouch /home/data/mysql/3306.errmkdir /home/data/mysql/{data,logs} -pchown mysql.mysql /home/data/mysql/ -R

增加配置文件/etc/my.cnfvim /etc/my.cnf cat /etc/my.cnf [client]port            = 3306socket          = /home/data/mysql/mysql.sock [mysql]no-auto-rehash [mysqld]user    = mysqlport    = 3306socket  = /home/data/mysql/mysql.sockbasedir = /opt/mysqldatadir = /home/data/mysql/databack_log = 600max_connections = 800max_connect_errors = 3000 external-locking = FALSEmax_allowed_packet =8Msort_buffer_size = 1Mjoin_buffer_size = 1Mthread_cache_size = 100#default_table_type = InnoDBthread_stack = 192K#transaction_isolation = READ-COMMITTEDtmp_table_size = 2Mmax_heap_table_size = 2Mlong_query_time = 1#log_long_format#log-error = /home/data/mysql/error.log#log-slow-queries = /home/data/mysql/slow.logpid-file = /home/data/mysql/mysql.pidlog-bin = /home/data/mysql/logs/mysql-binrelay-log = /home/data/mysql/logs/relay-binrelay-log-info-file = /home/data/mysql/logs/relay-log.infobinlog_cache_size = 1Mmax_binlog_cache_size = 1Mmax_binlog_size = 2Mexpire_logs_days = 7key_buffer_size = 16Mread_buffer_size = 1Mread_rnd_buffer_size = 1Mbulk_insert_buffer_size = 1M#myisam_sort_buffer_size = 1M#myisam_max_sort_file_size = 10G#myisam_max_extra_sort_file_size = 10G#myisam_repair_threads = 1#myisam_recover lower_case_table_names = 1skip-name-resolveslave-skip-errors = 1032,1062replicate-ignore-db=mysql server-id = 1  innodb_buffer_pool_size = 32Minnodb_data_file_path = ibdata1:128M:autoextendinnodb_thread_concurrency = 8innodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 2Minnodb_log_file_size = 4Minnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90innodb_lock_wait_timeout = 120innodb_file_per_table = 0[mysqldump]quickmax_allowed_packet = 2M [mysqld_safe]log-error=/home/data/mysql/3306.errpid-file=/home/data/mysql/mysqld.pid

设置环境变量，进行MySQL初始化操作vim /etc/profile在最后一行添加export PATH=$PATH:/opt/mysql/bin/ 在命令使他生效source /etc/profile

初始化数据库操作/opt/mysql/bin/mysqld  --initialize-insecure   --basedir=/opt/mysql/  --datadir=/home/data/mysql/data --user=mysql --console

拷贝数据库启动文件，到/etc/init.d/mysqld，并修改basedir和datadircp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld  vim /etc/init.d/mysqld

启动MySQL，并给root用户创建密码/etc/init.d/mysqld start      mysqladmin -uroot password 'root';

登录mysql，成功