MySQL Database installation diagram

Source: Internet
Author: User
Tags documentation mysql client root access

The following is a MySQL installation of the diagram, with the executable file:: HTTP://WWW.JINHUSNS.COM/PRODUCTS/DOWNLOAD/?TYPE=XCJ related download

MySQL Setup Wizard starts, press "Next" to continue

Choose the installation type, have "typical (default)", "Complete", "Custom (User Defined)" Three options, we choose "Custom", there are more options, but also easy to familiarize with the installation process, in the case of unclear can choose to install all Comlete

Left-click on the Developer Components (Developer section) and select "This feature, and all subfeatures, will is installed on the local hard drive.", that is, "this section, and the next belong to the sub-section, all installed on the local hard disk. The above "MySQL server", "Client Programs (MySQL client program)", "Documentation (documentation)" are also doing so to ensure that all files are installed. Click "Change ..." To manually specify the installation directory.

Fill in the installation directory, my is "F:\Server\MySQL\MySQL Server 5.0", also recommended not to be placed in the same partition as the operating system, so as to prevent system backup restore, the data is emptied . Press "OK" to continue.

Go back to the interface and press "Next" to continue.

Confirm the previous settings and, if wrong, press "back" to return to redo. Press "Install" to start the installation.

In the installation, please wait until the following interface appears

Here is to ask if you want to register a mysql.com account, or use the existing account login mysql.com, generally do not need, click "Skip Sign-up", press "Next" skip this step.

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 mess configuration My.ini, will "Configure the Mysql Server now" front of the Tick, point "Finish "End the installation of the software and start the MySQL Configuration Wizard."

MySQL Configuration Wizard start interface, press "Next" to continue

Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.


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.

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.

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

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

Whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on your own machine, I am here to enable, put 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 a small syntax error. 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

Latin code, the second is a multi-byte universal UTF8 encoding, is not our universal encoding, here to choose a third, and then character set there to choose or fill in "GBK", of course, can also use "gb2312", the difference is GBK font capacity is large, Includes all Chinese characters of gb2312, plus traditional characters, and other messy words-run "SET NAMES GBK" before executing data manipulation commands when using MySQL; (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. Of course our script is UTF8 encoding can also be selected by the user, you can also choose to press "Next" when creating the database.

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. 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.

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, press "Next" to continue.

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

MySQL Graphics installation Tutorial 20 set up, press "Finish" to end the installation and configuration of MySQL--here is a more common error, is not "Start service", usually appear in the previous server installed MySQL , Solution, first ensure that the previous installation of the MySQL server completely uninstalled; if not, check whether the previous password has been modified, according to the above action, if not, the MySQL installation directory of the Data folder backup, and then delete, after the installation is complete, Delete the installed Data folder, back up the Data folder, and restart the MySQL service, in which case you might need to check the database and fix it once to prevent data errors.

MySQL Database installation diagram

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.