The
Open method is simple: Edit the/etc/my.cnf file and add under the [mysqld] section: Log=/var/lib/mysql/sql_row.log Line (the path of the log itself is defined as needed).
The code is as follows |
Copy Code |
[Mysqld] Datadir=/var/lib/mysql Socket=/var/lib/mysql/mysql.sock User=mysql # Default to using the old password format for compatibility with MySQL 3.x # clients (those using the Mysqlclient10 compatibility package). Old_passwords=1 Log=/var/lib/mysql/sql_row.log # Disabling Symbolic-links is recommended to prevent assorted security risks; # to does so, uncomment this line: # symbolic-links=0 [Mysqld_safe] Log-error=/var/log/mysqld.log Pid-file=/var/run/mysqld/mysqld.pid |
After the modification, remember to restart MySQL:
The code is as follows |
Copy Code |
Service MySQL Restart # or /etc/init.d/mysqld stop /etc/init.d/mysqld start |
Now you go to the/var/lib/mysql/path of the Sql_row.log file should be able to see when MySQL has implemented which programs.