Not sure how helpful I'll be able to be for you. I installed
MySQL-3.23.36-1.i386.rpm and MySQL-client-3.23.36-1.i386.rpm packages. I
verified that everything worked as root and then shutdown the server. I
then followed the steps outlined on p. 476 of the manual (also p. 419 of
Monty Widenius' MySQL book). I also received some advice from another
person on this list -- I've attached it below -- that I used.
I discovered in my (server name).err file -- mine was located in my
/var/lib/mysql directory -- that mysqld couldn't find the
/var/lib/mysql/mysql/host.frm file. After changing the permissions on the
mysql table to 760, everything worked fine. As you'll see below, the
recommendation was to set it to 660.
Hope this helps a bit ...
-Brian
-----------------------------------
Excerpt from note I received:
You should create a "mysql" group also, and make sure that the "mysql" user
has it as it's "primary group ID" (in /etc/passwd). Then you can add the
appropriate users (such as your own login) to the group (so you don't have
to be "root" to access the mysql stuff).
You can leave your "mysql" program directory owned by "root.root" (user and
group = "root"), as long as the "var" subdirectory and all the files and
directories in "var" are owned by "mysql.mysql" with 2770 (rwxrws---) for
the directory permissions and 660 (rw-rw----) for the files... Set the
same ownership and permissions for the 'data' directories (if you've placed
them somewhere else on the system (linked to 'var' via symbolic links).
----- Original Message -----
From: "Foresight Systems Ltd." <[EMAIL PROTECTED]>
To: "Brian Warn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:57 AM
Subject: Mysqld problem Re: ownership/permission problems
> Dear Sir,
> Since you already have mysql running, we seek your help in sorting out
> some problem.
> mysqld starts and ends instantaneously.
> <BR>We are using Red Hat Linux 7.0 /Apache Server on PIII 550 intel
> processor.
> <BR>We have compiled the mysql and installed version 3.23.32.
> <BR>The contents of our my.cnf file in /etc is as follows :
> <BR>========================================================
> <BR># Example mysql config file.
> <BR># You can copy this to one of:
> <BR># /usr/local/mysql/etc/my.cnf to set global options,
> <BR># mysql-data-dir/my.cnf to set server-specific options (in this
> <BR># installation this directory is /usr/local/mysql/var) or
> <BR># ~/.my.cnf to set user-specific options.
> <BR>#
> <BR># One can use all long options that the program supports.
> <BR># Run the program with --help to get a list of available options
>
> <P># This will be passed to all mysql clients
> <BR>[client]
> <BR>#password = my_password
> <BR>port = 3306
> <BR>socket = /var/lib/mysql/mysql.sock
>
> <P># Here is entries for some specific programs
> <BR># The following values assume you have at least 32M ram
>
> <P># The MySQL server
> <BR>[mysqld]
> <BR>port = 3306
> <BR>socket = /var/lib/mysql/mysql.sock
> <BR>skip-locking
> <BR>set-variable = key_buffer=16M
> <BR>set-variable = max_allowed_packet=1M
> <BR>set-variable = thread_stack=128K
> <BR># Start logging
> <BR>log
>
> <P>[mysqldump]
> <BR>quick
> <BR>set-variable = max_allowed_packet=16M
>
> <P>[mysql]
> <BR>no-auto-rehash
>
> <P>[isamchk]
> <BR>set-variable = key_buffer=16M
> <BR>==================================================================
> <BR>The contents on the error file is follows
>
> <P>010403 16:19:55 mysqld started
> <BR>010403 16:19:56 Can't start server : Bind on unix socket:
> Permission
> denied
> <BR>010403 16:19:56 Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> <BR>010403 16:19:56 Aborting
>
> <P>010403 16:19:56 mysqld ended
>
> <P>010403 16:35:05 mysqld started
> <BR>010403 16:35:05 Can't start server : Bind on unix socket:
> Permission
> denied
> <BR>010403 16:35:05 Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> <BR>010403 16:35:05 Aborting
>
> <P>010403 16:35:05 mysqld ended
>
> <P>010403 17:09:52 mysqld started
> <BR>010403 17:09:52 Can't start server : Bind on unix socket:
> Permission
> denied
> <BR>010403 17:09:52 Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> <BR>010403 17:09:52 Aborting
>
> <P>010403 17:09:52 mysqld ended
>
> <P>====================================================================
> <BR>Further,We have also tried latest available rpm installation -i386
> downloaded from mysql.com.
> <BR>using command
> <BR>rpm -i rpm-file-name
> <BR>but it fails to install rpm package just stating
> <BR>can not install rpm
> Please guide, how to create mysql users,set permissions,ownerships etc.
>
> Regards
> Akshaya
>
> Brian Warn wrote:
>
> > I finally did find a discussion in Monty's book on p. 417 about this.
> >
> > Thanks,
> > Brian
> >
> > ----- Original Message -----
> > From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 03, 2001 11:20 AM
> > Subject: Re: ownership/permission problems
> >
> > >
> > > >I haven't had any success so far finding any help in the manual or
> > Monty's
> > > >book about this particular condition, so any help is appreciated.
> > >
> > > I don't know about the RPM's. But if you would install from source
> > there
> > is
> > > a directory called Docs containing a manual.txt I did NOT compare
> > this
> > with
> > > the online manual but this one states clearly how to start MySQL as
> > another
> > > user.
> > >
> > > Bye,
> > >
> > >
> > > B.
> > >
> > >
> > >
> > ---------------------------------------------------------------------
> > > 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
> >
> > _________________________________________________________
> >
> > Do You Yahoo!?
> >
> > Get your free @yahoo.com address at http://mail.yahoo.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
>
>
>
>
> ---------------------------------------------------------------------
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
