Python connects to the database MySQL decompressed version installation configuration and encountered problems

introduction

Today I learned how to connect to the database with Python, so I wanted to install the MySQL database. Unexpectedly, I encountered a lot of setbacks with this small database, so I wrote down my installation process and problems to share with you.

MySQL download link: https://u20538204.ctfile.com/fs/20538204-384372135

step

1. Decompression

2. Configure the environment, add a MYSQL_HOME variable, and add a new path %MYSQL_HOME%\bin in the path;

3. Create a directory and add new files. Create a data folder under the MySQL installation path and add a new file named my.ini

4. Execute the mysqld --initialize statement to generate a series of files in the data folder

5. I executed mysqld --install, but the error "Install/Remove of the Service Denied" suddenly appeared. What should I do? Because we don't have administrator privileges, open Task Manager - File - Run New Task and select "Create this task with system administrative privileges"

6. Enter the bin directory again and run mysqld --install to install mysql

7. Run the net start mysql command to start the service

8. Run mysql -u root -p to log in. There is a temporary password for the first login, which is in the file ending with err in the data folder.

9. Of course, the first thing we do when we log in is to change set password for root@localhost = password('123');

Note: If we encounter The service already exists! during the installation process, or fail to start the MySQL service, we execute sc delete mysql to delete the MySQL service and also delete the files in the data directory, and then execute the above steps. There must be something wrong.

Summarize

The above is the installation and configuration of the unzipped version of Python connecting to the database MySQL and the problems encountered. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!