MySQL install, start MySQL service, connect local database and remote database

Because after a company's project, you have to use MySQL, special to learn!

One. mysql Installation

Baidu MySQL download one can. just take a look at some important data:

The first one is Port number:3306. Port number default 3306, generally do not need to change, if changed, please remember this port number.

The second one is password: The local database password, the default user name is root

The third is the Windows Service datails:mysql56, if modified please remember. (You can cancel the start of the MySQL Server at the front of the System startup tick, or each time you start MySQL on the start service)

Second, MySQL management tools

I know there is navicat,sqlyog Enterprise, because the first installation of SQLyog Enterprise has been used it, all the way to install. Navicat looks like a good interface.

Third, connect the local database :

The database service must be started before connecting to the local library, the database service has been opened after the initial installation, and the operation mode of the service can be opened in a number of ways.

New one, you can take a name: local represents the name of the native database, just a name.

It is important to fill in several other data:

MySQL hostaddress: localhost local addresses, or write 127.0.0.1 loopback addresses, are equivalent.

username: Root This is the default name, install the time seems to be able to modify.

Password: ********** is the password set at the time of installation.

Port: 3306 The port number that must be remembered when installing.

Then connect.

Iv. connecting to the remote database

Of course you need to know Address,username,password and port of the remote database.

Five, start the MySQL service (many ways, can own Baidu)

One of the data that you must remember before installing is Windows Service datails.

Mine is the default:MySQL56

dos command to turn on MySQL service: net start mysql56

DOS command to shut down MySQL service: net stop mysql56

If MySQL notifier is installed when you install MySQL, you can turn the MySQL service on and off with MySQL notifier this MySQL management tool.

MySQL install, start MySQL service, connect local database and remote database