MYSQL Installation Tutorial II

MySQL is a powerful database software, MySQL installation graphics tutorial will explain how to install MySQL, and then together to see how MySQL installed it.

Mysql-mysql server. You need this option unless you only want to connect to a MySQL server that is running on another machine.
Mysql-client-mysql client program for connecting and operating the MySQL server.
Mysql-devel-Libraries and include files, if you want to compile other MySQL clients, such as Perl modules, you need to install the RPM package.
Mysql-shared-The package contains some languages and applications that require dynamic loading of shared libraries (libmysqlclient.so*), using MySQL.
Benchmark and performance testing tools for the Mysql-bench-mysql database server.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403504903374762157056. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403504903374762157056.jpg "/>
Now the software installation is complete, the above interface, there is a good feature, Mysql Configuration Wizard, not to the same as before, their own manual configuration My.ini, will "Configure the Mysql Server now" before the Tick, point "Finish" End the installation of the software and start the MySQL Configuration Wizard.
650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_140350490341307886080.jpg "Style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_140350490341307886080.jpg "/>
The MySQL Configuration Wizard starts the interface and press "Next" to continue.
650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403504903144725926144. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403504903144725926144.jpg "/>
Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.
650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_140350490350182656512.jpg "Style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_140350490350182656512.jpg "/>
Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", people choose according to their own type, generally choose" Server machine ", not too little, will not be full.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505926124099728384. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505926124099728384.jpg "/>

Choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), with their own use and choose, I choose " Transactional Database Only ", press" Next "to continue.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505926252387767296. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505926252387767296.jpg "/>

To InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, re-install the time to choose the same place, otherwise it may cause database corruption, of course, do a backup of the database is no problem, here is not detailed. I have no changes here, use the default location, press "Next" to continue

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505926384185781248. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505926384185781248.jpg "/>

Select your site's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500)", " Manual Setting (manually set, you lose a number) ", I choose" Online Transaction Processing (OLTP) ", your own server, should be enough, press" Next "to continue

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_140350592730298702848.jpg "Style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_140350592730298702848.jpg "/>
Whether to enable TCP/IP connection, set the port, if not enabled, can only be in their own machine * * * * * Ask MySQL database, I am here to turn on the front tick, Port number:3306, on this page, you can also select "Enable Standard mode" (enabling Strict Mode) so that MySQL does not allow for small grammatical errors. If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505927419694528512. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505927419694528512.jpg "/>

This is more important, is to set the MySQL default database language encoding, the first is the Latin code, the second is a multi-byte universal UTF8 encoding, is not our universal encoding, select a third here, and then character set there to select or fill in "GBK", of course, can also use " gb2312 ", the difference is that the GBK font capacity, including all the characters of gb2312, and the addition of traditional characters, and other messy words-when using MySQL, run the data Operation command before the" SET NAMES GBK; " (Run once on the line, GBK can be replaced with other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise it will not be normal display of Chinese characters. Press "Next" to continue.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_140350592711155902208.jpg "Style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_140350592711155902208.jpg "/>

Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505927406269499648. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505927406269499648.jpg "/>

This step asks if you want to modify the default root user (super Admin) password (default is empty), "New root password" If you want to modify, fill in the new password here (if it is a reload, and have already set a password here, change the password here may be error, please leave blank, and will "Modify Security Settings "in front of the hook removed, the installation configuration after the completion of a separate password)," Confirm (again lost) "filled again, to prevent the wrong. "Enable root access from remote machines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, unable to manipulate data, including queries)", generally do not check, set up,

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505927265234487296. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505927265234487296.jpg "/>

Confirm that the settings are correct, and if wrong, press "back" to return to the check. Press "Execute" to make the settings effective.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505927143810058752. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505927143810058752.jpg "/>

Setup finished, press "Finish" to end the installation and configuration of MySQL--here is a more common error, is not "Start service", generally appear in the previous installation of MySQL server, the solution, first to ensure that the previously installed MySQL server completely uninstalled , if not, check whether the previous password has been modified, according to the above, if not, the MySQL installation directory of the Data folder backup, and then delete, after the installation is complete, will install the generated Data folder to remove, the backup Data folder back, Restart the MySQL service again, in which case you might need to check the database and fix it once to prevent data errors.

650) this.width=650; "Src=" http://www.xiazaiba.com/uploadfiles/content/2014/0623/water_1403505927408657721344. JPG "style=" border:0px;vertical-align:middle;margin:0px auto; "alt=" water_1403505927408657721344.jpg "/>

MYSQL Installation Tutorial II