Make sure that all the files inside your database directories are owned by
mysql:
chown -R mysql. <database dir>
The dot at the end of "mysql" above sets the group to mysql also. The "-R"
means set the permissions recursively. Each time I install a binary
distribution and run the "scripts/mysql_install_db" script, I have to do
this or I get the error you've gotten. The mysql daemon needs to be able to
read and write these files.
--jeff
----- Original Message -----
From: "Saul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 2:10 PM
Subject: Re: Problem starting 4.0.12 server
>
> > From: Jeff Kilpatrick <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Organization:
> > Date: 26 Mar 2003 16:03:38 -0600
> >
> > Yes, probably. I've never used a mysql rpm, so I don't know how
they're
> > packaged. /var/lib/mysql is an odd place to stick that socket
though.
> > I've always seen it in /tmp or someplace similar (and world
readable).
>
> That appears to be the default location.
>
> > errno = 13 --> "Permission denied" Make sure that directory is owned
by
> > mysql, ie
> > $ chown mysql <database dir>
> > $ chmod 700 <database dir>
>
> Actually, it was 755... and owned by mysql, group mysql.
>
> > It seems rather odd that an rpm would stick anything in /ul/mysql.
Did
> > you move the stuff there and create a symbolic link to it? That
won't
> > necessarily perserve permissions and ownership.
>
> I had created /u1/mysql and put a link to it when I installed 3.23. As I
> said, I had tested with that and everything worked fine. All I did was,
after
> blowing away the databases, and uninstalling 3.23, was to install 4.0.12.
I
> started with the sources and had problems. When the rpms came out, I
thought
> the prebuilt versions would solve my problem as the prebuilt version
worked
> before.
>
> > If you're having that much trouble with the rpm, a source build may
or
> > may not be what you're looking for. I'd go that route, but any of my
> > co-workers can attest to the fact that I'm an obsessive compiler.
>
> Well, I could... except that the documentation, as far as I'm concerned,
> leaves a lot to be desired.
>
> > -jeff
> >
> > On Wed, 2003-03-26 at 15:49, Saul wrote:
> > > > From: Jeff Kilpatrick <[EMAIL PROTECTED]>
> > > > Cc: [EMAIL PROTECTED]
> > > > Organization:
> > > > Date: 25 Mar 2003 21:08:56 -0600
> > > >
> > > > Does the mysql user have permission to write to
/var/lib/mysql?
> > > > -jeff
> > >
> > > Well, it didn't. But, shouldn't it have been set that way after
the rpm
> > > package was installed?
> > >
> > > Now, it says:
> > >
> > > Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm'
> > > (errno: 13)
> > > 030326 16:39:58 Aborting
> > >
> > > datadir is set to /var/lib/mysql which is a symbolic link to
/u1/mysql.
> > >
> > > For what it's worth, I've been having a lot of problems with mysql.
I had
> > > mysql 3.23 installed, and was testing a message board ("phpBB2")
for use with
> > > mysql. When I went to make the board "production", I used
mysqladmin to drop
> > > the database I had been using for testing, and then to create a new
database
> > > (different name) for production. When I tried to run the phpBB2
installer
> > > against the new database, it failed. I couldn't figure out what
happened;
> > > following the same installation instructions, I was getting weird
error after
> > > weird error. So, I figured I would start from scratch. I figured
as long as
> > > I was doing that, I would start with mysql 4... and have been
having problem,
> > > after problem, after problem. I worked for over a week from the
sources and
> > > got nowhere and then I saw that this release finally hit
"production" and am
> > > starting all over again... and here I am unable to run mysql...
> > >
> > > >Does the mysql user have permission to write to /var/lib/mysql?
> > > >-jeff
> > > >
> > > >On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote:
> > > >> >Description:
> > > >> Just installed the rpm files for Linux x86 downloaded from the
web.
> > > >> After installing rpm files, server won't start. The error (from
the log) is:
> > > >>
> > > >> 030325 21:23:41 mysqld started
> > > >> 030325 21:23:41 Can't start server : Bind on unix socket:
Permission denied
> > > >> 030325 21:23:41 Do you already have another mysqld server
running on socket: /var/lib/mysql/mysql.sock ?
> > > >> 030325 21:23:41 Aborting
> > > >>
> > > >> 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete
> > > >>
> > > >> 030325 21:23:41 mysqld ended
> > > >>
> > > >> I've checked, and /var/lib/mysql/mysql.sock doesn't exist.
Shouldn't the
> > > >> server create it?
> > > >>
> > > >> >How-To-Repeat:
> > > >>
> > > >> >Fix:
> > > >>
> > > >>
> > > >> >Submitter-Id: <submitter ID>
> > > >> >Originator: Saul
> > > >> >Organization:
> > > >> Saul Jaffe
> > > >> [EMAIL PROTECTED]
> > > >>
> > > >> >MySQL support: [none | licence | email support | extended email
support ]
> > > >> >Synopsis: Can't start server
> > > >> >Severity: serious
> > > >> >Priority: high
> > > >> >Category: mysql
> > > >> >Class: support
> > > >> >Release: mysql-4.0.12 (Official MySQL RPM)
> > > >>
> > > >> >C compiler: 2.95.3
> > > >> >C++ compiler: 2.95.3
> > > >> >Environment:
> > > >>
> > > >> System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT
2001 i686 unknown
> > > >> Architecture: i686
> > > >>
> > > >> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake
/usr/bin/gcc /usr/bin/cc
> > > >> GCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> > > >> gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
> > > >> Compilation info: CC='gcc'
CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex
ceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
> > > >> LIBC:
> > > >> lrwxrwxrwx 1 root root 13 Aug 13 2001
/lib/libc.so.6 -> libc-2.2.2.so
> > > >> -rwxr-xr-x 1 root root 1236396 Apr 6 2001
/lib/libc-2.2.2.so
> > > >> -rw-r--r-- 1 root root 26350254 Apr 6 2001
/usr/lib/libc.a
> > > >> -rw-r--r-- 1 root root 178 Apr 6 2001
/usr/lib/libc.so
> > > >> lrwxrwxrwx 1 root root 10 Aug 13 2001
/usr/lib/libc-client.a -> c-client.a
> > > >> Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl'
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--with-embedded-server' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM'
'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium'
'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex
ceptions -fno-rtti -mpentium'
> > > >>
> >
>
> --
> Saul Jaffe
> Mouch Potato
> [EMAIL PROTECTED]
>
> To a touch typist, having the space bar workonly 30% of the
> time, is damned frustrating. So, insert spaces as needed to
> make this message make sense.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
