How to enable remote access on MySQL Server

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 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