Ubuntu24.04安装MySQL8

1、安装

sudo apt-get install mysql-server

2、访问限制修改

sudo mysql -u root -p

use mysql

update user set host='%' where user='root';  
FLUSH PRIVILEGES;

3、修改root密码

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

FLUSH PRIVILEGES;

4、常用命令

启动：
sudo systemctl start mysql

重启：
sudo systemctl restart mysql

状态查询：
sudo systemctl status mysql

停止：
sudo systemctl stop mysql