MySQL Green Edition installation Problem resolution (ERROR 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061))

The original has been using the MySQL installation version has not experienced problems, today in the installation of the green version of MySQL has a problem

After the installation of the Windows service succeeds, the prompt starts successfully with net start MySQL, but when I connect to MySQL the following error is reported:

ERROR 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061)

My.ini File Contents:

[Mysqld]
Basedir=e://databases//mysql
Datadir=f://databases//mysql//data

Operation:

Then, after remove the service, so repeated many times or the same mistake, really want to faint!

After that, there are several system directories found in the MySQL installation directory in the data directory, so the DataDir value in the My.ini file is set to this directory.

The main configuration after the change is:

[Mysqld]
Basedir=e://databases//mysql
Datadir=e://databases//mysql//data

Basedir: Place directory for your database program

DataDir: For your database Data directory

After you reinstall the service, the logon succeeds after you start the service.

Note: If you want to assign DataDir to a different directory, you will need to copy the files and directories under the data directory in the installation directory to the directory you specified.

:

Summarize:

The main reason for this problem is that the database data directory that you specified does not contain the system's database files.

If you set the database directory to a different directory (not the data directory under the installation directory), you will need to copy the files and directories in this directory to the directory you have indicated.

MySQL Green Edition installation Problem resolution (ERROR 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061))