MySQL installation, startup and use

Need to learn SQL language, according to the recommended installation of free MySQL to learn! Previously learned to practice SQL Sever on SQL statement, because it is in the school room directly, for the installation of data management software has no experience. This time after installing MySQL, I don't know how to use it. With MySQL Workben found unable to connect to the local database. Internet query only found that the use of MySQL must first start. "After MySQL has been installed, it has automatically created a MySQL service into the Windows service, with the following possible methods"

The Windows startup method below "gives two simplest":

1. Booting through the Windows Service program (most intuitive)

Open Task Manager--service, press a few M Jian, will automatically find the service name beginning with M, find MySQL select Start.

The way to communicate with the principle is to select the computer (Win7)-Right-click Management, then the list of services appears on the right--press the M key to find MySQL, then right-start (stop)

2. Using the cmd command

Start Mysql:net start MySQL

Enter Mysql:mysql-hlocalhost-uroot-p

"When the bin installation directory for MySQL is not in the environment variable, it needs to be added."

View database: show databases; "Commands in the MySQL database must end with a semicolon"; ""

exit L database: Exit; Enter

Close mysql:1.net stop MySQL [pre-installed service]

2.mysqladmin-u Root shutdown

"Command with password set to mysqladmin-u root-p shutdown"

After you start MySQL, you can use MySQL workben to use the MySQL database with admin! The previous learning of creating tables, adding columns and so on, can now be done with MySQL Workben.

MySQL installation, startup and use