How to let other computers access the database on my computer MySQL

Source: Internet
Author: User

The first kind: Can ping pass, show you in the same network, can directly access. You just have to add external access to the account in your logged in user ... That is, authorization. For example, your account is root and you can enter MySQL after

You can see that each account has a column of host, this is the host to allow login, if the host is the% number, then all hosts can log on, including the remote host. I do the following

Then one of my root accounts can be accessed by all hosts.

In the second case, the ping does not work, then you need to borrow other tools. You can use DDNS tools such as peanut shells or scarecrow to perform static IP.

The rest, as in the first case, allows you to allow remote logins on your account.

How to let other computers access the database on my computer MySQL

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.