Navicat连接阿里云mysql
mysql启动服务等
service mysql start
service mysql stop
service mysql restart
数据库切换与权限设置
use database_name
grant privileges *.* to 'root'@'%' indentified by "code" with grant option
flush privileges
权限查看
select user, host from user
mysql文件配置
vi /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 127.0.0.1改为0.0.0.0
character-set-server=utf8