Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin. 解决方法

今天我的一位朋友在服务器上配置phpMyAdmin 连接阿里云的rds数据库(专业的Mysql数据库),结果我登陆的时候报了如下错误:

Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.

中文翻译

无法设置Session Cookie。 也许您使用的是HTTP而非HTTPS来访问phpMyAdmin。

Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.

 

解决方法

原因也很简单,是配置文件设置的问题,通常是配置不当造成的。

 

解决思路:

有极少数用户报告无法登录,并显示持久性错误消息“无法设置session cookie。也许您使用的是HTTP而不是HTTPS”。在某些情况下,清除phpMyAdmin cookie('pma *')可解决此问题。

 

说说我的整个解决过程吧!具体操作如下:

 

1、因为我的朋友最初是看的网上教程来操作的,他是直接把

\phpmyadmin\libraries\config.default.php

复制并重命名到

\phpmyadmin\config.inc.php

 

2、大家可以去看一下自己“config.inc.php”这个配置文件,是否有以pma开头的配置没有屏蔽掉?

由于我的朋友是直接复制的config.default.php,config.inc.php这上文件肯定有这个pma开头的,而且还没有屏蔽。例如:

config.inc.php

 

3、接下来,我们只需要正确修改 config.inc.php这个文件就行了,一般来说,我们只需要直接把:

\phpmyadmin\config.sample.inc.php

复制并重名为

\phpmyadmin\config.inc.php

 

然后增加以下配置就可以了!

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

我个人推测:

由于这上面四行配置在 \phpmyadmin\libraries\config.default.php 也是有的,我们也可以直接不加,直接去config.default.php修改成自己相应的就可以了,配置生效应该是有一个优先权的。

config.inc.php 大于 config.default.php,如果config.inc.php没有的,就去config.default.php找。

 

4、给大家看一下我的phpMyAdmin 4.9.2正确的config.inc.php代码:

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <https://docs.phpmyadmin.net/>.
 *
 * @package PhpMyAdmin
 */

/**
 * This is needed for cookie based authentication to encrypt password in
 * cookie. Needs to be 32 chars long.
 */
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/**
 * Servers configuration
 */
$i = 0;

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = ''; 
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma__relation';
// $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
// $cfg['Servers'][$i]['history'] = 'pma__history';
// $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
// $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
// $cfg['Servers'][$i]['recent'] = 'pma__recent';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['users'] = 'pma__users';
// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
// $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

/**
 * End of servers configuration
 */

/**
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
 * Whether to display icons or text or both icons and text in table row
 * action segment. Value can be either of 'icons', 'text' or 'both'.
 * default = 'both'
 */
//$cfg['RowActionType'] = 'icons';

/**
 * Defines whether a user should be displayed a "show all (records)"
 * button in browse mode or not.
 * default = false
 */
//$cfg['ShowAll'] = true;

/**
 * Number of rows displayed when browsing a result set. If the result
 * set contains more rows, "Previous" and "Next".
 * Possible values: 25, 50, 100, 250, 500
 * default = 25
 */
//$cfg['MaxRows'] = 50;

/**
 * Disallow editing of binary fields
 * valid values are:
 *   false    allow editing
 *   'blob'   allow editing except for BLOB fields
 *   'noblob' disallow editing except for BLOB fields
 *   'all'    disallow editing
 * default = 'blob'
 */
//$cfg['ProtectBinary'] = false;

/**
 * Default language to use, if not browser-defined or user-defined
 * (you find all languages in the locale folder)
 * uncomment the desired line:
 * default = 'en'
 */
//$cfg['DefaultLang'] = 'en';
//$cfg['DefaultLang'] = 'de';

/**
 * How many columns should be used for table display of a database?
 * (a value larger than 1 results in some information being hidden)
 * default = 1
 */
//$cfg['PropertiesNumColumns'] = 2;

/**
 * Set to true if you want DB-based query history.If false, this utilizes
 * JS-routines to display query history (lost by window close)
 *
 * This requires configuration storage enabled, see above.
 * default = false
 */
//$cfg['QueryHistoryDB'] = true;

/**
 * When using DB-based query history, how many entries should be kept?
 * default = 25
 */
//$cfg['QueryHistoryMax'] = 100;

/**
 * Whether or not to query the user before sending the error report to
 * the phpMyAdmin team when a JavaScript error occurs
 *
 * Available options
 * ('ask' | 'always' | 'never')
 * default = 'ask'
 */
//$cfg['SendErrorReports'] = 'always';

/**
 * You can find more configuration options in the documentation
 * in the doc/ folder or at <https://docs.phpmyadmin.net/>.
 */
    A+
发布日期:2019年12月10日 11:46:01  所属分类:PHP
最后更新时间:2019-12-10 11:47:59
标签:
付杰
  • ¥ 129.0元
  • 市场价:199.0元
  • ¥ 69.0元
  • 市场价:99.0元
  • ¥ 99.0元
  • 市场价:129.0元
  • ¥ 298.0元
  • 市场价:498.0元

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

目前评论:2   其中:访客  0   博主  0

  1. 头像 bcd 1

    麻烦分享下php的全套视频资料。

    • 付杰 付杰

      @bcd 百度网盘共享链接:https://pan.baidu.com/s/4oEe5gfC 24小时内有效

      友情提示:以后评论留言尽量去相对应的文章下。