辰枫的MySQL和NoSQL学习笔记

骐骥一跃,不能十步;驽马十驾,功在不舍。

  • 博客访问: 988704
  • 博文数量: 526
  • 用 户 组: 普通用户
  • 注册时间: 2015-12-07 17:58
  • 认证徽章:
个人简介

智慧星光高级MySQL DBA。 提供北京或河南地区MySQL、Oracle和MongoDB数据库的技术支持(性能调优,故障处理,安装升级,数据恢复等). 微信和QQ:410294 邮箱:cn_chenfeng@126.com

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(526)

文章存档

2017年(236)

2016年(242)

2015年(48)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

分类: MySQL

-bash-4.2$ service mysql status
 SUCCESS! MySQL running (2670)
-bash-4.2$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

以下是密码忘记的解决方法:

修改MySQL的参数设置: 
# vi /etc/my.cnf 
在[mysqld]的段最后一行加上一句:skip-grant-tables 
例如: 
[mysqld] 
........................
log-bin=mysql-bin
innodb_data_file_path = ibdata1:12M;ibdata2:100M;ibdata3:300M:autoextend
innodb_file_per_table=on
max_connections=500
skip-grant-tables    --新增加行
保存并且退出vi.

重启MySQL服务:
[root@chenfeng subsys]# service mysql restart
Shutting down MySQL. SUCCESS! 
Starting MySQL. SUCCESS! 

-bash-4.2$ mysql    --不用输密码直接登录
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.15-log Source distribution


Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MySQL [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| chenfeng           |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)


MySQL [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
MySQL [mysql]>  UPDATE user SET Password = password ('12345678') WHERE User ='root';   --修改为新密码12345678
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

MySQL [mysql]> 
MySQL [mysql]> flush privileges;   --刷新一下权限表
Query OK, 0 rows affected (0.00 sec)

MySQL [mysql]> quit
Bye

将MySQL的参数设置修改回来:
# vi /etc/my.cnf 
将刚才在[mysqld]的段中最后一行加上的skip-grant-tables删除,然后保存退出。
 
重启MySQL服务:
[root@chenfeng subsys]# service mysql restart
Shutting down MySQL. SUCCESS! 
Starting MySQL. SUCCESS! 


重新用新密码登录:
-bash-4.2$ mysql -u root -p12345678      --12345678为新密码
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.6.15-log Source distribution


Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MySQL [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
MySQL [mysql]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| chenfeng           |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

MySQL [mysql]> 
阅读(99) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册