phpMyAdmin Error: #2003 Unable to login to the Mysql server solution _mysql

Source: Internet
Author: User
When connecting to MySQL database via phpMyAdmin: "2003 unable to log on to MySQL server" ... It is clear that this is not the start of the MySQL service, right click My Computer-admin-find a service to find the MySQL boot up, and is not the start of the error:

"Unable to start the MySQL service error 1067: Process abort unexpectedly"

Then Baidu Google it, many are 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 look at their own experience and the study of the problem, well not much

Said, I was in accordance with the following methods to solve, for reference only:

First step

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

Second step  

Open the corresponding installation directory \mysql\bin\winmysqladmin.exe enter a username and password (also ignore this step)   The third step of the

is to enter the MySQL bin directory under DOS. &NBSP

Example: Installation directory is D disk pc_webserver\mysql\bin 

Start-run-cmd >_ BH,/d '  

D:// First switch to D disk  

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

and then enter the Mysqld-nt-remove Delete service  
then enter MYSQLD-NT-INSTALL&NBSP

Step fourth    Restart the MySQL service   

It ' s ok! &NBSP


ran into this error today, not using this method--! , so call, Baidu,google read several articles for n hours, unsuccessful. Finally use this method to solve: (Platform winser2003)  

Uninstall MySQL, reinstall:  
  
Since my MYQL database of physical files and my MySQL installation directory is not in one place (this setup saved this time!) &NBSP

And this time because the MySQL installation directory was completely destroyed by antivirus software, I reinstalled a MySQL, install the password to ensure that the same as before! (After successful installation, copy My.ini file to C:\Windows). &NBSP

My mysql is not official, because I have a problem installing on my server, I download an integrated environment, but I only use the mysql,ok!~~ thank goodness  in the integrated environment;

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.