Access denied for user 'faisal'@'localhost'

FreePBX System Administration
1

HI Team,

I have a user with privileges on mysql on freepbx 16.

±-------±--------------+
| User | Host |
±-------±--------------+
| faisal | 127.0.0.1 |
| faisal | 172.16.10.210 |
| faisal | 172.16.10.34 |
| faisal | 172.16.102.13 |
| faisal | localhost |
±-------±--------------+

I have given access to this user on specific hosts but when I connect via localhost I get the error.

mysql -u faisal -p
ERROR 1045 (28000): Access denied for user ‘faisal’@‘localhost’ (using password: YES)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON . TO ‘faisal’@‘localhost’;
Query OK, 0 rows affected (0.00 sec)

but still not able to login via user faisal.

2

Don’t forget to flush privileges;after making such a change.

3

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.