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]