1.查看linux系统版本
cat /proc/version
2.查看mysql版本
mysql –version
3.启动mysql
sudo /etc/init.d/mysql start
4.查看mysql状态
service mysql status
5.查找my.cnf路径
sudo find / -name my.cnf
结果:/etc/mysql/my.cnf
6.登录mysql
mysql -u root -p
7.解决mysql无法远程连接
设置远程连接权限
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘pwd4aliyun’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
编辑/etc/mysql/my.cnf
sudo vi /etc/mysql/my.cnf
注释bind-address = localhost
:wq! 强制保存文件,并退出vi
重启服务sudo /etc/init.d/mysql restart