Thanks much, permissions.  I did an rpm install of this package and it
appears some permissions were not or are not preserved by rpm.  Well, live
and learn.  I did the first step with chmod 0004 /var/lib/mysql, it's that
second one I'm not certain of.  the user mysql exists and I gave it a
password for security, ... ownership, I can mysql owner of /var/lib/mysql
then use chmod to get it write permission I think.On Fri, 6 Jun 2003,
gerald_clark wrote:

> /var/lib/mysql must be world searchable:
> /var/lib/mysql/ must be writeable by the user mysql.
> /var/lib/mysql.sock will be created when mysqld starts, and must be
> world writable.
>
> jude dashiell wrote:
>
> >Here's the output I get only as a user to mysql but not logging in as
> >root:
> >
> >Script started on Fri Jun  6 14:09:06 2003
> >[EMAIL PROTECTED]:~$ mysql -u das    dashielljt -p
> >Enter password:
> >ERROR 2002: Can't connect to local MySQL server through socket 
> >'/var/lib/mysql/mysql.sock' (13)
> >[EMAIL PROTECTED]:~$ exit
> >Script done on Fri Jun  6 14:09:52 2003
> >The user so far as mysql is concerned was created by root and exists with
> >a specific password before I tried rebooting the computer and running thie
> >command you see in this script.
> >I would like to be able to run mysql as a user and not only be restricted
> >to running it as root for security reasons.  Any help much appreciated.
> >
> >
> >
> >
>
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to