# service mysqld stop Shutting down MySQL. SUCCESS!
# mysqld_safe --skip-grant-tables &
[root@centos01 server]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.20-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
无需密码进入mysql数据库
如果不成功的话:
[root@centos02 bin]# vi /etc/my.cnf [mysqld] skip-grant-tables #加上这句话
[root@centos02 bin]# service mysqld restart Shutting down MySQL.. SUCCESS! Starting MySQL.. SUCCESS! [root@centos02 bin]# ls innochecksum mysql_client_test_embedded mysql_secure_installation msql2mysql mysql_config mysql_setpermission myisamchk mysql_convert_table_format mysqlshow myisam_ftdump mysqld mysqlslap myisamlog mysqld-debug mysqltest myisampack mysqld_multi mysqltest_embedded my_print_defaults mysqld_safe mysql_tzinfo_to_sql mysql mysqldump mysql_upgrade mysqlaccess mysqldumpslow mysql_waitpid mysqlaccess.conf mysql_embedded mysql_zap mysqladmin mysql_find_rows perror mysqlbinlog mysql_fix_extensions replace mysqlbug mysqlhotcopy resolveip mysqlcheck mysqlimport resolve_stack_dump mysql_client_test mysql_plugin [root@centos02 bin]# ./mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.40-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
mysql> update user set password = password('123') where user = 'root';#这样不行,必须清空密码!!
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+------+-----------+-------------------------------------------+
1 row in set (0.00 sec)
mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
[root@centos02 bin]# vi /etc/my.cnf #将刚才在[mysqld]的段中加上的skip-grant-tables删除 [root@centos02 bin]# service mysqld restart Shutting down MySQL. SUCCESS! Starting MySQL.. SUCCESS! [root@centos02 bin]# ./mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.40-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root@DB bin]# /etc/init.d/mysqld stop
Shutting down MySQL. SUCCESS!
[root@DB bin]# mysqld_safe --skip-grant-tables &
[root@DB bin]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.40-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> select user,host,password from user;
+--------+-----------+-------------------------------------------+
| user | host | password |
+--------+-----------+-------------------------------------------+
| root | 127.0.0.1 | |
| zabbix | % | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+--------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
mysql> update user set host="localhost" where user="root";
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host,password from user;
+--------+-----------+-------------------------------------------+
| user | host | password |
+--------+-----------+-------------------------------------------+
| root | localhost | |
| zabbix | % | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+--------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
mysql>
[root@DB bin]# service mysqld status
SUCCESS! MySQL running (2730)
[root@DB bin]# /etc/init.d/mysqld stop
Shutting down MySQL.160612 18:46:19 mysqld_safe mysqld from pid file /usr/local/mysql/data/DB.pid ended
SUCCESS!
[1]+ Done mysqld_safe --skip-grant-tables
[root@DB bin]# service mysqld start
Starting MySQL.. SUCCESS!
[root@DB bin]# mysql -uroot -p
Enter password: #密码为空
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.40-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> use mysql
Database changed
mysql> update user set password=('') where user='root';#应该是update user set password=password("newpassword") where user="root";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> select user,host,password from user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
+------+-----------+----------+
1 row in set (0.00 sec)
#注释掉/etc/my.cnf 中的skiip-grant-tables后重启服务器 并重新设置密码,新密码有效!
mysql> update user set password=("3006") where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select user,host,password from user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | 3006 |#这种情况不对(即可见,最重要的是不能用!)
+------+-----------+----------+
1 row in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@DB-S ~]# mysqladmin -uroot password
New password:
Confirm new password:
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *5E9021B1C46435835981A94A7087707B3465144B |
+------+-----------+-------------------------------------------+
1 row in set (0.00 sec)