[Solved] Mysql Permissions?

[lukaslt]

So you use navicat on centos?

 

Simply connect to your mysql from centos using navicat, click on Users menu, then add a new one. 

In Hostname field put: %

Then put the username and password, save and switch to permissions tab, check them all and save

Now you should be able to connect to your mysql from desktop.

 

If you still cant, check out the firewall on your centos, opening the port: 3306

 

Oh thanks, forgot about %. was putting my IP in it .