Home  >  Article  >  Database  >  What should I do if phpmyadmin encounters a 2003 error and cannot log in?

What should I do if phpmyadmin encounters a 2003 error and cannot log in?

coldplay.xixi
coldplay.xixiOriginal
2020-07-20 09:17:071619browse

Solution to the phpmyadmin 2003 error that cannot be logged in: first delete [my.ini], and open the directory to enter the user name and password; then enter the Bin directory of mysql under dos to perform related operations; finally, restart mysql Just serve.

What should I do if phpmyadmin encounters a 2003 error and cannot log in?

Solution to phpmyadmin 2003 error unable to log in:

First step, Delete my.ini under c:\windows (you can change it to another name first)

Second step, Open \mysql\bin\winmysqladmin.exe in the corresponding installation directory and enter User name and password (you can also ignore this step)

The third step, Under dos, enter the bin directory of mysql.

Example: The installation directory is PC_webserver\mysql\bin on the d drive, Start-Run-cmd, d: //Switch to the d drive first, D:\>cd PC_webserver \mysql\bin //Enter bin through the cd directory;

Then enter mysqld-nt -remove to delete the service;

Then enter mysqld -nt -install.

The fourth step, Restart the mysql service

It`s OK!

Finally used this method to solve: (Platform winser2003)

Uninstall mysql and reinstall:

Because the physical files of my myql database are different from my The installation directory of mysql is not in the same place (this setting saved this time!)

The reason this time was that the installation directory of mysql was completely destroyed by anti-virus software, so I reinstalled it. Mysql, the password during installation must be consistent with the previous one! (After successful installation, copy the my.ini file to c:\windows).

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if phpmyadmin encounters a 2003 error and cannot log in?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn