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 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:
C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -u root -pEnter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 28 to server version: 5.0.24a-community-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.
Add the remote login capability:
Mysql> use MySQL; mysql> grant all privileges on *. * to root @ "%" identified by "root"; // Add remote connection capability for root
Mysql> Update user SET Password = PASSWORD ('dsideal') where user = 'root'; // set the root user password mysql> flush privileges; mysql> exit