首页 > 数据库技术 > 详细

linux环境下安装mysql数据库遇到的问题

时间:2016-09-20 06:46:31      阅读:279      评论:0      收藏:0      [点我收藏+]
总结一句话:
安装完mysql数据库记得授权远程登录。
 
坑的现象:
ERROR 1045 (28000): Access denied for user ‘guoxp‘@‘localhost‘ (using password: YES)
 
解决方案如下:
执行前查看状态:
MariaDB [mysql]>  select Host,User,Password from user ;
+-----------------------+-------+-------------------------------------------+
| Host                  | User  | Password                                  |
+-----------------------+-------+-------------------------------------------+
| localhost             | root  |                                           |
| localhost.localdomain | root  |                                           |
| 127.0.0.1             | root  |                                           |
| ::1                   | root  |                                           |
| localhost             |       |                                           |
| localhost.localdomain |       |                                           |
+-----------------------+-------+-------------------------------------------+
6 rows in set (0.00 sec)
 
 
授权:
MariaDB [mysql]> grant select,update,insert,delete on *.* to guoxp@远程登录的ip地址 identified by "远程登录的密码";
Query OK, 0 rows affected (0.00 sec)
 
执行后查看状态:
MariaDB [mysql]>  select Host,User,Password from user ;
+-----------------------+-------+-------------------------------------------+
| Host                  | User  | Password                                  |
+-----------------------+-------+-------------------------------------------+
| localhost             | root  |                                           |
| localhost.localdomain | root  |                                           |
| 127.0.0.1             | root  |                                           |
| ::1                   | root  |                                           |
| localhost             |       |                                           |
| localhost.localdomain |       |                                           |
| 远程登录的ip地址        | guoxp | *FA074CDA355DAA0D0E53ABE2885985ECEB743D7A |
+-----------------------+-------+-------------------------------------------+
7 rows in set (0.01 sec)

linux环境下安装mysql数据库遇到的问题

原文:http://www.cnblogs.com/jack1208-rose0203/p/5887338.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!