ubuntu22.04安装mysql

ubuntu22.04安装mysql

通过命令安装

更新源

sudo apt update

安装

sudo apt install mysql -y mysql-server

检查状态

sudo systemctl status mysql.service

设置密码

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
exit;

修改配置

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

修改bind-address

bind-address            = 0.0.0.0

保存退出,重启服务

sudo systemctl restart mysql

解决远程无法登陆

登录数据库

mysql -u root -p

输入密码

选择数据库

use mysql;

修改root的host为% 即无论在哪台主机上都能够登陆

update user set host='%' where user='root' and host='localhost';

flush privileges;
exit