安装MySQL
$ sudo apt update
$ sudo apt install mysql-server
进行初始化配置
$ sudo mysql_secure_installation
查看MySQL版本
$ mysql --version
查看MySQL运行状态
systemctl status mysql.service
进行连接
$ sudo mysql -u root -p
远程连接配置
-
$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
打开文件注释掉bind-address=127.0.0.1
-
重启MySQL服务
$ sudo /etc/init.d/mysql restart
或$ sudo systemctl restart mysql.service
-
连接MySQL
$ sudo mysql -u root -p
-
创建远程连接账户并授权
mysql> use mysql;
mysql> CREATE USER 'root'@'%' IDENTIFIED BY '123456';
mysql> grant all privileges on *.* to 'root'@'%';
-
如果远程连接时报错plugin caching_sha2_password could not be loaded,执行
mysql> alter user 'root'@'%' identified with mysql_native_password by '123456';
-
刷新权限
mysql> FLUSH PRIVILEGES;
-
查看用户
mysql> select host, user, authentication_string, plugin from user;
-
使用Navicat远程连接