MySQL Allow Remote Connections

MySQL Allow Remote Connections

To allow remote connection from remote to MySQL database lets create new user “[email protected]” with password -PaSSworD from command prompt:

mysql> CREATE USER 'remote'@'10.110.2.25' IDENTIFIED BY 'PaSSworD';

 

Grant all privilegies to user [email protected] with password – PaSSworD

mysql> GRANT ALL PRIVILEGES ON *.* TO 'remote'@'10.110.2.25' IDENTIFIED BY 'PaSSworD ' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

 

MySQL show all users

To show MySQL all users list:

mysql> select * from mysql.user;

 

MySQL Delete User

For drop user in MySQL:

mysql>  DROP USER 'remote'@'10.110.0.0/255.255.0.0';

 

Change Password For User

Change MySQL user password:

mysql> SET PASSWORD FOR 'remote' = PASSWORD('bFyIfFS9nDaVf3jgnd8m');
mysql> FLUSH PRIVILEGES;

 

arstech

Leave a Reply

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