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

Source: Internet
Author: User
Tags mysql download mysql host

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.