Solved

How to add a non-root user and login with the same in Navicat for MySQL?

Posted on 2011-03-21
2
593 Views
Last Modified: 2012-06-22
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?
0
Comment
Question by:aplusexpert
2 Comments
 
LVL 17

Expert Comment

by:Shinesh Premrajan
ID: 35186865
Instead if % provide an IP adderss of the system.

Also after creating a user, always Flush the MySQL privileges, sometime a MySQL restart, but thats not needed here.

Hope this helps
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 35190362
Have you tried it using sql?
http://dev.mysql.com/doc/refman/5.1/en/create-user.html
CREATE USER 'username'@'%' IDENTIFIED BY 'password';

then ensure to GRANT permissions to specific databases|tables for the user if not going to grant *all* to basically create a remote dab without exposing root beyond localhost access which is a best practice.

You can limit this to an IP address if needed but that is not a requirement to get this to work.

Kevin
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question