mysql常用操作

1.启动和关闭

sudo systemctl [start|stop|restart] mysql.service

2.查看是否启动

sudo netstat -tap | grep mysql

tcp        0      0 localhost:mysql         *:*                LISTEN      2556/mysqld

3.想要远程连接mysql需要进行如下设置

3.1 修改/etc/mysql/mysql.conf.d/mysqld.cnf

bind-address            = 192.168.0.5

3.2 执行如下操作

mysql -u root -pmysql>use mysql;mysql>update user set host =’%'where user =’root’;mysql>flush privileges;