Detailed description of MySQL database installation and password configuration, detailed description of mysql

Detailed description of MySQL database installation and password configuration, detailed description of mysql

MySQL was developed by MySQL AB and subsequently acquired by Oracle.

MySQL is a relational database management system.

Community edition and Enterprise Edition

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. because of its small size, fast speed, and low total cost of ownership, especially open source code, PHP and Apache can be used together to form a good development environment

Installation Method:

Installation Method: MSI installation and ZIP Installation

Typical: recommended for Typical Installation

Custom: Custom installation

Complete: fully installed

1. Download MySQL software

1. Go to the oracle official website to download MySQL software

First go to the MySQL official website, click Download, it is recommended to use the Community Version Download http://dev.mysql.com/downloads/

2. Find MySQL Community ServerAt the bottom of the page, you have a selected download version.Linux versionOrWindows,64-bit or 32-bit, WhereHere "X86" refers to 32-bit.

Two versions: ZIP is an installation-Free Software Package. MSI is a Microsoft-specific compression format and a software package to be installed.

Mysql ZIP Archive: compressed version, which must be configured by yourself

Mysql MSI Installer: Installation version, which is automatically configured during installation

The MSI memory is relatively small for personal download. One of them is ZIP.

3. Click DownLoad)

The default download version is 5.7. You can select another version.

4. The following page is displayed, asking you to log on to the user name and password. You can directly skip clicking No thanks, just start my download. download

After the download is complete, prepare for the installation.

1. Rename

Decompress the downloaded version and rename it to mysql.For example, if you install it on an edisk: E: \ mysql

At the same timeMy-default.iniRenameMy. ini

3. environment variable configuration

Right-click my computer or computer --> click Properties --> select Advanced System settings --> click environment variable --> Find PATH in system variable (S), click Edit or double-click it

Add a half-width semicolon to the following path, assign values to the bin path in mysql, and click OK after configuration.

Note the following When configuring the environment:

Be sure to copy to the bin path, such as:; E: \ mysql \ bin;

It must be added later, instead of overwriting the path of the original file.

You must add a half-width semicolon before adding a path to distinguish it from the previous path.

Run the cmd command to install MySQL.

4. Click the Windows icon in the lower left corner, Enter cmd in the search box, and right-click to run as administrator.

5. Enter commands in cmd to install MySQL

First, it is installed in drive C by default, and it is installed in drive E.

Drive letter Switching: Drive letter +: for example, switch to an edisk --> E: Press ENTER

Enter the file path: Cd + file path: cd \ mysql \ bin press ENTER

Install MySQL: Mysqld-install

Start MySQL: Net start mysql if the startup error occurs, it may be that the MySQL environment is configured incorrectly and the path of the file cannot be found. In this case, you need to reconfigure the file. After the startup is successful, execute the next step.

Go to MySQL: Mysql-u root-p

After entering, the prompt "Enter password:" is displayed. You don't need to worry about it. Press Enter directly, because the first time MySQL is installed, there is no password by default, and then the login is successful.

6. MySQL password settings

For security reasons, set the MySQL password: EnterUpdate mysql. user set password = PASSword ('000000') where user = 'root ';Press enter (remember to include a semicolon at the end of the input)

If yesModify the root password: UPDATE mysql. user set password = password ('new password') WHERE User = 'root ';After the modification is successful, you can use it after logging out and logging on again.

The MySQL provided by Oracle is free of charge, so it is difficult to install. In fact, as long as you know the installation steps, it will feel very simple.

If you still do not understand, recommended link: http://jingyan.baidu.com/article/09ea3ede0706eac0afde3962.html

The above is all the content of this article. I hope this article will help you in your study or work. I also hope to provide more support to the customer's home!