How to enable remote access on MySQL Server

0
enable mysql remote access

By default MySQL Server is secured to allow connections only from the same machine

But it can be configured to allow remote connections from your Local Area Network

Please follow the steps below to enable MySQL remote access

1. Open MySQL command line utility

2. It would ask for the password, enter your MySQL password

3. Now you would see a prompt. Enter below commands one by one

mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> exit

Where

username is the name of an existing MySQL user

password is your MySQL password for that user

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.