Shulou(Shulou.com)06/01 Report--

PhpMyAdmin is a popular MySQL management tool. The installation and configuration methods under Windows are as follows:

Download the XAMPP package, which will have a configured phpMyAdmin environment

Https://www.apachefriends.org/index.html

After downloading the installation package, install it directly

After the installation is completed, the console window will pop up automatically. In future use, you can click the console executor under the installation directory to start the console.

Xampp-control.exe

Click the Start button behind the Apache and MySQL modules to start the service

During the startup of Apache, sometimes the startup fails due to a listening port conflict and an error is reported. Similar error messages are as follows:

17:09:04 [Apache] Error: Apache shutdown unexpectedly.

17:09:04 [Apache] This may be due to a blocked port, missing dependencies

17:09:04 [Apache] improper privileges, a crash, or a shutdown by another method.

17:09:04 [Apache] Press the Logs button to view error logs and check

17:09:04 [Apache] the Windows Event Viewer for more clues

17:09:04 [Apache] If you need more help, copy and post this

17:09:04 [Apache] entire log window on the forums

17:09:12 [Apache] Problem detected!

17:09:12 [Apache] Port 443 in use by "" E:\ Program Files (x86)\ VMware Workstation\ vmware-hostd.exe "- u" C:\ ProgramData\ VMware\ hostd\ config.xml "" with PID 2952!

17:09:12 [Apache] Apache WILL NOT start without the configured ports free!

17:09:12 [Apache] You need to uninstall/disable/reconfigure the blocking application

17:09:12 [Apache] or reconfigure Apache and the Control Panel to listen on a different port

For this error, the solution is to change the listening port and click on the Apache profile httpd-ssl.conf

Modify the listening port

#

# When we also provide SSL we have to listen to the

# standard HTTP port (see above) and to the HTTPS port

#

Listen 4450

# #

After modifying the port, start Apache again until it starts normally

After both Apache and MySQL services are started successfully, enter the management interface through the local web page

Http://192.168.8.99

Click phpMyAdmin in the upper right corner of the page

By default, you do not need a password to connect to the database; if you change the password of the root user, you need to edit the config.inc.php file in the F:\ xampp\ phpMyAdmin directory to change the connection password

The local MySQL server is connected by default. If we want to connect to multiple MySQL servers, we can edit the config.inc.php file in the F:\ xampp\ phpMyAdmin directory and add the database.

In the following configuration parameters, second server is modeled on the database configuration file added by first server.

In this way, after opening the phpMyAdmin page, you can select two databases

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.