About MySQL installation and getting Started

As a result of the recent project with the teacher, need to set up a database of their own, pick to pick, and finally chose MySQL.

MySQL is an open-source, small, relational database management system that is more widely used in small and medium-sized websites on the internet. With small size, fast, low overall cost, especially open source and other characteristics, many small and medium-sized websites to reduce the total cost of ownership, all choose MySQL as a site database.

Of course, the above paragraph from Sogou, the personal main is that the threshold is relatively low, to start more relaxed. Now to share their learning experience, initially are some of the entry-level operations.

First of all, MySQL is on Baidu can be downloaded < of course or recommended official website download >,windows Environment installation method has zip and MSI two kinds of installation, zip installation is more trouble, all selected Msi<windows installer> Installation.

Installation Type Select a Typical installation,<typical:> after the main configuration. The default is to drive C, because MySQL runs in a CMD environment. Under Directory C:\Program Files (x86) \mysql\mysql Server 5.5\bin , run 650) this.width=650; "title=" 11.png "src=" http:/ S2.51cto.com/wyfs02/m01/7f/00/wkiol1cpf5ebuwhzaabb7fhot5i998.png "alt=" Wkiol1cpf5ebuwhzaabb7fhot5i998.png "/>

Select the standard configuration, then click Next to configure the environment variable, set the Superuser password, and then configure the success.

To make sure, you can view it in the computer service

650) this.width=650; "title=" Qq20160414193318.png "src=" http://s5.51cto.com/wyfs02/M02/7F/00/ Wkiol1cpgmrrm9jkaag9te2qgy8062.png "alt=" Wkiol1cpgmrrm9jkaag9te2qgy8062.png "/>

Right-to-property, you can view relevant information about environment variables, or you can

650) this.width=650; "title=" 2.png "src=" Http://s5.51cto.com/wyfs02/M01/7F/00/wKioL1cPgW6wrjH3AAGeKUDDiek070.png " alt= "Wkiol1cpgw6wrjh3aagekuddiek070.png"/>

If not, you can copy the bin directory to the environment variable under path.

Under the installation directory, further configuration is possible under My.ini

650) this.width=650; "style=" Float:none; "title=" 3.png "src=" http://s4.51cto.com/wyfs02/M02/7F/03/ Wkiom1cpgzhxboaqaabrssw6wj4288.png "alt=" Wkiom1cpgzhxboaqaabrssw6wj4288.png "/>

Port is the default port number and is generally not modified

650) this.width=650; "style=" Float:none; "title=" 4.png "src=" http://s3.51cto.com/wyfs02/M00/7F/03/ Wkiom1cpgzgryb2aaaay6wmqx8m285.png "alt=" Wkiom1cpgzgryb2aaaay6wmqx8m285.png "/>

Default encoding method, used to convert Latin encoding to UTF8 format

650) this.width=650; "style=" Float:none; "title=" 5.png "src=" http://s3.51cto.com/wyfs02/M00/7F/00/ Wkiol1cpgkqwhctyaabetiltxfo355.png "alt=" Wkiol1cpgkqwhctyaabetiltxfo355.png "/>

About the configuration here, you can start your own operation now.

First, run cmd in the Start menu, enter the command

Mysql-uroot-p-------------------->-u is followed by your user name,-p after you can enter the password directly, you can also for security, select just enter-p, and then click Enter, you will be prompted to enter the password, enter the password, then click Enter.

650) this.width=650; "title=" 7.png "src=" Http://s3.51cto.com/wyfs02/M00/7F/03/wKiom1cPgxnzkaueAABq2mTwSig737.png " alt= "Wkiom1cpgxnzkaueaabq2mtwsig737.png"/>

Now it's officially in MySQL.

In addition, there are other instructions that can be set when you start MySQL, such as:

-D-----> Open the specified database

-P--------> enter password

-P--------> port number

-u--------> user name

-V----------> Output version information and exit

-H----------> server name

You can try typing and see what's going to happen.

Start saying, then how to quit?

650) this.width=650; "title=" 8.png "src=" Http://s3.51cto.com/wyfs02/M02/7F/00/wKioL1cPhTvQYxWMAABE3lC9uW4475.png " alt= "Wkiol1cphtvqyxwmaabe3lc9uw4475.png"/>

The above are the basic form of exit, do not forget to add a semicolon, or will appear in the logo, but do not worry, this is because it does not detect your information output is complete, at this time, only need to add a semicolon on it.

This article is from the "11321490" blog, please be sure to keep this source http://11331490.blog.51cto.com/11321490/1763904

About MySQL installation and getting Started