Solved

New created user name can't access phpadmin and mysql

Posted on 2014-11-17
4
205 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40449307
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 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40449314
0
 

Author Closing Comment

by:AXISHK
ID: 40461177
Tks
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40461211
You're welcome.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

627 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