mysql语句添加管理员_给mysql添加一个管理员的SQL语句

insert into mysql.user

SELECT '%', 'admin', PASSWORD('admin'), Select_priv, Insert_priv, Update_priv,

Delete_priv, Create_priv, Drop_priv, Reload_priv,

Shutdown_priv,  Process_priv, File_priv, Grant_priv, References_priv,

Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv,

Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,

Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv,

Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject,

max_questions, max_updates, max_connections, MAX_USER_CONNECTIONS

FROM mysql.user WHERE user='root';

最近安装了一个东西, 自带MYSQL, 不知道ROOT密码, 并且限制只能在本地登录. 加一个用户进去 更方便.