Solved

MySQL on wampserver

Posted on 2014-11-17
8
481 Views
Last Modified: 2014-11-18
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
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
  • 4
  • 4
8 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40446728
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
 

Author Comment

by:AXISHK
ID: 40446733
Yes, it works. How to change the root password within the interface.... can find it ?

Tks
0
 

Author Closing Comment

by:AXISHK
ID: 40446735
Find the location, Tks
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 83

Expert Comment

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

Author Comment

by:AXISHK
ID: 40446790
Should I change those with "Grant = Yes" in the attached file ? ie, in total 3 records in the attached file ? Tks
phpMyAdmin.png
0
 
LVL 83

Expert Comment

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

Author Comment

by:AXISHK
ID: 40449044
Tks. Any further instruction on how to config.inc.php ? I have changed through GUI and it block my web access right now.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40449235
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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
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…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

734 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