Build a minimum MySQL Environment

Blog. csdn. netkuanglong2016articledetails38879979 background. In this case, the best way is to extract the files necessary for MySQL to run. Concepts and

Http://blog.csdn.net/kuanglong2016/article/details/38879979 background knowledge when we develop software especially when creating installation package needs to use MySQL Database Service, but does not need all functions in MySQL package, and the official MySQL package is particularly large. In this case, the best way is to extract the files necessary for MySQL to run. Concepts and

Http://blog.csdn.net/kuanglong2016/article/details/38879979"

Background

The MySQL database service is required when developing software, especially when creating the installation package, but not all functions in the MySQL software package, and the official MySQL package is very large. In this case, the best way is to extract the files necessary for MySQL to run.

Concepts and Principles

Starting MySQL Database Service does not require all files in all MySQL packages

Procedure

1. Download file: MySQL Community Server zip package, decompress
   
2. Copy required files: Keep the directory structure copy the following files and folders to a new folder (such as mysql), and then modify my-*** as needed -***. ini content, and rename it to my. ini
   
   1. Mysql.exe, mysqld.exe, mysqldump.exe, and mysqladmin.exe
      
   2. Data Directory
      
   3. Share/english/errmsg. sys
      
   4. My-small.ini or my-large.ini or... (select an appropriate profile based on business scale)
      
3. The mysql directory copied above contains the files required to create a MySQL service.
4. Start mysql Server: Use cmd to enter the new mysql/bindirectory and run mysqld.exe. If cmd is stopped, the service is started successfully.
   
   1. Stop mysql Server: mysqladmin-u [username]-p [password] shutdown (Ctrl + C cannot be used)
      
5. Start the mysql client: Use another cmd to access the mysql/bindirectory and run mysql.exe to test whether the client is successful.
   
6. Install/uninstall the MySQL service:
   
   1. Run cmd with administrator privileges
      
   2. Go to the mysql/bin directory
      
   3. Run mysqld.exe -- install (install) [service name]
      
   4. Run mysqld.exe -- remove (uninstall) [service name]
      
   5. If the installation or uninstallation is successful, the system returns the success message.
      
   6. Win + R, execute services. msc to view system services
      
7. Start/stop MySQL service: (administrator privilege)
   
   1. Net start mysql
      
   2. Net stop mysql

Summary

None

References

None