【mysql】02在ubuntu24安装并配置mysql

余欲与鱼语渔

已于 2024-07-16 22:15:10 修改

阅读量336

点赞数 2

文章标签： mysql adb 数据库

于 2024-07-16 21:40:01 首次发布

本文链接：https://blog.csdn.net/weixin_45671758/article/details/140477559

版权

安装

sudo apt-get update
sudo apt-get install mysql-server

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';

FLUSH PRIVILEGES;

添加用户并赋予权限

CREATE USER 'remote_user'@'%' IDENTIFIED BY 'Password@123';
GRANT ALL PRIVILEGES ON *.* TO 'remote_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

编辑配置文件

sudo nano /etc/mysql/my.cnf

修改 bind-address 配置项

[mysqld]
bind-address = 0.0.0.0

重启mysql

sudo service mysql restart

配置防火墙

sudo ufw allow 3306/tcp

关注