MySQL 数据库 简单操作命令 （部分总结）

ps - ajx|grep mysql 

mysql -u用户名 -p密码

sudo service mysql start

sudo service mysql stop

sudo service mysql restart

show databases；

use mysql

show tables

select user ，host from user；

grant all privileges on *.* to 用户名（root）@“%” identified by "密码" with grant option；

delete from user where user=’root’ and host = ‘localhost’;

flush privileges; 

sudo  vi /etc/mysql/mysql.conf.d/mysqld.cnf

sudo service mysql restart

is_Delete