Jump to content

THOR

Members
  • Posts

    192
  • Joined

  • Last visited

  • Days Won

    3

Posts posted by THOR

  1. WoWFailureCMS <- Google

    NEW:

    Advanced WebsiteCMS for World of Warcraft Private Servers. Based on TrinityCore, Mangos, SkyfireEMU & VoragineCore. Easy to setup and easy to use! A nice Blizzlike Website.

    Link Removed by AlterEgo. Much as I love the work you did I can't allow your link because it contains copyrighted images.

    Try Google search for WoWFailureCMS

  2. Global Privileges

    Global privileges are administrative or apply to all databases on a given server. To assign global privileges, use ON *.* syntax:

    GRANT ALL ON *.* TO 'SomeMysqlUser'@'somehost';

    or

    GRANT ALL PRIVILEGES ON *.* TO 'YourMysqlUserName'@'YourIP' IDENTIFIED BY "YourMysqlPassword";

    Example:

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY "*****";
    __________________________________________
  3. Error Code: 2006 - MySQL server has gone away

    • Start MySQL 5.5 Command Line Client
    • At the command prompt, execute the foll. command

      mysql> show variables like 'max_allowed_packet';

    ___________________________

    | Variable_name | Value |

    ___________________________

    | max_allowed_packet | 1048576 |

    ___________________________

    1 row in set (0.00 sec)

    • At the command prompt, execute the foll. command

      mysql> set global max_allowed_packet = 130 * 1024 * 1024;

    • Exit
    • Start MySQL 5.5 Command Line Client
    • At the command prompt, execute the foll. command

      mysql> show variables like 'max_allowed_packet';

    _____________________________

    | Variable_name | Value |

    _____________________________

    | max_allowed_packet | 136314880 |

    _____________________________

    1 row in set (0.00 sec)

    This will set the global max packet size to 130 MB. All subsequent MySQL client connections will get this value as their session value for max packet

    Now:

    Source Database : information_schema

    `GLOBAL_VARIABLES` VALUES ('MAX_ALLOWED_PACKET', '136314880');
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.