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

The following mainly brings you the process of modifying the password of the mysql database. I hope that the process of modifying the password of the mysql database can bring you practical use, which is also the main purpose of my editing this article. All right, don't talk too much nonsense, let's just read the following.

1. Apache shutdown unexpectedly startup error

The error displayed when xampp starts is:

9:52:41 [Apache] Attempting to start Apache app...

9:52:41 [Apache] Status change detected: running

9:52:42 [Apache] Status change detected: stopped

9:52:42 [Apache] Error: Apache shutdown unexpectedly.

9:52:42 [Apache] This may be due to a blocked port, missing dependencies

9:52:42 [Apache] improper privileges, a crash, or a shutdown by another method.

9:52:42 [Apache] Check the "/ xampp/apache/logs/error.log" file

9:52:42 [Apache] and the Windows Event Viewer for more clues

This is a common problem in which ports 80 and 443 are occupied, and the solutions are as follows:

(1) Port 443 is occupied:

Change listen 443 to 444 in the / xampp/apache/conf/extra/httpd-ssl.conf configuration file (this port can be defined by yourself)

(2) Port 80 is occupied and apache cannot listen to port 80

Change Listen 80 to 88 in / xampp/apache/conf/extra/httpd.conf (customizable); if vhosts is configured, change the port in httpd-vhosts.conf to 88 (same as the port number above)

Link description

2. Phpmyadmin access denied

The error when phpmyadmin access is denied is as follows:

PhpMyAdmin tried to connect to the MySQL server, but the server refused to connect. You should check the host, user name, and password in the configuration file and verify that this information is consistent with the information given by the MySQL server administrator.

The cause of the error:

The password of root in mysql.user has been modified so that it is inconsistent with the password in the phpMyAdmin configuration file, so the connection cannot be made.

Solution:

Modify the password of $$cfg ['Servers'] [$I] [' password'] = 'yourpassword'; / / above set for root in.. / phpMyAdmin/config.inc.php

3. Mysql changes the initial password

(1) win+R, enter cmd to enter the cmd command prompt, and enter mysql-uroot-p

(2) if "mysql is not an internal or external command, nor is it a runnable program or batch file", it means that the mysql configuration path is not placed under the environment variable, and the path containing mysql.exe and mysqld.exe files needs to be placed under the system environment variable.

(3) enter the database password, and the successful login is shown as follows:

(4) after logging in successfully, enter show databases; to see all databases

(5) enter use mysql; to select mysql database, which is the place where the user name is saved.

(6) when show tables looks at all the tables, he will find a user table, which stores account information such as user name, password, permissions, etc.

(7) enter select user,host,password from user; to view account information.

(8) change the root password and enter update user set password=password ('123456') where user='root' and host='localhost'

(9) check the account information again and select user,host,password from user; can see that the password has been changed.

(10) exit the command line, restart the mysql database, and try to log in with the new password.

At this point, you have completed the modification of the mysql database. These are some minor problems encountered when configuring mysql. Record them here.

For the above about the change of mysql database password process, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

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.