Mysql Study Notes-mysql database installation and mysql Study Notes

Mysql Study Notes-mysql database installation and mysql Study Notes

1. Run the mysql installation package and select Custom installation (the installation path should not contain Chinese characters; otherwise, an error will occur during installation !)

2. For a mysql instance to be successfully operated, three parts are required: server side, data segment, and data.

3. Server Software Directory:

4. Data directory:

Click Install.

5. Here mysql has been installed, and some configuration will be made for mysql. For example, you can configure the maximum number of connections allowed by mysql and whether mysql can log on remotely.

7. Machine Type:

8. whether transactions are supported

9. innodb tablespace:

10. Number of connections

11. Character Set setting

Finally, execute the configuration.

Next, go to the bin directory under the mysql installation directory to view the information:

Connection Server:

The installation and logon of the mysql database are complete.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.