mysql8.3.0安装概述

最新推荐文章于 2024-10-14 16:07:38 发布

原创最新推荐文章于 2024-10-14 16:07:38 发布 · 344 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #linux #服务器

MySQL :: Download MySQL Community Server (Archived Versions)

下载相关rmp包，并上传至 /opt/mysql8.3.0 目录下：

依次安装：

rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm
	---可能会报错，原因是由于mariadb没有被卸载。
	---rpm -qa | grep mariadb
	---然后直接卸载，不去管依赖：rpm -e --nodeps mariadb-libs-xxxxxx...

rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm

远程连接：

可能会报错：“MySQL8 设置权限报错:ERROR 1396 (HY000)、ERROR 1064 (42000)、ERROR 1410 (42000)”

mysql> alter user 'root'@'%' identified by  'MyAdmin123!@#';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%'
mysql> grant all on *.* to root@'%' identified by 'MyAdmin123!@#';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'MyAdmin123!@#'' at line 1

解决：

mysql> use mysql;
Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)

备份：

mysqldump -uroot -p密码 --databases 数据库名> /root/xxx/bak_20241008.sql

恢复：

mysql -uroot -p -f < ./root/xxx/bak_20241008.sql