Now I want to compare the differences before and after php web page execution, but I still can't find better software
Add, delete, and change the kind that is recorded.
Then MySQL 5 is discovered by browsing the official documentation.1 has one Common Query Log .So try:
#cd /Applications/XAMPP/xamppfiles/bin cd /Applications/XAMPP/xamppfiles/share/mysql ./mysql.server start --log=file_name.log
Starting MySQL .2017-12-16 14:51:44 546 mysqld_safe Logging to '/Applications/XAMPP/xamppfiles/var/mysql/MacBook-Air.local.err'. 2017-12-16 14:51:44 546 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql ERROR!
Then I think about whether it's the MySQL version or not.
Try querying MySQL version.
#Start MySQL normally first ./mysql.server start #Enter mysql cd /Applications/XAMPP/xamppfiles/bin ./mysql -u root
You can see the system return
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.1.26-MariaDB Source distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Wait, what is MariaDB?You can use Baidu.....
Then, to confirm whether it is MariaDB, execute
MariaDB [(none)]> select version(); +-----------------+ | version() | +-----------------+ | 10.1.26-MariaDB | +-----------------+ 1 row in set (0.00 sec)
You can already see 10.1.26-MariaDB.
Then, all of the above is useless.The focus is here.
After a series of baidu.Don't ask me why google isn't (don't turn over walls if you can Baidu things)
Eureka MySQL configuration file my.cnf adds log parameter file error This article.
Checked google, the solution is the current log parameter is deprecated, used instead
#cd /Applications/XAMPP/xamppfiles/bin cd /Applications/XAMPP/xamppfiles/share/mysql ./mysql.server start --general_log_file=file_name.log
Starting MySQL .2017-12-16 15:03:51 1665 mysqld_safe Logging to '/Applications/XAMPP/xamppfiles/var/mysql/MacBook-Air.local.err'. 2017-12-16 15:03:51 1665 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql SUCCESS!
The execution was successful, but the file_name.log was not created because it was not opened.
#cd /Applications/XAMPP/xamppfiles/bin cd /Applications/XAMPP/xamppfiles/share/mysql ./mysql.server stop ./mysql.server start --general_log=ON --general_log_file=file_name.log
ok, the build was successful.Where file_name.log is the path
#file_name.log /Applications/XAMPP/xamppfiles/sbin/mysqld, Version: 10.1.26-MariaDB (Source distribution). started with: Tcp port: 3306 Unix socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock Time Id Command Argument 171216 15:05:12 2 Connect root@localhost as anonymous on 2 Connect Access denied for user 'root'@'localhost' (using password: NO) 171216 15:08:44 3 Connect root@localhost as anonymous on 3 Query SHOW VARIABLES 3 Query SELECT @@global.max_allowed_packet 3 Query USE `weiphp` 3 Query select * from wp_user
Here you can see the log of each step