MySQL Server Links

General
Troubleshooting
  • Login error after used MySQL 4.1
    Password format changed in MySQL 4.1. Add this into /etc/my.cnf, reset the password again.

    [mysqld]
    old-passwords
    

    Reference: MySql 4.1 A Few Important Features To Consider

  • Client does not support authentication protocol
    Reset the password with: SET PASSWORD FOR ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);
    A.2.3 Client does not support authentication protocol

  • 050725 15:43:56 Warning: Asked for 196608 thread stack, but got 126976. InnoDB: Error: pthread_create returned 11
    You may have SELinux turned on. Check /var/log/messages, try to reconfig your policy. Or simply disable SELinux with: /usr/sbin/setenforce 0 and edit the /etc/sysconfig/selinux

  • Restore the database without foreign key constraint:
    SET FOREIGN_KEY_CHECKS = 0;
    SOURCE /path/backupfile.sql;
    SET FOREIGN_KEY_CHECKS = 1;
    
Tools
Documentation

發表迴響 (評論)