Lost connection to MySQL server during query.
Oops. I should have been paying more attention to the lost connection thread. What does the Lost connection to MySQL server during query error message mean and where can I find more information about it? I just installed the DBTools on a XP box. When I try to connect to by Linux box, it gives me this error. Linux 2.4 MySQL 3.23.52 Theodore Reph [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some Basic Questions I can't Find Answers to
Linda: MySQL is a database and Apache is a webserver. They are two independent applications. To access the MySQL database, you will use CGI programming or JSP. Theodore Reph [EMAIL PROTECTED] -Original Message- From: Linda Carter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: Some Basic Questions I can't Find Answers to I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, the MySQL database I want to run will be on my web host. Since I don't have the server physically in my possession, is the working method to install MySQL to my machine, develop the routines there, then upload them to my server? I've been going on that assumption and have attempted to install to my Windows 2000 pro system. Still fumbling with that. Should I be trying to install the version most like the one on my host's server? He's on LInux Apache. Will that cause a problem? I don't see anything in either of these books on uploading, which makes me wonder if they're assuming I have access to the actual server. Of course I do, in a limited way, but I don't see any explanations on how to access the MySQL on my virtual machine over at the web host's. What am I missing here? Linda Carter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Automatically start MySQLServer on RedHat Linux 7.3
To get MySQL to automatically to start at bootup for mode 3: In /etc/rc.d/rc3.d, mv K12mysql to S12mysql. Theodore Reph [EMAIL PROTECTED] -Original Message- From: Ken Morley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:31 AM To: '[EMAIL PROTECTED]' Subject: Automatically start MySQLServer on RedHat Linux 7.3 On my RedHat Linux 7.3 system with MySQL 3.23, I can manually start mysqld by using the following command: /usr/share/mysql/mysql.server start. I always want the SQL server daemon running, so how can I automate the startup? Also, isn't there a way to safely stop the daemon automatically on system shutdown? I have referred to the manual, but it is not specific to RH Linux 7.3 and I'm a newbie. Thanks very much for your help! Ken Morley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Moving the location of mysql.sock and mysql_setpermission
OS: Linux 2.4 Mysql: 3.23.52 /etc/my.cnf -- [mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock datadir=/usr6/mysql socket=/usr6/mysql/mysql.sock port=3306 [mysql.server] user=mysql #basedir=/var/lib basedir=/usr6 [safe_mysqld] #err-log=/var/log/mysqld.log err-log=/usr8/mysql/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/usr6/mysql/mysql.sock When I run mysql_setpermission --user ted I get the following error even though my.cnf has set socket for the client to /usr6/mysql/mysql.sock: Can't make a connection to the mysql server. The error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/bin/mysql_setpermission line 65, STDIN line 1. How do I fix this? -- Theodore Reph [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
