linux环境MySQL8.0安装

按照以下步骤，可成功。 可能需要libaio库，先安装 yum install libaio 下载 wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz 解压 tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz 复制到/usr/local/mysql mv mysql-8.0.18-linux-glibc2.12-x86_64 /usr/local/mysql cd /usr/local/mysql mkdir data 添加用户 groupadd mysql useradd -g mysql mysql chown -R mysql.mysql /usr/local/mysql/ mkdir mysql_install_db chmod 777 ./mysql_install_db /usr/local/mysql/bin/mysqld --initialize --user=mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data ##到此，会提示初始化密码，记录下来，等安装完成，第一次打开数据库需要 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld cp -a ./support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld chkconfig --add mysqld chkconfig --list mysqld 到此安装完成，下面是配置

配置：

vi /etc/profile 打开文件后，在最后添加 export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib export PATH 退出编辑。 source /etc/profile

/etc/my.cnf 配置, 直接复制进去即可。

[mysqld] basedir = /usr/local/mysql datadir = /usr/local/mysql/data socket = /usr/local/mysql/mysql.sock character-set-server=utf8 port = 3306 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] socket = /usr/local/mysql/mysql.sock default-character-set=utf8 # # include all files from the config directory # !includedir /etc/my.cnf.d

启动mysql

service mysql start #返回 Redirecting to /bin/systemctl start mysql.service #数据库启动成功

下面是数据库修改密码，外网访问，服务器需开放3306端口

mysql -uroot -p #输入刚才记录的密码，按回车 #修改密码 alter user 'root'@'localhost'IDENTIFIED BY '123456'; #创建用户aa，密码为123456 create user aa identified by '123456'; GRANT ALL ON *.* TO 'aa'@'%' WITH GRANT OPTION; Flush privileges; use mysql update user set host='%' where user ='root'; 更新域属性，'%'表示允许外部访问： FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

到此结束。连续装了三台服务器，记录下来，下次直接复制

# navicate连接时，2059错误。修改密码加密规则。 use mysql alter user 'root'@'%' IDENTIFIED BY '123' password expire never; alter user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123'; FLUSH PRIVILEGES;