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]
