Let the LAN other computer to access the native MySQL;

Source: Internet
Author: User

Start the MySQL service first,

Open the cmd command window,

Run net start to view the name of the MySQL service, which may be mysql,mysql57 or something,

Open the service, run the command window into the bin directory of the MySQL installation location

Enter Mysql-hlocalhost-uroot-p return, enter the password into the database

Run use MySQL;

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.

View the existing database under DOS command;

Enter show databases; Remember to end with a colon

Let the LAN other computer to access the native 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.