錯誤碼： 1045 Access denied for user 'skyusers'@'%' (using password: YES)，deniedskyusers

錯誤碼： 1045 Access denied for user 'skyusers'@'%' (using password: YES)，deniedskyusers
1. 錯誤描述

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";1 queries executed, 0 success, 1 errors, 0 warnings查詢：grant all privileges on *.* to root@"%" identified by "."錯誤碼： 1045Access denied for user 'skyusers'@'%' (using password: YES)執行耗時   : 0 sec傳送時間   : 0 sec總耗時      : 0.003 sec

2. 錯誤原因

串連資料庫的賬戶是skyusers，而不是root

3. 解決辦法

修改下面的MySQL命令

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";

修改成

GRANT ALL PRIVILEGES ON *.* TO skyusers@"%" IDENTIFIED BY ".";

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。