MySQL8.0安装

0.环境： os : CentOS release 6.10 (Final) Msyql: mysql8.0.14 1.下载官方打包好的二进制安装包： #wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.14-linux-glibc2.12-x86_64.tar.xz 8.0采用了新的.xz压缩方式，文件很小，只有350M左右 2.解压： tar -xJvf mysql-8.0.14-linux-glibc2.12-x86_64.tar.xz 3.放到/usr/local下 [root@iceman local]# ln -s mysql-8.0.14-linux-glibc2.12-x86_64 mysql 4.配置参数文件 /etc/my.cnf [mysqld] server-id                      = 1 port                           = 3306 datadir                        = /data/mysql socket                         = /tmp/mysql.sock pid-file                       = /tmp/mysqld.pid log-error                      = error.log slow-query-log                 = 1 slow-query-log-file            = slow.log long_query_time                = 0.2 log-bin                        = bin.log binlog_format                 =ROW character-set-client-handshake = FALSE character-set-server           = utf8mb4 collation-server               = utf8mb4_unicode_ci init_connect                   ='SET NAMES utf8mb4' innodb_buffer_pool_size        = 200M join_buffer_size               = 10M sort_buffer_size               = 2M read_rnd_buffer_size           = 2M log_timestamps                 = SYSTEM 5.创建用户和目录 [root@iceman ~]# groupadd mysql [root@iceman ~]# useradd -r -g mysql -s /bin/false mysql   ### /bin/false的意思是，禁止一起登录行为 [root@iceman ~]# mkdir -p /data/mysql [root@iceman ~]# chown -R mysql:mysql /data/mysql/ [root@iceman ~]# chmod -R 775 /data/mysql/ 6.初始化数据库：可以用--initialize-insecure不生成密码 [root@iceman bin]# pwd /usr/local/mysql/bin [root@iceman bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql 初始化的时候遇到如下两个问题，用Yum 安装上即可。 ./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory yum -y install libaio ./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory yum -y install numactl 7.设置启动文件： #cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql --启动数据库： # /etc/init.d/mysql start Starting MySQL.Logging to '/data/mysql/error.log'.  SUCCESS!  8.修改环境变量 # vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin # source /etc/profile.d/mysql.sh  9 .修改密码 mysql> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql>  mysql>  mysql> alter user root@localhost identified by 'Hellxxxeiyun!@#$'; Query OK, 0 rows affected (0.01 sec)