LinuxSir.cn,穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
查看: 547|回复: 0

mysql有问题。服务在运行,可是其他WEB服务器却读到这台MYSQL的数据。

[复制链接]
发表于 2003-7-26 12:42:37 | 显示全部楼层 |阅读模式
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
您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表