【Mysql】【部署】及初始化用户

1. 部署包下载

wget  https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz

2. 服务安装

tar -xvf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
mv /usr/local/mysql-8.0.26-linux-glibc2.12-x86_64/ /usr/local/mysql

3. 配置修改

vi /etc/my.cnf
#替换
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/mysqld.log
pid-file = /usr/local/mysql/mysqld.pid
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1 # 不区分大小写
sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO'
default-time_zone = '+8:00'
### 配置项说明：
###   mysql8默认mysql_native_password；Mysql5为caching_sha2_password
###   如果不改为mysql_native_password，其他第三方产品可能报错；报错如下：
###     Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
default_authentication_plugin=mysql_native_password

4. 配置mysql用户

adduser mysql
chown -R mysql.mysql /usr/local/mysql/

5. 初始化mysql

cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql

6. 查看密码

pswd=`cat /usr/local/mysql/mysqld.log | grep password|awk '{print $NF}'`
echo $pswd

7. 启动服务

bash /usr/local/mysql/support-files/mysql.server start
#查看进程是否启动
ps -axu| grep mysql

8. 登录mysql

./mysql -uroot -p$pswd

9. 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

10. 加入到系统服务

# 复制 mysql.server 至/etc/init.d/重命名为 mysqld
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

11. 修改数据路径

sed -i 's#^datadir=.*#datadir=/usr/local/mysql/data#g' /etc/init.d/mysqld
sed -i 's#^basedir=.*#basedir=/usr/local/mysql#g' /etc/init.d/mysqld

12. 配置远程登录用户

./mysql -uroot -p123456
 CREATE USER 'linxi'@'%' IDENTIFIED BY '123456';

14. 远程登录验证

mysql -ulinxi -h192.168.199.18 -p123456 #192.168.199.18为主机ip