由 longdas 在 07-26-2003 12:42 发表:
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