|
在ROOT用户下运行下面两条SQL语句。
GRANT SELECT,INSERT,UPDATE,DELETE ON BPH_DB.rph_field TO "ah_huizhou"@"%" IDENTIFIED BY "an_huizhou";
GRANT SELECT,INSERT,UPDATE,DELETE ON BPH_DB.rph_light TO "ah_huizhou"@"%" IDENTIFIED BY "an_huizhou";
退出MYSQL后,重新以ah_huizhou连接,提示如下:
[hg@HGECOL ~]$ /usr/local/mysql/bin/mysql -u ah_huizhou -p
Enter password:
ERROR 1045 (28000): Access denied for user 'ah_huizhou'@'localhost' (using password: YES)
WHY?? |
|