moneyslow.com

Tag: mysql错误

  • 报错ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

    报错ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

    —

    from

    moneyslow
    of

    大概意思是全局参数不能设置到特定数据库 Since the REPLICATION SLAVE privileges are global and can not be assigned to a particular database, they must be specified globally in the query, so the SQL query should look like this: 改成*.*就好了： GRANT REPLICATION SLAVE ON *.* TO “replication”@”192.168.1.9” IDENTIFIED BY “password”;

  • FATAL ERROR: Could not find ./bin/my_print_defaults

    —

    from

    moneyslow
    of

    一般还有如下提示： If you compiled from source, you need to run ‘make install’ to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the –basedir option pointing to that location.   所以我们按照提示把basedir 也加上： /usr/local/mysql/bin/mysql_install_db…