Linux 下命令操作
啟動(dòng)：service mysqld start
停止：service mysqld stop
重啟：service mysqld restart
查看狀態(tài)：service mysqld status
查看狀態(tài)：systemctl status mysqld.service
進(jìn)入mysql命令行
'''
mysql
'''
查看用戶權(quán)限
'''
show grants for username@localhost;
'''
show grants for george@%;
CREATE DATABASE 數(shù)據(jù)庫(kù)名;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON 數(shù)據(jù)庫(kù)名.* TO 數(shù)據(jù)庫(kù)名@localhost IDENTIFIED BY '密碼';
