?
Solved

MySQL on wampserver

Posted on 2014-11-17
8
Medium Priority
?
487 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 2000 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
The viewer will learn how to count occurrences of each item in an array.
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.
Suggested Courses

771 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