Shulou(Shulou.com)06/01 Report--

The editor will share with you how to compress and install mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

1. Download the compressed package at address 1 (download on the official website): https://www.mysql.com/downloads/

Address 2 (Baidu network disk): https://pan.baidu.com/s/12lnpcr3thBe9k-6CyxvHeg extraction code: j9ya

The method to download the official website is as follows:

two。 Extract the package to your favorite folder; (in my case, D:\ newdream\ mysql\ mysqlserver, replaced by the installation path later)

3. To set the environment variable, right-click my computer-> Properties-> Advanced system Settings-> Environment variable-> find path in the system variable, click Edit, and add "; installation path\ bin;". (paths are separated by semicolons ";" for example: d:\ newdream\ mysql\ mysqlserver\ bin;)

4. Go back to the installation directory and add a notepad to the directory. Change the name to my and the suffix to .ini.

5. Open my.ini in notepad and add the following:

[mysqld] port = 3306 basedirholders DVDs port = 3306 basedirholders DVDs New dreamThink mysqlserverdatadirholders DVDs NewdreamUnips mysqlserverDB datamaxconnections200The setserverUTF8defaultof storageengineered INNODBsqldatabases modecodes no colors ENGINESTITUTION vehicles STRANS _ tables [MySQL] default-character-set=utf8

Note: the path after basedir and datadir is the path of your own directory

My path is D:/newdream/mysql/mysqlserver.

Be sure to change the "\" in the path to "/"

6. Open the cmd window as an administrator

Enter the following path to change the execution location:

Cd / d (the path to the bin directory under the installation directory) such as: cd / d D:\ newdream\ mysql\ mysqlserver\ bin

7. Enter the following command to install the sql service:

Mysqld-install

After executing the command, the prompt Service successfully installed. Indicates that the installation is successful (if cmd is not opened by an administrator, it will not be passed here)

8. Enter the following command to initialize the sql service:

Mysqld-initialize-insecure-user=mysql

After executing the command, the data file is generated in the directory and the root user is created.

9. Enter the following command to start sql:

Net start mysql

After execution, there will be the following prompt:

The MySQL service is starting... the MySQL service has been started successfully.

10. Enter the following command to enter sql to change the password

Mysqladmin-u root-p password

Pop-up Enter password:

At this time, the system does not have a password, you can enter directly, then set a new password, and enter it again. Set password complete.

11. Enter mysql-u root-p password to enter sql.

After reading this article, I believe you have a certain understanding of how to compress the installation of mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.