麦克斯GO

标签： mysql

  • Error establishing a database connection on WordPress

    ????? 如果你使用的是Windows主机，运行WordPress时出现“Error establishing a database connection”意为数据库无法连接。遇到这种情况首先请检查MySQL设置，看是否启用了远程访问并打开了3306端口，再检查Windows防火墙是否阻止了该服务。

  • Client does not support authentication protocol requested by server

    mysql4.1以上版本连接时出现Client does not support authentication protocol requested by server; consider upgrading MySQL client问题解决办法

    官方的说法：MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. …..
    ?? 如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client 是4.1或者更高版本.(WINDOWS下有问题你就直接跳到下面看解决方法了,因为MYSQL 在WINDOWS是client和server一起装上了的)

    请使用以下两种方法之一

    其一:

    mysql> SET PASSWORD FOR
    ??? -> ‘root’@’localhost’?= OLD_PASSWORD(‘newpwd’);

    其二:

    mysql> UPDATE mysql.user SET Password = OLD_PASSWORD(‘newpwd’)
    ??? -> WHERE Host = ‘localhost’ AND User = ‘root’;
    mysql> FLUSH PRIVILEGES;
    ?