Solved

MySQL on wampserver

Posted on 2014-11-17
8
473 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

If you've heard about htaccess and it sounds like it does what you want, but you're not sure how it works... well, you're in the right place. Read on. Some Basics #1. It's a file and its filename is .htaccess (yes, with a dot in the front). #…
In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
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…
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.

785 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