Actions before eclipse connects to my SQL database

Actions before eclipse connects to my SQL database

1: First is to install my SQL database (in order to reduce your trouble, according to the following connection, download can) Baidu Cloud Link: http://pan.baidu.com/s/limitWmbm password ny3a

2: After the download is completed follow the steps to install, here do not do more introduction, usually according to the default, according to the prompt operation, no difficult steps, installation takes a while, after installation, you can use, you can select the default command line mode my SQL 5.7 command lines Client Click Open, you need to enter the password you set to open

3: If the second step, you open the operation error, enter the password flash, then do not worry, is your my SQL does not run up, follow the steps below, right click on your computer, and then click Management, the following Computer Management interface appears

Then click Services and applications, the following interface appears

The following interface appears, and then find my SQL service

Right-click to set the run status to run, then open my SQL command line client to enter the password, you can enter the My SQL Shell mode

4: Enter command line mode, you can create a test database or other name of the table, the statement is as follows

Mysql>create database test;//Create a data base (you must remember to add a semicolon, or you will get an error) write the statement enter to create a database.

Mysql>use test;//Specifies that test is the current database to be manipulated

Mysql>create table User (name varchar, password varchar (20));//create user table, set name and password fields

Mysql>insert into user values (' Ningmengxueyuan ', ' 123456 ');//Insert field in table name and password

In this case, the Eclipse connection database will not be error (if the person who still has an error, can blog message or add me buckle 1748741328 Contact)

Operation complete the database table, and then follow the link inside the Eclipse link MySQL database operation can be http://www.cnblogs.com/biehongli/p/5728526.html

Actions before eclipse connects to my SQL database