Mysql installation, start mysql service, connect local database and remote database, mysql remote

Mysql installation, start mysql service, connect local database and remote database, mysql remote

I have taken a company project and I have to use mysql. Let's take a look ~!

1. Install mysql

Download one from Baidu mysql.Pay attention to the following important data:

The first one is Port Number: 3306. The default port number is 3306. You do not need to change it. If you change the port number, remember this port number.

Password: the password of the local database. The default user name is root.

The third is Windows Service Datails: MySQL56. If you modify it, remember. (You can cancel the check box before starting the MySQL Server at System Startup. Otherwise, the service will be automatically started every time mysql is started)

Ii. mysql management tools

I know Navicat and SQLyog Enterprise, because SQLyog Enterprise has been used since it was installed for the first time. Just install it all the way. Navicat looks good.

III,Connect to local database:

You must start the database service before connecting to the local database.After the initial installation, the database service is enabled. There are many ways to enable the Service later.

New, you can get a name: local represents the name of the local database, just a name.

It is important to fill in the other data:

Mysql host address: the localhost local address, or the 127.0.0.1 return address, are equivalent.

Username: root is the default name. It may be changed during installation.

Password: ********** is the password set during installation.

Port: the port number that must be remembered during installation of port 3306.

Connect.

4. connect to a remote database

Of course, you must know the address, username, password, and port of the remote database.

5. Start the mysql service (in many ways, you can use Baidu)

The data that must be remembered before installation is Windows Service Datails.

My default is MySQL56.

Doscommand to enable mysql service: net start mysql56

Doscommand to close mysql service: net stop mysql56

If mysql notifier is installed during mysql installation, you can enable or disable the mysql service by using the mysql management tool mysql notifier.