Allow remote users to access mysql service SQL statements and mysqlsql statements

Allow remote users to access mysql service SQL statements and mysqlsql statements

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

Mysql>
Mysql>
Mysql>

Mysql> flush privileges;

$1> the first command: Authorize the cakephp user of host 192.168.14.1 to access the cakephp database.
$2> second command: refresh the authorization table

How can I have the mysql server record all the accessed SQL statements and write them to a log file?

Blog.sina.com.cn/s/blog_406127500100pvar.html

Query results using SQL statements in Mysql

Select name, count (name) as shu from A use this sentence to make A View B
Then ......
Select. name, max (B. shu) as exp1, other columns ..., from A inner jion B on. name = B. name group by (all columns except shu should be clustered .)