mysql有问题。服务在运行,可是其他WEB服务器却读到这台MYSQL的数据
longdas
|
1#
longdas 发表于 2003-07-26 12:45
mysql有问题。服务在运行,可是其他WEB服务器却读到这台MYSQL的数据
1台服务器安装了MYSQL,运行数据库。
另1台服务器使用apache+php, 远程读取服务器1的数据库。 可是有时候,mysql的服务还在运行, WEB服务器就读不到SQL了。重启一次mysql就正常了。可能是什么原因呢?? 下面是tail -n 100 /var/log/messages Jul 26 09:31:36 server6 mysqld: Initializing MySQL database: succeeded Jul 26 09:31:36 server6 mysqld: Starting MySQL: succeeded Jul 26 09:32:17 server6 mysqld: Stopping MySQL: succeeded Jul 26 09:33:00 server6 mysql_install_db: Installing all prepared tables Jul 26 09:33:00 server6 mysql_install_db: 030726 9:33:00 /usr/libexec/mysqld: Shutdown Complete Jul 26 09:33:00 server6 mysql_install_db: Jul 26 09:33:00 server6 mysql_install_db: To start mysqld at boot time you have to copy support-files/ mysql.server Jul 26 09:33:00 server6 mysql_install_db: to the right place for your system Jul 26 09:33:00 server6 mysql_install_db: Jul 26 09:33:00 server6 mysql_install_db: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jul 26 09:33:00 server6 mysql_install_db: This is done with: Jul 26 09:33:00 server6 mysql_install_db: /usr/bin/mysqladmin -u root -p password 'new-password' Jul 26 09:33:00 server6 mysql_install_db: /usr/bin/mysqladmin -u root -h server6.whedu.net -p password 'new- password' Jul 26 09:33:00 server6 mysql_install_db: See the manual for more instructions. Jul 26 09:33:00 server6 mysql_install_db: Jul 26 09:33:00 server6 mysql_install_db: NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run Jul 26 09:33:00 server6 mysql_install_db: the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be Jul 26 09:33:01 server6 mysql_install_db: able to use the new GRANT command! Jul 26 09:33:01 server6 mysql_install_db: Jul 26 09:33:01 server6 mysql_install_db: You can start the MySQL daemon with: Jul 26 09:33:01 server6 mysql_install_db: cd /usr ; /usr/bin/safe_mysqld & Jul 26 09:33:02 server6 mysql_install_db: Jul 26 09:33:02 server6 mysql_install_db: You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: Jul 26 09:33:02 server6 mysql_install_db: cd sql-bench ; run-all-tests Jul 26 09:33:02 server6 mysql_install_db: Jul 26 09:33:02 server6 mysql_install_db: Please report any problems with the /usr/bin/mysqlbug script! Jul 26 09:33:02 server6 mysql_install_db: Jul 26 09:33:02 server6 mysql_install_db: The latest information about MySQL is available on the web at Jul 26 09:33:02 server6 mysql_install_db: http://www.mysql.com Jul 26 09:33:02 server6 mysql_install_db: Support MySQL by buying support/licenses at https://order.mysql.com Jul 26 09:33:02 server6 mysql_install_db: Jul 26 09:33:03 server6 mysql_install_db: Jul 26 09:33:03 server6 mysqld: Initializing MySQL database: succeeded Jul 26 09:33:03 server6 mysqld: Starting MySQL: succeeded Jul 26 09:33:32 server6 sshd(pam_unix)[25467]: session opened for user root by (uid=0) Jul 26 09:44:28 server6 sshd(pam_unix)[25467]: session closed for user root Jul 26 11:28:19 server6 sshd(pam_unix)[26193]: session opened for user root by (uid=0) Jul 26 11:28:27 server6 mysql_install_db: Installing all prepared tables Jul 26 11:28:27 server6 mysql_install_db: 030726 11:28:27 /usr/libexec/mysqld: Shutdown Complete Jul 26 11:28:27 server6 mysql_install_db: Jul 26 11:28:27 server6 mysql_install_db: Jul 26 11:28:27 server6 mysql_install_db: To start mysqld at boot time you have to copy support-files/ mysql.server Jul 26 11:28:27 server6 mysql_install_db: to the right place for your system Jul 26 11:28:27 server6 mysql_install_db: Jul 26 11:28:27 server6 mysql_install_db: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jul 26 11:28:27 server6 mysql_install_db: This is done with: Jul 26 11:28:27 server6 mysql_install_db: /usr/bin/mysqladmin -u root -p password 'new-password' Jul 26 11:28:27 server6 mysql_install_db: /usr/bin/mysqladmin -u root -h server6.whedu.net -p password 'new- password' Jul 26 11:28:27 server6 mysql_install_db: See the manual for more instructions. Jul 26 11:28:27 server6 mysql_install_db: Jul 26 11:28:28 server6 mysql_install_db: NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run Jul 26 11:28:28 server6 mysql_install_db: the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be Jul 26 11:28:28 server6 mysql_install_db: able to use the new GRANT command! Jul 26 11:28:28 server6 mysql_install_db: Jul 26 11:28:28 server6 mysql_install_db: You can start the MySQL daemon with: Jul 26 11:28:28 server6 mysql_install_db: cd /usr ; /usr/bin/safe_mysqld & Jul 26 11:28:28 server6 mysql_install_db: Jul 26 11:28:28 server6 mysql_install_db: You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: Jul 26 11:28:28 server6 mysql_install_db: cd sql-bench ; run-all-tests Jul 26 11:28:28 server6 mysql_install_db: Jul 26 11:28:28 server6 mysql_install_db: Please report any problems with the /usr/bin/mysqlbug script! Jul 26 11:28:28 server6 mysql_install_db: Jul 26 11:28:28 server6 mysql_install_db: The latest information about MySQL is available on the web at Jul 26 11:28:28 server6 mysql_install_db: http://www.mysql.com Jul 26 11:28:29 server6 mysql_install_db: Support MySQL by buying support/licenses at https://order.mysql.com Jul 26 11:28:29 server6 mysql_install_db: Jul 26 11:28:29 server6 mysqld: Initializing MySQL database: succeeded Jul 26 11:28:29 server6 mysqld: Starting MySQL: succeeded Jul 26 11:28:37 server6 mysqld: Stopping MySQL: succeeded Jul 26 11:28:37 server6 mysql_install_db: Installing all prepared tables Jul 26 11:28:37 server6 mysql_install_db: 030726 11:28:37 /usr/libexec/mysqld: Shutdown Complete Jul 26 11:28:37 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: To start mysqld at boot time you have to copy support-files/ mysql.server Jul 26 11:28:38 server6 mysql_install_db: to the right place for your system Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jul 26 11:28:38 server6 mysql_install_db: This is done with: Jul 26 11:28:38 server6 mysql_install_db: /usr/bin/mysqladmin -u root -p password 'new-password' Jul 26 11:28:38 server6 mysql_install_db: /usr/bin/mysqladmin -u root -h server6.whedu.net -p password 'new- password' Jul 26 11:28:38 server6 mysql_install_db: See the manual for more instructions. Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run Jul 26 11:28:38 server6 mysql_install_db: the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be Jul 26 11:28:38 server6 mysql_install_db: able to use the new GRANT command! Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: You can start the MySQL daemon with: Jul 26 11:28:38 server6 mysql_install_db: cd /usr ; /usr/bin/safe_mysqld & Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: Jul 26 11:28:38 server6 mysql_install_db: cd sql-bench ; run-all-tests Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: Please report any problems with the /usr/bin/mysqlbug script! Jul 26 11:28:38 server6 mysql_install_db: Jul 26 11:28:38 server6 mysql_install_db: The latest information about MySQL is available on the web at Jul 26 11:28:39 server6 mysql_install_db: http://www.mysql.com Jul 26 11:28:39 server6 mysql_install_db: Support MySQL by buying support/licenses at https://order.mysql.com Jul 26 11:28:39 server6 mysql_install_db: Jul 26 11:28:39 server6 mysqld: Initializing MySQL database: succeeded Jul 26 11:28:39 server6 mysqld: Starting MySQL: succeeded |