MySQL database operations in Windows 7

The operation method described in this article is only usedNonMsi InstallationProgramWhen the installed MySQL program or MySQL program is copied from another PC to the local machine;

Download or copy the latest MySQL program file to the local machine;

1. Start the service

"[MySQL installation path] \ mysql server 5.5 \ bin \ mysqld" -- defaults-file = "[MySQL installation path] \ mysql server 5.5 \ My. ini"

Note: The my. ini file in the command is generated by the mysqlinstanceconfig.exe program in the MySQL \ bindirectory.

IfMysqlinstanceconfig.exe prompts that the my-template.cnf file cannot be found.

My-template.ini file Renamed

My-template.cnf and then copy to '\[MySQL installation path] \ mysql server 5.5 \ bin "Directory

2. Stop the service

[MySQL installation path] \ mysql server 5.5 \ bin \ mysqladmin-u root Shutdown

3. Remove MySQL Windows Services

[MySQL installation path] \ mysql server 5.5 \ bin \ mysqld-Remove

Note: This Command needs to be executed at the command prompt under the Administrator permission (Start> attachment> email SELECT command prompt> Run as administrator)