您的位置:澳门402永利com > 关于计算机 > PHPmyadmin登入错误,PHPMyAdmin设置数据库连接端口代

PHPmyadmin登入错误,PHPMyAdmin设置数据库连接端口代

发布时间:2019-09-30 12:25编辑:关于计算机浏览(58)

     代码如下

    PHPmyadmin登陆错误:#2054 不能登录 MySQL 服务器 10C
    自个儿快炸裂了,互连网能找到的措施自身都试过了,都未有用,附上自个儿的安插
    /**

    /* Authentication type and info */
    $cfg['Servers'][$i]['auth_type'] = ‘config’;
    $cfg['Servers'][$i]['user'] = ‘root’;
    $cfg['Servers'][$i]['password'] = ”;
    $cfg['Servers'][$i]['port'] = ’3307′;
    $cfg['Servers'][$i]['extension'] = ‘mysql’;
    $cfg['Servers'][$i]['AllowNoPassword'] = true;
    $cfg['Lang'] = ”;

    • MySQL hostname or IP address*
    • @global string $cfg['Servers'][$i]['host']*/$cfg['Servers'][$i]['host'] = '127.0.0.1';

    例如MySQL的端口设置为3308,能够把安顿文件设置为:$cfg['Servers'][$i]['port'] = ’3308′;

    /**

    • MySQL port - leave blank for default port*
    • @global string $cfg['Servers'][$i]['port']*/$cfg['Servers'][$i]['port'] = '';

    /**

    • Path to the socket - leave blank for default socket*
    • @global string $cfg['Servers'][$i]['socket']*/$cfg['Servers'][$i]['socket'] = '';

    /**

    • Use SSL for connecting to MySQL server?*
    • @global boolean $cfg['Servers'][$i]['ssl']*/$cfg['Servers'][$i]['ssl'] = false;

    /**

    • Path to the key file when using SSL for connecting to the MySQL server*
    • @global string $cfg['Servers'][$i]['ssl_key']*/$cfg['Servers'][$i]['ssl_key'] = null;

    /**

    • Path to the cert file when using SSL for connecting to the MySQL server*
    • @global string $cfg['Servers'][$i]['ssl_cert']*/$cfg['Servers'][$i]['ssl_cert'] = null;

    /**

    • Path to the CA file when using SSL for connecting to the MySQL server*
    • @global string $cfg['Servers'][$i]['ssl_ca']*/$cfg['Servers'][$i]['ssl_ca'] = null;

    /**

    • Directory containing trusted SSL CA certificates in PEM format*
    • @global string $cfg['Servers'][$i]['ssl_ca_path']*/$cfg['Servers'][$i]['ssl_ca_path'] = null;

    /**

    • List of allowable ciphers for SSL connections to the MySQL server*
    • @global string $cfg['Servers'][$i]['ssl_ciphers']*/$cfg['Servers'][$i]['ssl_ciphers'] = null;

    /**

    • MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
    • peer_name of the SSL certifcate
    • For most self-signed certificates this is a problem. Setting this to false
    • will disable the check and allow the connection (PHP 5.6.16 or later)*
    • @link
    • @global string $cfg['Servers'][$i]['ssl_verify']*/$cfg['Servers'][$i]['ssl_verify'] = true;

    /**

    • Use compressed protocol for the MySQL connection*
    • @global boolean $cfg['Servers'][$i]['compress']*/$cfg['Servers'][$i]['compress'] = false;

    /**

    • MySQL control host. This permits to use a host different than the
    • main host, for the phpMyAdmin configuration storage. If left empty,
    • $cfg['Servers'][$i]['host'] is used instead.*
    • @global string $cfg['Servers'][$i]['controlhost']*/$cfg['Servers'][$i]['controlhost'] = '';

    /**

    • MySQL control port. This permits to use a port different than the
    • main port, for the phpMyAdmin configuration storage. If left empty,
    • $cfg['Servers'][$i]['port'] is used instead.*
    • @global string $cfg['Servers'][$i]['controlport']*/$cfg['Servers'][$i]['controlport'] = '';

    /**

    • MySQL control user settings (this user must have read-only
    • access to the "mysql/user" and "mysql/db" tables). The controluser is also
    • used for all relational features *
    • @global string $cfg['Servers'][$i]['controluser']*/$cfg['Servers'][$i]['controluser'] = '';

    /**

    • MySQL control user settings (this user must have read-only
    • access to the "mysql/user" and "mysql/db" tables). The controluser is also
    • used for all relational features *
    • @global string $cfg['Servers'][$i]['controlpass']*/$cfg['Servers'][$i]['controlpass'] = '';

    /**

    • Authentication method (valid choices: config, http, signon or cookie)*
    • @global string $cfg['Servers'][$i]['auth_type']*/$cfg['Servers'][$i]['auth_type'] = 'cookie';

    /**

    • MySQL user*
    • @global string $cfg['Servers'][$i]['user']*/$cfg['Servers'][$i]['user'] = 'root';

    /**

    • MySQL password (only needed with 'config' auth_type)*
    • @global string $cfg['Servers'][$i]['password']*/$cfg['Servers'][$i]['password'] = '123456';---------------------------------------------------**
    • whether to allow root login*
    • @global boolean $cfg['Servers'][$i]['AllowRoot']*/$cfg['Servers'][$i]['AllowRoot'] = true;

    /**

    • whether to allow login of any user without a password*
    • @global boolean

      $cfg['Servers'][$i]['AllowNoPassword']*/$cfg['Servers'][$i]['AllowNoPassword']

      true;-----------------------------------------------------给带男生磕头了,砰砰砰

    本文由澳门402永利com发布于关于计算机,转载请注明出处:PHPmyadmin登入错误,PHPMyAdmin设置数据库连接端口代

    关键词: