Amit Desai wrote:
>
> Sir,
>
> I am having a database on Red Hat 6 server.
> I am trying to establish a copy of this database on the Red Hat 7
> server.
> I created a user called eyetex on linux 7.
> Then i logged in as "su" and went to the mysql prompt,
> Then i gave the following command
> grant all privileges on eyetex.* to eyetex@localhost identified by
> 'passwd' with grant option.
> I dumped all the data from the red hat 6 server and then transfered it
> on the Red hat 7 server.
> All the tables were created, but if i login as "eyetex" and then try to
> enter mysql then it gives me an error saying
> ERR:2002 Cant connect to mysql server through socket
> /var/lob/mysql/mysql.sock (111).
> Because of this none of the perl files are able to access the database.
>
> I tried the same steps on red hat 6 and it worked fine.
>
> Also i would like 2 know if there is any way to find out the error
> depending on the error number.
>
> Please retrieve asap.
>
> Regards
>
> Amit
>
Make sure all users have search privileges in the dirextory
/var/lib/mysql.
perror xxxx
will print the error message for error xxxx.
---------------------------------------------------------------------
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
