Mysql download installation, deployment, and graphical details of the Operation tutorial _mysql

MySQL is a tool that must learn how to install and deploy, it is different from other fool-type applications/programs, a key to the end, if it is the first time to install MySQL under windows of the novice or a certain degree of difficulty.

This article with the previous "Javaweb development environment Myeclipse6.5 JDK1.6 Tomcat6.0 SVN1.8 Configuration Tutorial" (Click to open the link) in the context of the deployment of the foreground development environment, also formed a javaweb, JSP, Java-EE Basic development environment.

One, the MySQL download

First Open MySQL's official website (click to open the link), Baidu is not found, I also looked for a long time to find Mysql5.1 's official website, choose Mysql5.1 version, this thing is not the better version of the better, the key is stable

Choose a version of MySQL with the MSI suffix name, which is not configured as Tomcat or as a setup wizard.

According to the 32-bit operating system and 64-bit version of the operating system, choose the appropriate version, but it seems that the problem is not, the author of the test on 64-bit machine installed 32-bit MySQL, the slightest problem.

Second, the installation of MySQL

1, after the successful download to get a mysql-5.1.73-win32.msi, double-click Open, the following to Mysql5.0 for screenshots to explain the installation of MySQL, after all, MySQL other version of the same, and even no difference

2, run "Setup.exe", the following interface appears, the MySQL Installation Wizard starts, press "Next" to continue:

3, choose the installation type, there are "typical (default)", "Complete (complete)", "Custom (user-defined)" Three options, we choose "Custom", there are more options, but also easy to familiar with the installation process.

4. On the "Developer components (developer part)" Left-click, select "This feature, and all subfeatures, will is installed on the local hard drive.", that is, "this part, and subordinate part of the content, all installed on the local hard drive, which is the second. The default developer components (Developer section) is closed. Check the "MySQL server", "Client Programs (MySQL client)", "Documentation (documentation)" above to ensure that all files are installed. Click Change ... to manually specify the installation directory. If you want to change the MySQL installation path, you have to change all parts of the directory, not just change one on the line!

5, press "Next" to continue, confirm the previous settings, if wrong, press "back" to return to redo. Press "Install" to start the installation.

6, then start installation, MySQL is not large, the installation is completed quickly, unlike SQL Server 2005 to install a long time

7, some old version of MySQL may also appear in this process the following interface:

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.

8, until the software installation is completed, the following interface appears, here is a very good function, Mysql Configuration Wizard, not to the same as before, their own manual mess configuration My.ini, will "Configure the Mysql Server now" in front of the tick, point " Finish "End the software installation and start the MySQL Configuration Wizard."

9, the following is the MySQL Configuration Wizard launch interface, press "Next" to continue.

10, choose the configuration mode, "Detailed Configuration (Manual precise configuration)", "Standard Configuration (Standard configuration)", we choose "Detailed Configuration" to facilitate the familiar configuration process.

11, select the server type, "Developer Machine (Development test class, MySQL takes very little resources)", "Server Machine (servers type, MySQL occupies more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", we choose according to their own type, the general election of" server Machine ", not too little, will not fill.

12, choose the general use of MySQL database, "Multifunctional db (Universal multi-function, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional processing type, simpler, mainly do some monitoring, counting, MyISAM data types of support limited to non-transactional), with their own use and chose, I choose here " Transactional Database only, press "Next" to continue.

13, the InnoDB tablespace configuration, is to InnoDB database files to choose a storage space, if modified, to remember the location, when the time to choose the same place, otherwise it may cause database damage, of course, to do a backup of the database is no problem, here is not detailed. I have not modified here, use the default location, press "Next" to continue.

14, choose your site's general MySQL access, at the same time the number of connections, "Decision Support (DSS)/olap (20)", "Online Transaction Processing (OLTP) (500 or so)", " Manual Setting (manually set, lose a number) ", I choose" Online Transaction Processing (OLTP), your own server, should be enough, press "Next" to continue

15, whether to enable TCP/IP connection, set the port, here's the best not to change the port number, after all, the general view is that MySQL is occupied by 3306 of the port. This port is just as great as the jerseys of some players on a football field or on a basketball court! If you do not enable, you can only access the MySQL database on your own machine, I am enabled here, put the front of the tick, Port number:3306, on this page, you can also choose "Enable Standard mode" (Enable Strict mode), This allows MySQL to not allow small grammatical errors. If you are still a novice, I recommend that you cancel the standard mode to reduce the hassle. But after familiarity with MySQL, use standard mode as much as possible, because it reduces the likelihood that harmful data will enter the database. Press "Next" to continue.

16, this is more important, is the MySQL default database language encoding settings, the first is the Western Latin1 encoding, the second is a multibyte universal UTF8 encoding, you can directly choose, here you can choose a third, and then in the character set there to select or fill in "Utf-8 , "GBK" and "gb2312" have become obsolete, and now the site is written in the international Utf-8. For some installed old database MySQL, run the set names Utf-8 before executing the data Operation command. (Run once on the line, Utf-8 can be replaced by other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise can not display Chinese characters normally. When programming storage things into garbled, in addition to your own program may have problems, MySQL may also appear problems. Press "Next" to continue.

17, choose whether to install MySQL as a Windows service, you can also specify service name (services identity name), whether the MySQL bin directory into Windows PATH (after joining, you can directly use the file under Bin, without pointing to the directory name, such as connection, "Mysql.exe-uusername-ppassword;" On it, do not point out the full address of mysql.exe, very convenient, I have all ticked here, Service name unchanged. If you do not start, every time you use MySQL to start the service manually, it is troublesome to start a service in Windows. If you do not want to install MySQL to cause your own operating system card, you'd better install MySQL on the virtual machine and be your own development environment. Press "Next" to continue.

18, this step asks if you want to modify the default root user (super Admin) password (default is null), "New root password" If you want to modify it, fill it in with the password (if it's a reload, and you've already set a password, here's a mistake to change the password, leave it blank, and " Modify security Settings "in front of the check out, the installation configuration is completed after a separate change password)," Confirm (again) "to fill in again, to prevent the wrong. "Enable root access from remote machines (whether or not to allow root users to log on to other machines, if you want to be safe, do not hook, if it is convenient to hook it up)". Finally "Create a Anonymous account (a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including inquiries)", generally do not have to tick. I generally set the username to root and password to root. Please keep this password in mind, forget the very troublesome. Set up and press "Next" to continue.

19, confirm the set is correct, if wrong, press "back" to return to check. Press ' Execute ' to make the settings effective.

20, set up, press "Finish" to end the installation and configuration of MySQL--here is a more common mistake, is not "Start service", generally appear in the previous installation of MySQL server, to solve the 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 step, and if it is still not, the MySQL installation directory of the Data folder backup, and then deleted, after installation, will install the generated Data folder deletion, backup of the Data folder back, and then restart the MySQL service on it, in this case, you may need to check the database, and then fix it once, to prevent errors. This MySQL installation and configuration is completely over.

Third, the basic use of MySQL

Now that Mysql can be used, open Mysql->mysql Command line Client directly in the Start menu, and enter the password you just set, you can use T-SQL statements to operate. MySQL is not installed in the case of plug-ins, there is no graphical interface. MySQL is a semicolon; to end a statement instead of the ENTER key. In addition to the basic T-SQL statements, the set names Utf-8;,mysql with the setting encoding statement just mentioned is as follows:
　　Display database: showdatabases;
　　using Database: Usedatabase name;
Build Database command:CREATE DATABASE Shujuku;
Set permissions (user and password) commands for the database: Grant all privileges on shujuku.* to Test@localhost identified by "123456";
When you finish this command, as long as you again in User name: Test, Password: 123456 login You can only shujuku this database operation, so avoid the use of root, the security of the database is a great help. However, for the convenience of general development, it is not necessary to set permissions, unlike SQL Server 2005, which must open permissions to be invoked by external programs.
Enter on the command line? ", there will be the simple help of MySQL command, exit, is" exit.

Four, MySQL graphics

The so-called MySQL graphics, in fact, is not like the installation of MySQL so difficult, and even install do not need you to install, is a compression package decompression things,

Please find your own internet search Mysql-gui-tools-noinstall-5.0-r12-win32.zip, all major sites have a green version of the download.

It's best to figure it out, not to say you are proficient in T-SQL statements do not graphics, the key is to work more graphically than the input command has a significant increase!

After the Mysql-gui-tools-noinstall-5.0-r12-win32.zip decompression, the key is two programs:

One is MySQLQueryBrowser.exe, used to look at tables, look-up tables to use, the input database in the installation of the port number set, port number before a general is localhost, user name, password can be very simple to see the database table, if you do not need to use T-SQL to view the table.

One is MySQLAdministrator.exe, the same as above input database in the installation of the user name and password, you can use the restore inside to import the database, backup used to export the database, very simple, if you do not, you need to like the MySQL command line export and Import database (click Open link) to export import.

At this point, all the MySQL installation completed!

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.