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;
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