Change the port number of the MySQL database in XAMPP

Source: Internet
Author: User

Change the port number of the MySQL database in XAMPP

If you have a MySQL database installed on your computer and you want to use a database that comes with XAMPP, you need to change the port number of the database in the XAMPP to avoid conflicts with the installed database. This example shows an example of changing to a 3307 port number.

  1. Modify the My.ini in MySQL config

    After you save the restart

    But to use phpMyAdmin to manage your own MySQL database, change the database port number associated with the Apache configuration file (exactly the PHP configuration file) as follows.

  2. Change the database port number in Apache

    When you save and then restart Apache, the database that Apache uses by default (the phpMyAdmin managed database) is the XAMPP database.

    Click MySQL Right admin to manage the database that is XAMPP comes with the MySQL database

  3. If you want to build a WordPress site also need to pay attention to the database configuration information in WordPress

    Note: What database is used here is not related to XAMPP, which database is used to configure which database

  4. Goodluck

Change the port number of the MySQL database in XAMPP

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.