mysql8.0.11安装linux_mysql8.0.11安装linux

1.下载资源

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

如果提示 &＃xff1a; -bash: wget: command not found &＃xff0c;直接 yum install wget

2.下载完成之后解压

tar zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

3.移动到linux目录下

mkdir /usr/local/mysql

mkdir /usr/local/data

mv mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql

4.创建mysql用户和mysql用户组&＃xff0c;并使/usr/local/mysql的拥有着为mysql

groupadd mysql

useradd -r -g mysql mysql

chown -R mysql:mysql /usr/local/mysql

5.初始化数据库并声称密码&＃xff1a;

/usr/local/mysql/bin/mysqld --initialize --user&＃61;mysql --basedir&＃61;/usr/local/mysql/ --datadir&＃61;/usr/local/mysql/data/

如果报错&＃xff1a;

则安装&＃xff1a;

yum -y install numactl

如果没有解决&＃xff0c;在安装这个&＃xff1a;

yum install -y libaio

6.启动mysql&＃xff0c;检查是否启动成功

/usr/local/mysql/bin/mysqld_safe --user&＃61;mysql &

ps -ef |grep mysql

7.配置环境变量

vi /etc/profile

在文件最后添加&＃xff1a;

PATH&＃61;/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

source /etc/profile //立即生效

8.修改密码和远程登陆

mysql -uroot -p

输入刚刚的临时密码&＃xff1a;

选择数据库:use mysql;

ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; IDENTIFIED BY &＃39;新密码&＃39;;

update user set host &＃61; &＃39;%&＃39; where user &＃61; &＃39;root&＃39;;

9.将mysql服务加到系统服务中

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chmod &＃43;x /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

chkconfig --list mysqld

10.现在就可以使用service mysqld start|restart|stop来启动|重启|关闭服务了。

❤注意&＃xff1a;

navicat远程链接数据库时会报错&＃xff1a;1251 错误&＃xff1a;

出现这个原因是mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password, 解决问题方法有两种&＃xff1a;

第一种方式&＃xff1a;

升级navicat驱动

第二种方式 &＃xff1a;

把mysql用户登录密码加密规则还原成mysql_native_password.

ALTER USER &＃39;root&＃39;&＃64;&＃39;%&＃39; IDENTIFIED BY &＃39;password&＃39; PASSWORD EXPIRE NEVER; #修改加密规则ALTER USER &＃39;root&＃39;&＃64;&＃39;%&＃39; IDENTIFIED WITH mysql_native_password BY &＃39;password&＃39;; #更新一下用户的密码FLUSH PRIVILEGES; #刷新权限

就可以了。