Chakravarthy K Sannedhi wrote:
> --- Steve Suehring <[EMAIL PROTECTED]> wrote:
> >
> > hmm. Are you sure that MySQL is running? Conversely, does the file
> > /var/lib/mysql/mysql.sock exist?
> >
> > Steve
>
> The mysql server is running and the mysql.sock file exists. Also I am
> able to connect to the mysql database by any of the following ways.
>
> mysql -u myname -p mypassword
> mysql -u myname -p mypassword -h localhost
>
> But when I try to connect in the following way, it says 'ERROR 1130:
> Host 'the.host.name' is not allowed to connect to this MySQL server
>
Make sure the user that is running httpd (probably 'nobody') can access
/var/lib/mysql/mysql.sock.
You can also add an entry to the user or db table for someone to connect via
network sockets:
INSERT INTO db ( host, db, user, select_priv ) values ( 'the.host.name',
'database', 'myuser', 'y' );
--Bill
---------------------------------------------------------------------
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
