re: RE: MySQL Help Needed Please
On Sunday 05 January 2003 09:08, Anton Zavrin wrote: Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Anton, look in the error log file to see the causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: MySQL Help Needed Please
Anton, # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended This symptom shows when the privilege tables (i.e. the mysql database) has not been installed. Under Unix/Linux, there's a script for this. You can find details here: http://www.mysql.com/doc/en/Post-installation.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 8:08 AM Subject: RE: MySQL Help Needed Please Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re
RE: MySQL Help Needed Please
I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - 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: MySQL Help Needed Please
Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - 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: MySQL Help Needed Please
Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - 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: MySQL Help Needed Please
Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - 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: MySQL Help Needed Please
Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, ps -ef | grep mysqld got nothing Because the MySQL SERVER isn't running! Though I can do: # mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Anton Zavrin [EMAIL PROTECTED] To: 'Thomas Spahni' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - Before
Re: MySQL Help Needed Please
Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton - 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