The MySQL service has been started, but the report 2003-----has been resolved

Source: Internet
Author: User
Tags learn php

Recently started to learn PHP, installed the WAMP integration environment, MySQL can be opened with phpMyAdmin, but want to use the MySQL console but error: MySQL service cannot start (2003-can ' t connect to MySQL server on ' localhost ' (10061).

Many methods of searching the Internet include:

1. Re-install MySQL service

Mysqld-remove MySQL

Mysqld-install MySQL

net start MySQL service starts but the console still fails to start.

It is not possible to point host to 1270.0.1.

2, see a netizen to provide:

If "Error 2003:can ' t connect to MySQL server on ' localhost ' (10061)" appears, your MySQL has not started yet.

Workaround:

The first step
Remove the My.ini below c:\windowns

Step Two
Open C:\mysql\bin\winmysqladmin.exe Enter user name and password

Step three Enter Mysqld-nt-remove Delete service under DOS
In the next input Mysqld-nt-install

Fourth step input MySQL boot success

Results after the deletion of My.ini, did not find Winmysqladmin.exe, run the next Mysqladmin.exe, the window flashed over, also did not see the user name and password.  After DOS ran the MySQL command, incredibly can. It seems to be the reason to delete My.ini, it is estimated that the file before the configuration is wrong. First Use the ~

The MySQL service has been started, but the report 2003-----has been resolved

Related Article

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.