linux環境下安裝mysql資料庫遇到的問題

標籤：

總結一句話：安裝完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 [email protected]遠程登入的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資料庫遇到的問題