【mysql】02在ubuntu24安装并配置mysql
安装
sudo apt-get update
sudo apt-get install mysql-server
设置root密码
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
原文地址:https://blog.csdn.net/weixin_45671758/article/details/140477559
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!