Error reported by phpmyadmin: resolution of 2003 failure to log on to MySQL server
- 2020-05-13 03:36:15
- OfStack
When connecting to mysql database via phpmyadmin, prompt: "2003 unable to log in MySQL server"... Clearly this is not starting the mysql service, right click on my computer - admin - find the service, find the mysql boot 1, is there an error in the boot:
"Unable to start mysql service error 1067: process aborted unexpectedly"
Then on baidu google, most is to ban remote connection, to change my.ini file, also said firewall, in short, the right medicine.
But for the same error, it's not all the same. This is to see their own experience and the study of the problem, not much
Said, I am according to the following method to solve, just for reference:
Step 1
Delete my.ini under c:\windowns (can be changed to another name first)
Step 2
Open the corresponding installation directory \mysql\bin\ winmysqladmin.exe enter username and password (you can also ignore this step)
Step 3, under dos, go to the bin directory of mysql.
Example: install PC_webserver\mysql\bin from d disk
start-run-cmd > _ bH ,/D'
d: // first switch to d under disk
D:\ > cd PC_webserver\mysql\bin // access to bin via cd directory
Then enter mysqld-nt-remove to delete the service
Then enter mysqld-nt-install
Step 4 restart the mysql service again
It ` s OK!
Today again encountered this error, use this method can not -! I read several articles and worked on n for several hours, but it didn't work. Finally, use this method to solve :(platform winser2003)
Uninstall mysql and reinstall:
Since the physical files of my myql database and my mysql installation directory are not in one place (this setting saved this time!)
The reason for this is that the installation directory of mysql was completely destroyed by anti-virus software, so I reinstalled mysql once, and the password should be the same as the previous one when installing it! (after successful installation, copy my.ini to c:\windows).
I didn't use an official mysql, because I had problems installing it on my server, so I downloaded an integrated environment, but I only used mysql, OK! ~ ~ thank goodness
"Unable to start mysql service error 1067: process aborted unexpectedly"
Then on baidu google, most is to ban remote connection, to change my.ini file, also said firewall, in short, the right medicine.
But for the same error, it's not all the same. This is to see their own experience and the study of the problem, not much
Said, I am according to the following method to solve, just for reference:
Step 1
Delete my.ini under c:\windowns (can be changed to another name first)
Step 2
Open the corresponding installation directory \mysql\bin\ winmysqladmin.exe enter username and password (you can also ignore this step)
Step 3, under dos, go to the bin directory of mysql.
Example: install PC_webserver\mysql\bin from d disk
start-run-cmd > _ bH ,/D'
d: // first switch to d under disk
D:\ > cd PC_webserver\mysql\bin // access to bin via cd directory
Then enter mysqld-nt-remove to delete the service
Then enter mysqld-nt-install
Step 4 restart the mysql service again
It ` s OK!
Today again encountered this error, use this method can not -! I read several articles and worked on n for several hours, but it didn't work. Finally, use this method to solve :(platform winser2003)
Uninstall mysql and reinstall:
Since the physical files of my myql database and my mysql installation directory are not in one place (this setting saved this time!)
The reason for this is that the installation directory of mysql was completely destroyed by anti-virus software, so I reinstalled mysql once, and the password should be the same as the previous one when installing it! (after successful installation, copy my.ini to c:\windows).
I didn't use an official mysql, because I had problems installing it on my server, so I downloaded an integrated environment, but I only used mysql, OK! ~ ~ thank goodness