中国城市建设网网站,公司网站开发费用济南兴田德润简介图片,推广及建设网站,wordpress分类目录添加图片起因#xff1a;刚刚搭建好的mysql数据库#xff0c;做基础优化时#xff0c;不小心把所有用户都删除了#xff0c;并且退出了。没办法#xff0c;只好跳过授权表登录#xff0c;新建root用户。过程如下#xff1a;一、停掉mysql#xff0c;跳过授权登录[rootexplnk-za…起因刚刚搭建好的mysql数据库做基础优化时不小心把所有用户都删除了并且退出了。没办法只好跳过授权表登录新建root用户。过程如下一、停掉mysql跳过授权登录[rootexplnk-zabbix zabbix-2.2.9]# /etc/init.d/mysqld stopShutting down MySQL... SUCCESS![rootexplnk-zabbix zabbix-2.2.9]# mysqld_safe --skip-grant-table [1] 30178[rootexplnk-zabbix zabbix-2.2.9]# 160418 10:49:54 mysqld_safe Logging to /application/mysql/data/explnk-zabbix.err.160418 10:49:54 mysqld_safe Starting mysqld daemon with databases from /application/mysql/data[rootexplnk-zabbix zabbix-2.2.9]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.32 MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql二、创建拥有root权限的用户2.1 错误例子这里最开始遇到个坑使用insert into创建的用户没有任何权限登录之后无法进行操作语句如下INSERT INTO user (Host,User,Password) VALUES(localhost,root,PASSWORD(biscuit));*************************** 2. row ***************************Host: localhostUser: rootPassword: *7495041D24E489A0096DCFA036B166446FDDD992Select_priv: NInsert_priv: NUpdate_priv: NDelete_priv: NCreate_priv: NDrop_priv: NReload_priv: NShutdown_priv: NProcess_priv: NFile_priv: NGrant_priv: NReferences_priv: NIndex_priv: NAlter_priv: NShow_db_priv: NSuper_priv: NCreate_tmp_table_priv: NLock_tables_priv: NExecute_priv: NRepl_slave_priv: NRepl_client_priv: NCreate_view_priv: NShow_view_priv: NCreate_routine_priv: NAlter_routine_priv: NCreate_user_priv: NEvent_priv: NTrigger_priv: NCreate_tablespace_priv: Nssl_type:ssl_cipher:x509_issuer:x509_subject:max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin:authentication_string: NULL2.2 正确方法1mysql use mysqlDatabase changedmysql insert into user (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, Event_priv, Trigger_priv,Create_tablespace_priv,User,Password) values ( Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,gl,gl);Query OK, 1 row affected, 3 warnings (0.06 sec)mysql update user set passwordPASSWORD(explink) where usergl;Query OK, 1 row affected (0.08 sec)Rows matched: 1 Changed: 1 Warnings: 02.3 正确方法2跳过授权表登录后是无法使用grant建立用户的报错如下mysql grant all privileges on *.* to lianglocalhost identified by 123456 with grant option;ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement解决办法只要刷新一下用户权限即可mysql flush privileges;Query OK, 0 rows affected (0.00 sec)mysql grant all privileges on *.* to lianglocalhost identified by 123456 with grant option;Query OK, 0 rows affected (0.00 sec)三、退出登录并重新启动mysql[rootexplnk-zabbix zabbix-2.2.9]# /etc/init.d/mysqld stop[rootexplnk-zabbix zabbix-2.2.9]# /etc/init.d/mysqld start四、登录mysql查看权限[rootexplnk-zabbix zabbix-2.2.9]# mysql -ugl -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.32 MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql select * from mysql.user\G*************************** 3. row ***************************Host:User: glPassword: *5F70B50879BD3B98CB5A945D3A6A7C92F41B8AE8Select_priv: YInsert_priv: YUpdate_priv: YDelete_priv: YCreate_priv: YDrop_priv: YReload_priv: YShutdown_priv: YProcess_priv: YFile_priv: YGrant_priv: YReferences_priv: YIndex_priv: YAlter_priv: YShow_db_priv: YSuper_priv: YCreate_tmp_table_priv: YLock_tables_priv: YExecute_priv: YRepl_slave_priv: YRepl_client_priv: YCreate_view_priv: YShow_view_priv: YCreate_routine_priv: YAlter_routine_priv: YCreate_user_priv: YEvent_priv: YTrigger_priv: YCreate_tablespace_priv: Yssl_type:ssl_cipher:x509_issuer:x509_subject:max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin:authentication_string: NULL3 rows in set (0.00 sec)六、perfect参考bloghttp://my.oschina.net/leejun2005/blog/76140
