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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
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, fr…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

815 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

8 Experts available now in Live!

Get 1:1 Help Now