Allows remote users to access mysql service sql statements

  • 2020-06-23 02:06:09
  • OfStack

mysql > grant all privileges on cakephp.* to cakephp@192.168.14.1 identified by 'lpfukia';
Query OK, 0 rows affected (0.01 sec)

mysql >
mysql >
mysql >

mysql > flush privileges;

$1 > > Command 1: Authorize cakephp users on 192.168.14.1 host to access the cakephp database
$2 > > Command 2: Refresh the authorization table


Related articles: