Solved

MySQL on wampserver

Posted on 2014-11-17
8
479 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
php date function ( diffrence between two dates ) 6 40
EditableGrid how to fetch rows from MySql in php 14 44
How Close unsubmited attempts 10 42
PHP SMTP authentication 6 23
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
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…
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.

679 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