Mysql常用命令

1.修改密码

mysqladmin -u root -p 'new password'

UPDATE user SET password=PASSWORD("123456") WHERE user='root';

2.修改root权限
grant all on * to "root" identified by "123456";