Solved

New created user name can't access phpadmin and mysql

Posted on 2014-11-17
4
191 Views
Last Modified: 2014-11-23
I have installed WAMPServer and create a new user. However, the both the phpadmin and MySQL can't login through.

It works fine for root. Any idea ?

Tks
0
Comment
Question by:AXISHK
  • 3
4 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
That's not true.  I have dozens of different user logins on the MySQL servers in my network.  But... MySQL users are identified by username, password, and source.  If you have created a user that only has an 'anyhost' connection, that user can Not connect thru 'localhost'.  You have to create a second user that is identical Except the the connection is 'localhost' instead of 'anyhost'.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:AXISHK
Comment Utility
Tks
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
You're welcome.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

762 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

12 Experts available now in Live!

Get 1:1 Help Now