insert into user mysql root_设置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:

mysql>

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

service mysqld stop

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

mysql -Dmysql

insert into user(host,user,password) values('','root','');

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