设置Mysql数据库root账户密码

# service mysqld stop

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

# mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('root') where USER='root';

mysql> FLUSH PRIVILEGES;

mysql> quit

# service mysqld start

# mysql -uroot -p

Enter password: <输入新设的密码root>

mysql>

---

给某台电脑赋予可以用root连接并管理数据库的权限：

service mysqld stop

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

mysql -Dmysql

insert into user(host,user,password) values('<机器名/IP>','root','<Password>');

update user set
　　Select_priv = 'Y',
　　Insert_priv = 'Y',
　　Update_priv = 'Y',
　　Delete_priv = 'Y',
　　Create_priv = 'Y',
　　Drop_priv = 'Y',
　　Reload_priv = 'Y',
　　Shutdown_priv = 'Y',
　　Process_priv = 'Y',
　　File_priv = 'Y',
　　Grant_priv = 'Y',
　　References_priv = 'Y',
　　Index_priv = 'Y',
　　Alter_priv = 'Y',
　　Show_db_priv = 'Y',
　　Super_priv = 'Y',
　　Create_tmp_table_priv = 'Y',
　　Lock_tables_priv = 'Y',
　　Execute_priv = 'Y',
　　Repl_slave_priv = 'Y',
　　Repl_client_priv = 'Y',
　　Create_view_priv = 'Y',
　　Show_view_priv = 'Y',
　　Create_routine_priv = 'Y',
　　Alter_routine_priv = 'Y',
　　Create_user_priv = 'Y'
where user='root';

flush privileges;

quit;

service mysqld stop

service mysqld start