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