Install and start mysql, connect to local and remote databases

Source: Internet
Author: User
Tags mysql host

Install and start mysql, connect to local and remote databases

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. <喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> VcD4KPHA + expires + way907G + tdjK/b7dv + expires/expires + 3b/it/expires/b7dv + K3/s7x0tG + rb + qxvSjrNLUuvO/qsb0t/expires + cjxwPjxpbWcgc3JjPQ = "http://www.2cto.com/uploadfile/Collfiles/20150413/20150413093321259.jpg" alt = "\">

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.


Related Article

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.