MySQL installation graphic tutorial, mysql graphic tutorial

MySQL installation graphic tutorial, mysql graphic tutorial
Download

1.:

Http://www.mysql.com/downloads/

2.Download illustration

Download the Community version. The Community version contains almost all of the features we want. However, the commercial version of mysql provides some advanced solutions.

We can solve these advanced functions by ourselves.

 

 

 

Select the operating system. There is even Source Code.

Select a 64-bit or 32-bit version for download.

 

Installation Process

MySQL5.6.11 installation procedure (Windows7 64-bit Windows8 64-bit)
1. Download MySQL Community Server 5.6.14 2. decompress the MySQL package
Decompress the downloaded MySQL package to the custom directory.
2. Add Environment Variables
Variable name: MYSQL_HOME
Variable value: D: \ Program Files \ mysql-5.6.14-winx64
That is, the custom extract directory of mysql.
Add % MYSQL_HOME % \ bin in Path.
Run mysql in CMD. The text shown in figure shows that the environment variable is successfully configured!
3. Register windows Services
Register mysql as a windows system service
The procedure is as follows:
1) Create a New my. ini file and copy the my. ini file to the c: \ windows directory. The content of my. ini is as follows:
[Client]
Port = 3306
Default-character-set = utf8
[Mysqld]
# Set it to the MYSQL installation directory
Basedir = D: \ Program Files \ mysql-5.6.14-winx64
# Set it to the MYSQL DATA DIRECTORY
Datadir = D: \ Program Files \ mysql-5.6.14-winx64/data
Port = 3306
Character_set_server = utf8
SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
2) log on to the bin directory under the MySQL extract directory from the console.
3) enter the service installation command:
Mysqld.exe-install
If Install/Remove of the Service Denied appears!
Because Windows 7, 8, and vista have stricter permissions.
Go to C: \ Window \ System32, right-click CMD. EXE, and select "Run as administrator". Then, go to the corresponding directory and execute the command. Everything is OK.
After the installation is successful, a message is displayed, indicating that the service is successfully installed.
Note: The my-default.ini file is in the root directory after MySQL decompression, if not, can be obtained from other places.
Command: mysqld remove
4. Start the MySQL Service
Method 1:
Run the following command to start the service: net start mysql.
Method 2:
Open the management tools service and find the MySQL service.
Right-click Start or click Start on the left to start the service.
5. Modify the password of the root account
When the installation is complete, the default password of the root account is blank. You can change the password to the specified password. Example: 123456
Method 1:
C:> mysql-uroot
Mysql> use mysql;
Mysql> UPDATE user SET password = PASSWORD ("123456") WHERE user = 'root ';
Mysql> flush privileges; [Do not forget this sentence, otherwise the password change will not take effect]
Mysql> QUIT
OK. Now the service configuration is successful! Next, the DBMS management tool is left.
 

Database Management Tools

1. Download Tool
There are many MySql management tools, such as MyAdmin and Navicat.
Navicat_lite is recommended.
:
Http://pan.baidu.com/s/1pJnzVIz
2.Installation Process 
The installation process is very simple. Next, let's proceed.
3.Configuration
Connect to the database server first.
Just start with the connection name! The rest should be understood ~
The database is displayed under the dolphin icon. Verify that the installation is successful!