• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

MySQL on wampserver

After downloading and install WAMPServer, how to check whether MySQL works ?

What's the default login and password for MySQL ? Does the WAMP come with web interface for MySQL ?  Tks
0
AXISHK
Asked:
AXISHK
  • 4
  • 4
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
phpmyadmin is used to 'admin' MySQL.  You should probably see it listed as an app on the home page for WAMP which is usually "http://localhost/".
0
 
AXISHKAuthor Commented:
Yes, it works. How to change the root password within the interface.... can find it ?

Tks
0
 
AXISHKAuthor Commented:
Find the location, Tks
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Dave BaldwinFixer of ProblemsCommented:
Yes but you have to change it in two places.  Find it in c:\wamp\apps\phpmyadmin.xx.x..\config.inc.php.  You will have to change it there and in MySQL itself.  If only one is changed, you won't have access thru phpmyadmin.  You could use phpmyadmin to change it in MySQL but you will be immediately locked out until you change it in the file above.
0
 
AXISHKAuthor Commented:
Should I change those with "Grant = Yes" in the attached file ? ie, in total 3 records in the attached file ? Tks
phpMyAdmin.png
0
 
Dave BaldwinFixer of ProblemsCommented:
Change #5 to have the password.  When you are sure you are able to login with 'root' and a password, delete numbers 1, 2, and 6.  'root' needs the Grant and All Privileges to do the 'admin' work on all the databases.  Number 1 and 2 have no password and you can login with them with no user or password.

For actual applications, you should create new users that are limited to their own databases.
0
 
AXISHKAuthor Commented:
Tks. Any further instruction on how to config.inc.php ? I have changed through GUI and it block my web access right now.
0
 
Dave BaldwinFixer of ProblemsCommented:
Just open config.inc.php in a code or text editor (Not Word!) and change the password in that file.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now