ubuntu22.04 myslq初始化配置

1. 装包

sudo apt install mysql-server -y

2. 初始化

ubuntu22.04默认安装mysql8

新建mysql是没有密码的

mysql -uroot -p

 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Admin123!';
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Admin123!';

exit;

 

echo default_authentication_plugin=mysql_native_password >> /etc/mysql/mysql.conf.d/mysqld.cnf
grep port /etc/mysql/mysql.conf.d/mysqld.cnf
echo 'port = 33066' >> /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i 's/127.0.0.1/0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql
ufw allow 33060
ufw allow 33066

 

然后就可以远程链接了mysql的root用户了：

mysql -h192.168.116.22 -uroot -p --port=33066

 

目前发现mysqlx暂时没什么用，先禁用掉吧

echo mysqlx=0 >> /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i '/^mysqlx-bind-address/s/^/#/' /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql
ufw delete allow 33060

 

其他

root@santiagod:~# ufw allow proto tcp from 192.168.0.0/16 to any port 33066
Rule added
root@santiagod:~# ufw status numbered 
Status: active

     To                         Action      From
     --                         ------      ----
[ 1] 22/tcp                     ALLOW IN    Anywhere                  
[ 2] 33066/tcp                  ALLOW IN    192.168.0.0/16            

root@santiagod:~#