Wamp link MySQL Database

Source: Internet
Author: User
Tags mysql command line

One: Link to your own database

1. Open MySQL command line password is empty then enter
2. Enter use MySQL
3. Execute update user set Password=password (' 123456 ') where user= ' root ';
4. Implementation of the flush privileges;
5. Execution of quit
Change the password for MySQL when the password program is connected

Second: Link to your local database

Recently tried to play PHP, installed Wampservice, because before the computer has been installed MySQL, so I want to use their own MySQL, on the internet did not find the right information, so I thought for a while, finally succeeded, the concrete method is as follows (in this introduction is the 2.5 version):
1. Download Wampservice, install, this does not say, if not yet downloaded friends, you can go to the official website to download http://www.wampserver.com/.
2. After the installation is complete, open the My.ini file to modify the MySQL (wampservice MySQL) port number by default is 3306, I replaced 9906, can be capricious change.

3. Open config.inc.php, make sure the port, username, password with your own installed MySQL has been, the default wampservice mysql password is empty.

4. Start Wampservice will be successful, click phpMyAdmin will enter the database Operations management interface.
5. Since it does not start its own MySQL, so the icon is still yellow, but it does not affect our use, in fact, in such a simple two-step, Wamp will be through the config.inc.php configuration information and the database communication, if the configuration is our own installation of MySQL , it will launch our own installation of MySQL to connect.

Wamp link MySQL Database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.