linux-mysql-8.0.29搭建

MySQL-8.0.29服务端安装

1. 下载MySQL-8.0.29
   https://dev.mysql.com/downloads/mysql/

2. 解压安装包
   tar -zxvf mysql-8.0.29-el7-x86_64.tar.gz

3. 重命名文件夹
   mv mysql-8.0.29-el7-x86_64 mysql

4. 创建用户和用户组
   groupadd mysql
   useradd -r -g mysql mysql

5. 创建数据目录并赋予权限
   mkdir -p /usr/local/mysql/data/mysql
   chown -R mysql:mysql /usr/local/mysql/data/mysql
   chown -R mysql:mysql /usr/local/mysql/

   mkdir /var/log/mariadb/
   chown -R mysql:mysql /var/log/mariadb/
   cd /var/log/mariadb/
   touch mariadb.log
   chown -R mysql:mysql mariadb.log

6. 编辑my.cnf
   cd /usr/local/mysql
   vim my.cnf
   ##########################
   [mysqld]
   bind-address=0.0.0.0
   port=3306
   user=mysql
   basedir=/usr/local/mysql
   datadir=/usr/local/mysql/data/mysql
   character-set-server=utf8mb4
   socket=/tmp/mysql.sock

[mysql]
character-set-server=utf8mb4
socket=/tmp/mysql.sock

[client]
port=3306
default-character-set=utf8mb4
lower_case_table_names=1
socket=/tmp/mysql.sock
##########################
7. 初始化MySQL
cd /usr/local/mysql/bin
./mysqld --initialize-insecure --datadir=/usr/local/mysql/data/mysql --basedir=/usr/local/mysql --user=mysql

8. 启动MySQL
   cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
   service mysql start
   ps -ef | grep mysql
   
9. 修改MySQL密碼
   alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘root’;
   
10. 設置MySQL可以在任何host訪問
    update user set host = ‘%’ where user = ‘root’;
    
11. 刷新權限
    flush privileges;