How to add a non-root user and login with the same in Navicat for MySQL?
Posted on 2011-03-21
I have installed Navicat for MySQL on Window Server. In Navicat first i created a connection for localhost. After logging in with the localhost, i created a user for database "test" with username as "test" and host as "%". But when i try to log in with the user "test", it gives me error, "Access denied for user "test@localhost".
Is this the right way to create a user?
Also I am unable to login to MySQL remotely?
Do we need to do any settings for remote connections for MySQL?