mysql重置密码和mysql error 1044(42000)错误
#mysql错误:(密码不正确,需要重置密码)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
#编辑配置文件
[root@m1 mysql]# vi /roobo/server/mysql/my.cnf
[mysqld]
skip-grant-tables
#修改完后重启服务
[root@m1 mysql]# /etc/init.d/mysqld restart
#登录数据库
[root@m1 mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.24-log Source distribution
Copyright (c) 2000, 2015, 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;
mysql> update user set password=password("你的新密码") where user="root";
mysql> flush privileges;
mysql> quit
#再把vi my.cnf 配置文件中下面参数删除。
[mysqld]
skip-grant-tables
#修改完后重启服务
[root@m1 mysql]# /etc/init.d/mysqld restart
#再用设置的密码登录
mysql -uroot -p
passwd:******
mysql error 1044(42000)错误
[root@m1 ~]# mysql -uroot -p
Enter password:
ERROR 1049 (42000): Unknown database '127.0.0.1'
[root@m1 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.6.24-log Source distribution
Copyright (c) 2000, 2015, 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> grant all on work.* to work@'192.168.1.4' identified by 'juan3652014';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'work'
原因: 授权需要WITH GRANT OPTION 才能授权,否则会报。
mysql> show grants for root@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*F109C974766912D490ECD7E3C8754542FC773A49' |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
解决方法:
#登录mysql
mysql -uroot -p -h 127.0.0.1
mysql> use mysql
Database changed
mysql> select user,host from user;
+--------+-------------+
| user | host |
+--------+-------------+
| root | 127.0.0.1 |
| rep | 192.168.1.% |
| work | 192.168.1.4 |
| root | localhost |
| zabbix | localhost |
+--------+-------------+
5 rows in set (0.00 sec)
#授权成功
grant all on work.* to work@'192.168.1.4' identified by 'juan3652014';
flush privileges;
如上所示,root@localhost账号没有WITH GRANT OPTION选项,关于WITH GRANT OPTION选项,如果想让授权的用户,也可以将这些权限授予给其他用户,需要选项 “WITH GRANT OPTION“ 。也就是说有这个选项就可以将权限传递给第三方。这也是上面root@localhost用户给其它用后授权报错的原因,如果以 root@127.0.0.1登录(此账号拥有WITHGRANT OPTION选项),创建用户并授权就不会有这个错误。
最新文章
- 港真,到底应该选择OA还是BPM?
- .net session_end
- 响应式字体(js控制)
- 写入文件(txt格式)
- EBS中启用OAF页面个性化三个配置
- apache配置Options详解
- SSH框架总结(框架分析+环境搭建+实例源码下载) 《转》
- Linux创建线程
- android中的DatePicker与TimePicker
- ThinkPad E40无线网卡驱动安装 FOR CENTOS6.3
- PC110304/UVA850
- 运行CImg库笔记
- OpenGL红宝书第一个例子:绘制两个三角形
- 网页解析的全过程(输入url到展示页面)
- php5.4下配置zend guard loader
- Example016实现下拉框
- 小白的Python之路 day5 re正则模块
- TF中conv2d和kernel_initializer方法
- BZOJ_3555_[Ctsc2014]企鹅QQ_哈希
- echo 输入背景和字体常用方法
热门文章
- LeetCode解题报告—— Median of Two Sorted Arrays
- 《逐梦旅程 WINDOWS游戏编程之从零开始》笔记7——DirectInput&;纹理映射
- 机器学习方法(八):随机采样方法整理(MCMC、Gibbs Sampling等)
- Linux 基础——查看文件内容的命令
- 邂逅Sass和Compass之Sass篇
- react native 生成APK
- YII2 源码阅读 综述
- 快速判断&;求出区间相交的长度
- BZOJ2654/COGS1764 [2012国家集训队]tree(陈立杰) [生成树,二分]
- webstorm中.vue报错