MySQL remote connection configure

If your MySql server on Linux and you want to use it from another Linux or Windows PC then use the following command.

1. First login on your Linux mysql server (mysql -u root-p)
2. Now enter the following command.

For Set permission on the server:
mysql> grant all privileges on *.* to ‘root’@’%’ identified by ‘root’ with grant option;

For access on the server:
mysql> set password for ‘root’@’%’=old_password(‘passwd’);

Advertisements

মন্তব্য করুন

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / পরিবর্তন )

Twitter picture

You are commenting using your Twitter account. Log Out / পরিবর্তন )

Facebook photo

You are commenting using your Facebook account. Log Out / পরিবর্তন )

Google+ photo

You are commenting using your Google+ account. Log Out / পরিবর্তন )

Connecting to %s

%d bloggers like this: