Mysql操作个人收集

1.MySQL修改root密码

mysql> UPDATE user SET Password=PASSWORD('xxxx') where USER='root';  
mysql> FLUSH PRIVILEGES;  
mysql> quit

把PASSWORD('xxxx')中xxxx替换为你自己的密码