Solved

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

Posted on 2011-03-21
2
592 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PHP strip quotes and line feeds out of array 13 48
myqsl update statement on phpMyAdmin 8 21
Sql query on a varchar that is numeric. 8 26
MySQL  on Tomcat 8 27
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now