-----Ursprungliche Nachricht-----
Von: Foresight Systems Ltd. [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 4. April 2001 10:57
An: Brian Warn;
Betreff: 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
-----------------------------------------------------------
This Mail has been checked for Viruses
Attention: Encrypted Mails can NOT be checked !
***
Diese Mail wurde auf Viren ueberprueft
Hinweis: Verschluesselte Mails koennen NICHT geprueft werden!
------------------------------------------------------------
---------------------------------------------------------------------
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
