1. Install/remove of the service denied! error occurred while installing MySQL service
Today in a machine (OS for windows7 64bit) The MySQL5.6.16 database, looked at the next machine, before the installation of MySQL, but did not start the service,
Then opened cmd.exe input mysqld--install, who behold the install/remove of the Service denied! Wrong, Strange.
Check the MySQL related information, the command is not wrong, why the installation service failed, and then carefully think, oh,
Permissions are not enough, I use the normal user rights, EN, open cmd.exe again, but this time to right-click "Run as Administrator", and then type mysqld--install OK, the service installation success!
2.mysql Green Edition installation Problem resolution (ERROR 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061))
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 =d://develop//mysql-5.6.16datadir =d://develop//mysql-5.6.16/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 Windows Green Edition MySQL installation problem solution