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;

To show MySQL all users list:

mysql> select * from mysql.user;

For drop user in MySQL:

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

Change MySQL user password:

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