简述:
记录mysql的常用操作分类:
1. 账号设置
mysql -uroot -p
输入密码
2. 密码修改
mysqladmin -u root -h localhost password "sql"
3. 设置远程登录
1)
use mysql
update user set host = '%' where user = 'root'
2)
grant all PRIVILEGES on *.* to root@'%' identified by 'sql';
flush privileges;