Remote connection MySQL server times not allowed to connect error resolution

1. Connect to the MySQL server using the root user via the command line and enter the MySQL database

MySQL> use mysqlDatabase changed

2. Authorizing with the GRANT statement

All privileges: represents all database Permissions

On *. *: Represents a view in all tables, views, functions, and so on, which can be a specific database under a table. such as Demodb.testtable

' Root ' @172.16.48.65: Indicates that the root user is allowed to connect to the MySQL server from the IP-172.16.48.65 host

Identified by ' admin ': Indicates the root user's password from 172.16.48.65 remote connection

With GRANT option: When Root is connected from a 172.16.48.65 host, you can grant permissions again to other users by using the GRANT statement.

Mysql> Grant  All Privileges  on *.*  to 'Root'@172.16.48. $Identified by 'Admin'  with Grant option ; Query OK,0Rows Affected (0.00Sec

3. Refresh Permissions

MySQL>privileges0 rows affected (0.00 sec)

Remote connection MySQL server times not allowed to connect error resolution