phpMyAdmin-会话启动期间出现错误Mysql错误 [英] phpMyAdmin - Error Mysql error during session start

问题描述

我在使用MySQL时遇到问题，在清除Chrome浏览器数据后，就会出现此问题.

I had a problem with MySQL, this problem appears after I clean chrome browsing data.

错误看起来像这样.

The error looks like this.

每次我访问PHPMyAdmin时也会出现此错误，并且也无法访问数据库.

This error appears every time I access PHPMyAdmin, and also I can't access my databases.

到目前为止，我已经做过的事情是:

What I already did so far are :

1. https://github.com/rtCamp/easyengine/issues/302 -不起作用
2. 从其他浏览器访问PHPMyAdmin-结果相同

1. https://github.com/rtCamp/easyengine/issues/302 - not work
2. Access PHPMyAdmin from other browsers -same result

为最坏的情况做准备，如何备份数据库?，因为我无法从终端访问数据库.

Prepare for the worst, how to back up my databases?, because I can't access my databases from terminal.

更新: 我一直在关注链接，并创建php_error.php文件，这就是结果

UPDATE : I have been following this link and create php_error.php file this is the result

警告:session_start():打开(/opt/lampp/temp//sess_eobqtotm38tean46jjthbih1m3，O_RDWR)失败: /opt/lampp/htdocs/portofolio1/php_error.php中的权限被拒绝(13) 在第6行

Warning: session_start(): open(/opt/lampp/temp//sess_eobqtotm38tean46jjthbih1m3, O_RDWR) failed: Permission denied (13) in /opt/lampp/htdocs/portofolio1/php_error.php on line 6

如果会话可以成功启动，则您不会看到任何内容 警告，否则请检查 警告正确的访问权限.当前的"session.save_path" 是"/opt/lampp/temp/".会话文件名: "sess_eobqtotm38tean46jjthbih1m3".

If a session could be started successfully you should not see any Warning(s), otherwise check the path/folder mentioned in the warning(s) for proper access rights. The current "session.save_path" is "/opt/lampp/temp/". Session file name: "sess_eobqtotm38tean46jjthbih1m3".

警告:未知: 打开(/opt/lampp/temp//sess_eobqtotm38tean46jjthbih1m3，O_RDWR)失败: 权限在第0行的未知"中被拒绝(13)

Warning: Unknown: open(/opt/lampp/temp//sess_eobqtotm38tean46jjthbih1m3, O_RDWR) failed: Permission denied (13) in Unknown on line 0

警告:未知:无法写入会话数据(文件).请确认 当前session.save_path的设置是正确的 (/opt/lampp/temp/)在第0行的未知"中

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/opt/lampp/temp/) in Unknown on line 0

现在我下一步该怎么做?

Now what I should do next?

已解决！

关注该网站

通过在终端上输入

sudo chmod -R 705 /opt/lampp/temp/sess_su8nntc1mvi9t3t6b3vu67kuquc9p012

和

sudo chown -R $user /opt/lampp/temp/sess_su8nntc1mvi9t3t6b3vu67kuquc9p012

change $user with your username

sess_su8nntc1mvi9t3t6b3vu67kuquc9p012 is my session file, it should be different on your system

感谢axiac ^^

Thanks, axiac^^

推荐答案

尝试这样

sudo chown root:root /opt/lampp/temp/sess_243ca2147169ded5d73ae8290b2f68fe

这篇关于phpMyAdmin-会话启动期间出现错误Mysql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！