Re: newbie - connect error
On Fri, 16 Jan 2004, tait sanders wrote: yep I've already done this. everything I do comes back with the same error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I even deleted the mysql.sock and used 'mysql_config --socket' to recreate it. this produces a new mysql.sock but then trying to start mysql produces the error of before. can i uninstall mysql rather than deleting it. I've tried the 'rpm' utility but it's not on my os. thanks heaps for all your help. You can see if MySQL is actually running with ps. If it is running you can see what socket it's using with `netstat -a | grep mysql` You can try to connect through tcp/ip instead of the socket by using -h 127.0.0.1 at the commandline. If the server isn't up, the info should be in the error log why it doesn't like to start. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie - connect error
Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe ' I get a message that: Starting mysqld daemon with databases from /var/mysql 040116 10:07:57 mysqld ended then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw
Re: newbie - connect error
Hi, Tait. It sounds like your server is never actually starting properly. There could be any number of reasons for this - it's best to work through the installation instructions that came with the package. To see what failed, chances are good there is an entry in the error log (it will probably be named hostname.err where hostname is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe ' I get a message that: Starting mysqld daemon with databases from /var/mysql 040116 10:07:57 mysqld ended then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie - connect error
well I found my hostname.err file. It states this: mysqld started InnoDB: Operating system error number 13 in a file operation. The error means that mysqld does not have the access rights to the directory. mysqld ended. so okay - how do I give mysqld the rights to the directory?? I've got mysql installed in /usr/bin/mysql and the db's and logs in /var/mysql - this is where the mysql db itself is. ta tait On 16/01/2004, at 10:36 AM, Gregory Newby wrote: Hi, Tait. It sounds like your server is never actually starting properly. There could be any number of reasons for this - it's best to work through the installation instructions that came with the package. To see what failed, chances are good there is an entry in the error log (it will probably be named hostname.err where hostname is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe ' I get a message that: Starting mysqld daemon with databases from /var/mysql 040116 10:07:57 mysqld ended then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby tait sanders computer technician sir robert webster bldg trc unsw
Re: newbie - connect error
On Fri, Jan 16, 2004 at 12:04:38PM +1100, tait sanders wrote: well I found my hostname.err file. It states this: mysqld started InnoDB: Operating system error number 13 in a file operation. The error means that mysqld does not have the access rights to the directory. mysqld ended. so okay - how do I give mysqld the rights to the directory?? Here are the steps from INSTALL-BINARY, a file you should already have with your MySQL software: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql *shell scripts/mysql_install_db *shell chown -R root . *shell chown -R mysql data *shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql The starred items are the ones you need to pay attention to. You'll need to run them as root, of course. Make sure you have a user called mysql, and a group called mysql. From your description, it's not clear whether you already did this. If you installed other than with a binary distribution from mysql.com (or a mirror), it is possible that things are in somewhat different locations than in the INSTALL-BINARY file. But get the file (it comes with the distributions you download) so you can see the steps. It sounds like you are almost there! -- Greg I've got mysql installed in /usr/bin/mysql and the db's and logs in /var/mysql - this is where the mysql db itself is. ta tait On 16/01/2004, at 10:36 AM, Gregory Newby wrote: Hi, Tait. It sounds like your server is never actually starting properly. There could be any number of reasons for this - it's best to work through the installation instructions that came with the package. To see what failed, chances are good there is an entry in the error log (it will probably be named hostname.err where hostname is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: Hi, I'm a newbie to mysql. I'm running an os10.3 server with mysql v. 4.0.16 When I try to start mysql with 'mysqld_safe ' I get a message that: Starting mysqld daemon with databases from /var/mysql 040116 10:07:57 mysqld ended then nothing... the terminal is blank. when I then do 'ps auwx | grep mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby tait sanders computer technician sir robert webster bldg trc unsw -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie - connect error
On 16/01/2004, at 12:32 PM, Gregory Newby wrote: From your description, it's not clear whether you already did this. If you installed other than with a binary distribution from mysql.com (or a mirror), it is possible that things are in somewhat different locations than in the INSTALL-BINARY file. But get the file (it comes with the distributions you download) so you can see the steps. yep I've already done this. everything I do comes back with the same error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I even deleted the mysql.sock and used 'mysql_config --socket' to recreate it. this produces a new mysql.sock but then trying to start mysql produces the error of before. can i uninstall mysql rather than deleting it. I've tried the 'rpm' utility but it's not on my os. thanks heaps for all your help. ta tait tait sanders computer technician sir robert webster bldg trc unsw