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