用PHP打开MySQL慢速查询日志

我猜运行php的用户与日志文件的所有者不相同或不在同一组中。

你能用fopen读取文件吗?

还要确保目录正确 /var/log/mysql

你试过波本吗?

$fp=popen("cat /var/log/mysql/mysql-slow.log","r");
while (!feof($fp)) {
    $buffer = fgets($fp, 4096);
    $croninf .= '<tr><td>' . $buffer . '</td></tr>' . "\n";
} 

将用户添加到adm groupon linux shell命令

adduser www-data adm

将文件权限授予770(所有者和组完全访问权限)并重新启动系统

chmod 770 /var/log/mysql/mysql-slow.log
reboot

然后从php读取文件

$filename = '/var/log/mysql/mysql-slow.log';
$handle = fopen($filename, "r");
$icerik = fread($handle, filesize($filename));
fclose($handle);
print_r($icerik);

chmod 777 /var/log/mysql/mysql-slow.log
<?php 
$file = "/var/log/mysql/mysql-slow.log"; //local
$fp = fopen($file, "r");
if ($fp) {
    while (($line = fgets($fp, 4096)) !== false) {
        echo "<br/>" . $line;
    }
}
?>