Installation and password configuration for MySQL database

 MySQL was developed by MySQL AB company and acquired by Oracle Corporation MySQL is a relational database management system divided into Community Edition and Enterprise Edition the SQL language used by MySQL is the most commonly used standardized language for accessing databases, with its small size, fast speed, low total cost of ownership, especially open source, with PHP and Apache to form a good development environment
   Installation Method: installation Method MSI installation and zip installation Typical: Typical installation recommended useCustom : Customized InstallationComplete: Fully installed I. Download MySQL software
1. Download MySQL software to Oracle website

First go to MySQL's official website, click Download, we recommend using the Community edition download

2. find MySQL Community Server, at the bottom there is a selected download version, to see whether you are the Linux version or the Windows version , 64-bit or 32-bit , where " X86" refers to 32 bits .

Two versions: Zip is a free-to-install package, MSI is a Microsoft-specific compression format and is a package that needs to be installed

MySQL ZIP Archive: Compressed version, you need to configure it yourself
MySQL MSI Installer: Installation version, automatic configuration during installation

Install MSI Memory is relatively small, the individual download is zip, any one of the selected 3. Click Download (download)

generally the default download is version 5.7, you can also choose the other version

4. Popup The following interface, is to have you login username and password, you can skip directly click No Thanks, just start my download. Download

after the download is complete, prepare for the pre-installation 1. renaming after extracting the downloaded version, rename it to MySQL .if installed on the E-drive: E:\mysql also rename the file my-default.ini in MySQL to My.ini    3. Configuration of environment variablesRight click on My Computer or computer--click Properties--Select advanced System Settings--click Environment Variables--Find path in System variables (S), click Edit or double-click it Then add a half-width semicolon to the path in the back, and then assign the bin path in MySQL to be configured and click OK. note points for configuring the environment:be sure to copy to the bin path such as:; E:\mysql\bin;must be added later instead of overwriting the path of the original fileBe sure to add a half-width semicolon before adding the path to make it easier to differentiate from the previous path   install MySQL with the cmd command below4. Click the Windows icon in the bottom left corner, enter cmdin the search box, and then right click to run as Administrator   5. Enter the command in cmd to install MySQLFirst, the default is installed in the C drive, install it in the E-drive Drive letter switching: drive letter +: For example: Switch to E-drive-->e: Enter go to file path: CD + file path such as: CD \mysql \ Bin return install MySQL: mysqld-install start MySQL:net start MySQL if the startup error, may be the configuration of the MySQL environment is a problem, cannot find the path of the file, this time to reconfigure, after the successful start, perform the next go to MySQL:mysql-u root-p Enter, then prompt "Enter password:" Statement, do not control it, directly enter , because the first time the MySQL installation is not the default password, and then log on successfully.    settings for 6.MySQL passwordsfor security reasons, set the password for MySQL: Enter update mysql.user set Password=password (' 123456 ') where user= ' root '; Return (remember to enter with a semicolon at the end)If you are modifying the root password : UPDATE mysql.user SET password=password (' New password ') WHERE user= ' root '; After the modification is successful, you can log out and use it again.The MySQL provided by Oracle is free, so it's a bit hard to install, but it's easy to know the steps to install it.If you do not understand, the recommended link:http://jingyan.baidu.com/article/09ea3ede0706eac0afde3962.html

Installation and password configuration for MySQL database