php phpMyAdmin 中的河豚秘密是什么?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/34961109/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-26 00:18:04  来源:igfitidea点击:

What is a blowfish secret in phpMyAdmin?

phpphpmyadminblowfish

提问by Muteking

About setting up the config.inc.php, the official phpMyAdmin docs says

关于设置 config.inc.php,官方 phpMyAdmin 文档说

$cfg['blowfish_secret'] = 'theExampleWrites16ValuesHere';  // use here a value of your choice

What is a blowfish secret? How do I generate, or choose, a value?

河豚的秘密是什么?我如何生成或选择一个值?

回答by Dave

Simply use any random string of characters and/or numbers that you like. It is a value that will be unique to your instance and use of phpMyAdmin.

只需使用您喜欢的任何随机字符串和/或数字即可。该值对于您的实例和 phpMyAdmin 的使用是唯一的。

回答by Faisal Abdul Rahiman Athikkai

Go to phpMyadmin Directory and open the config file >> /phpMyadmin/config.inc.php

转到 phpMyadmin 目录并打开配置文件 >> /phpMyadmin/config.inc.php

Locate >> $cfg['blowfish_secret'] = ''; /YOU MUST FILL IN THIS FOR COOKIE AUTH! /

定位>> $cfg['blowfish_secret'] = ''; /您必须填写此信息以获得 Cookie 身份验证!/

Enter a string which should be not less than 32 characters. {You can include Number, Characters&SpecialCharacters} Save and reload the page (//yourdomainname.*/phpmyadmin) and log in again. That should fix the error.

输入一个不少于 32 个字符的字符串。{You can include Number, Characters&SpecialCharacters} 保存并重新加载页面 (//yourdomainname.*/phpmyadmin) 并再次登录。那应该修复错误。

Ref: https://wiki.archlinux.org/index.php/PhpMyAdmin#Add_blowfish_secret_passphrase

参考:https: //wiki.archlinux.org/index.php/PhpMyAdmin#Add_blowfish_secret_passphrase

Thanks and Regards

感谢致敬

回答by Houssin Boulla

go to /var/lib/phpmyadmin/blowfish_secret.inc.php and add some caracters to be 32 in length like this:

转到 /var/lib/phpmyadmin/blowfish_secret.inc.php 并添加一些长度为 32 的字符,如下所示:

$cfg['blow_secret'] = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

save file and refresh phpMyAdmin.

保存文件并刷新 phpMyAdmin。

回答by NA Hoijtink

in /usr/share/phpmyadmin/libraries/vendor_config.phpthe config dir variable might either be empty or missing the trailing slash, change it into:

/usr/share/phpmyadmin/libraries/vendor_config.phpconfig dir 变量中可能为空或缺少尾部斜杠,请将其更改为:

define('CONFIG_DIR', '/etc/phpmyadmin/'); 

The permission to this temporary directory needs to be set correctly in /usr/share/phpmyadmin/libraries/vendor_config.php. It solved it for me. define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');

这个临时目录的权限需要在/usr/share/phpmyadmin/libraries/vendor_config.php 中正确设置。它为我解决了它。定义('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');

Also if you are missing the Users tab in PhpMyAdmin, it is caused because of insufficient rights. Run GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION;from the mysql console (your your own administrative username) while logged in with root privileges.

此外,如果您在 PhpMyAdmin 中缺少用户选项卡,这是由于权限不足造成的。GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION;以 root 权限登录时,从 mysql 控制台(您自己的管理用户名)运行。