提示:以下操作均在root权限下进行。
1查看有没有安装MySQL:
dpkg -l | grep mysql
2.安装mysql
apt install mysql-server
3.检查是否安装成功
netstat -tap | grep mysql
4.本地登录mysql
mysql -u root -h localhost -p
5.查看数据库
show databases; (要加;号)
6.进入指定数据库
use [数据库名]
7.查看表信息
2.远程连接
确保3306端口关闭防火墙,修改mysql数据库下的user表信息
1.User用户root的Host是localhost
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123’;
2.User用户root的Host是%
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123’;
参考连接
https://www.cnblogs.com/opsprobe/p/9126864.html