Regarding MySQL connectivity - Access denied message

Newsletter Subscription | Glossary | Contact Us

Home > All Categories > MySQL > Errors > Regarding MySQL connectivity - Access denied message

Regarding MySQL connectivity - Access denied message

Authored by: Arthur Cohen
Viewed: 438 times so far

I am using fedora linux for Mysql server database which is running fine and when i trry to connect from the windows workstation i get following error :

#28000 Access denied for user 'fin'@'guppy.internal.zone'
(using password: YES)

Answer:

The MySQL error indicated that that your database user has no enough privilege to connect with the server.

Solution :

If you're running your own MySQL server, you may need to give your MySQL user proper privileges. Log in to MySQL command prompt as the MySQL root user and issue these commands:

grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
or
grant select,insert,update,delete on *.* to 'myuser'@'myhost'

To find out other possible causes, please check this article .

Click Here to View all the questions in Errors category.

File Attachments