ubantu 安装mysql

67 阅读1分钟

更新apt

sudo apt update

安装MySQL服务器

sudo apt install mysql-server

启动mysql

service mysql start

登录myql

 mysql -u root -p
 #连续回车,初始化无密码

修改root远程登录

use mysql;
CREATE USER 'root'@'%' IDENTIFIED BY 'zyld@123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
#如果报错
ALTER USER 'root'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'zyld@123';
FLUSH PRIVILEGES;
vim /etc/mysql/mysql.conf.d/mysqld.cnf

image.png

image.png