Install and configure Mysql5.6.11 for Windows

Registered oracle Login Name: 10402852@qq.com

Password: The number * after dsideal ******* is a common password of Wang Zhuo, but it is in uppercase, because the ORACLE password mechanism is strict.

WINDOWS:

 

True: http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-community-5.6.11.0.msi

LINUX:

Select the "Source Code" drop-down menu for Source Code installation. In the displayed list, select the last "Generic Linux (Architecture Independent), Compressed TAR Archive (mysql-5.6.11.tar.gz )";

Next let's take a look at the Windows Installation Process of Mysql:

 

System Requirements:

First make sure that Microsoft. NET Framework 4.0 is installed in the system. Download: http://www.microsoft.com/zh-cn/download/details.aspx? Id = 17718

(2) installation steps:

 

Note 1: installation type settings

Developer Default installation type Server only serves as the Server Client only serves as the Client only

Full installation type

Custom installation type

Installation Path: Path of the Data Path database Data file

NOTE 2: Server Configuration

1. Server Configuration Type

The Config Type drop-down list is used to configure the Type of the current server. Which server will affect MySQL Configuration Wizard's decision on memory, hard disk, and process or usage?

Three server types:

(1) Developer Machine: This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server to use the least amount of system resources. (2) Server Machine (Server): This option indicates the Server. The MySQL Server can run with other applications, such as FTP, email, and web servers. Configure the MySQL server to use the appropriate proportion of system resources. (3) Dedicated MySQL Server Machine (Dedicated MySQL Server): This option indicates a Server that only runs the MySQL service. It is assumed that no other application is running. The MySQL server is configured to use all available system resources.

As a beginner, it is enough to select "Developer Machine" (Developer Machine), which will not occupy a lot of system resources.

2. Enable TCP/IP Networking

In the check box on the left, you can enable or disable the TCP/IP network and configure the port number used to connect to the MySQL server. By default, the TCP/IP network is enabled. The default port is 3306. To change the port used to access MySQL, enter the new port number in the text input box, but ensure that the new port number is not occupied.

Finally, we need to set the remote permissions for Logon. If you have a user name or password, you cannot access it through an IP Address:

cd C:\Program Files\MySQL\MySQL Server 5.6\bin>

Solution:

Copy codeThe Code is as follows: C: \ Program Files \ MySQL Server 5.6 \ bin> mysql-u root-p
Enter password :******

Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 28 to server version: 5.0.24a-community-nt
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.

Add the remote login capability:

Copy codeThe Code is as follows: mysql> use mysql;
Mysql> grant all privileges on *. * TO root @ "%" identified by "root"; // Add the remote connection capability TO the root user
Mysql> update user set Password = password ('dsideal') where User = 'root'; // set the root user Password
Mysql> flush privileges;
Mysql> exit