JiQuan Lu wrote:
> I delete the old /var/lib/mysql/ run "mysql_install_db" again.
> then I can use mysql
>
> under the "root" directory. it works fine.
>
> if I login the normal username not "root" or "su",
> the command "mysql -u username -ppasswors" can not work.
>
> There is error information following:
>
> ERROR 2002: Can't connect to local MySQL server through
> socket'/var/lib/mysql/mysql.sock' (111)
>
> What is the reason ?
>
> Thank you for your time.
>
> Gina
>
> On Wed, 28 Jun 2000, Thimble Smith wrote:
>
> > On Wed, Jun 28, 2000 at 09:26:03AM -0400, JiQuan Lu wrote:
> > > I open the mysql database"mysql" there is "can not find file 'host.ISM'"
> > > in the error file.
> >
> > You need to run the mysql_install_db program first. If this does
> > not solve your problems, please report back to us with the exact
> > commands you try and the exact error messages. I mean, cut and
> > paste the text from another window into your e-mail message.
> >
> > Thanks,
> >
> > Tim
> > --
> > Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
> >
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/php/manual.php3" before
> posting. To request this thread, e-mail mysql-thread42002@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
Your non-root user can not open the mysql.sock.
Make sure '/var/lib/mysql' is mode 777.