MySQL database installation and use

The downloaded MySQL has two versions: one is. msi, can be installed directly, and then start the service in Services.msc;

The other is to be configured with the following steps:

1. Place the files where you want them, similar to the program installation directory

2. The directory can be added to the environment variable path, to facilitate the use of the command (may restart after the effective)

3. Modify the My-default-ini configuration information, for example: # Basedir = D:\non-installed\mysql-5.6.14-win32

# DataDir = D:\non-installed\mysql-5.6.14-win32\data

4. Command line mysqld-install to install the service, net start MySQL to start the service

5. Command line net stop MySQL stop service, mysqld-remove to uninstall the service

MySQL database installation and use