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

最新推荐文章于 2022-09-12 18:22:48 发布

mrzho

最新推荐文章于 2022-09-12 18:22:48 发布

阅读量1.8k

点赞数

分类专栏：其他文章标签： mysql sql insert ssl user delete

本文链接：https://blog.youkuaiyun.com/mrzho/article/details/5056263

版权

其他专栏收录该内容

2 篇文章

订阅专栏

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密码, 并且限制只能在本地登录. 加一个用户进去更方便.