phpMyAdmin #2003 Unable to log on to MySQL server workaround

This article introduces to you phpmyadmin #2003 can not log on to the MySQL server solution, the need for the code farm to reference.

When connecting to the MySQL database via phpMyAdmin: "2003 cannot log in to MySQL server" ... It is obvious that this is not the start MySQL service, right click on My Computer-admin-find the service, find MySQL boot up a bit, and is not starting to have an error:

"Unable to start MySQL service error 1067: Process aborted unexpectedly"

Then Baidu Google Bar, much is said to prohibit remote connection, to change My.ini file, there are also said firewall, in short, the right remedy.

But the same error, the cause of it is not all the same. This is to see their own experience and the study of the problem, not much better

Said, I was resolved as follows, for reference only:

The first step

Delete the My.ini below the c:\windowns (you can change it to another name first.)

Step Two

Open the corresponding installation directory \mysql\bin\winmysqladmin.exe Enter the user name and password (you can also ignore this step)

The third step under DOS, go to the MySQL bin directory.

Example: installation directory for D-disk Pc_webserver\mysql\bin

Start-run-cmd

D://Switch to the D-disk first

D:\>CD Pc_webserver\mysql\bin//through the CD directory into the bin

Then enter Mysqld-nt-remove to delete the service
then enter Mysqld-nt-install

Fourth step and restart the MySQL service

It ' s ok!

Today, we have this mistake again, and use this method to--! , so called, Baidu,google read a number of articles engaged in n hours, unsuccessful. Finally use this method to solve: (Platform winser2003)

Uninstall MySQL, reinstall:

Because my MYQL database of physical files and my MySQL installation directory is not in one place (this setting was saved this time!). ）

This time caused this is the MySQL installation directory is completely destroyed by anti-virus software, I reinstall the MySQL, the installation password to ensure that the same as before! (After successful installation, copy the My.ini file to C:\Windows).

My MySQL is not official, because I installed a problem on my server, I downloaded an integration environment, but I only use mysql,ok!~~ thank in the integrated environment goodness

Original address: http://www.manongjc.com/article/585.html

phpMyAdmin #2003 Unable to log on to MySQL server workaround