linux环境下安装mysql数据库遇到的问题
时间：2021-07-01 10:21:17
帮助过：2人阅读
坑的现象：
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数据库遇到的问题
标签：
