SQL Problems

[Tyler Hall]

Trial and error, baby...


tyler@stimpy:/var/log$ mysql -p -h nerdie.org
Enter password:
ERROR 1130: Host 'stimpy.nerdie.org' is not allowed to connect to this
MySQL server

tyler@stimpy:/var/log$ mysql -p -h localhost
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111)

tyler@stimpy:/var/log$ mysql -p -h 127.0.0.1
Enter password:
ERROR 1045: Access denied for user: 'tyler@localhost' (Using password:
YES)

root@stimpy:/var/log# mysql -p -h 127.0.0.1
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3779 to server version: 3.23.47



On Fri, 22 Mar 2002, Tyler Hall wrote:

> I'm actually having the same problem.  MYSQL is running, but never creates
> that socket.   It has permissions, and it STILL doesnt, I don't know whats
> up.
>
>
>
> On Fri, 22 Mar 2002, A.P. Etc wrote:
>
> > >You haven't overlooked anything - it's just that mysql and php are a bit
> > >out of sync. You can fix that by editing your php.ini file and finding
> > >the line...
> > >
> > >mysql.default_socket    =
> > >
> > >and changing it to...
> > >
> > >mysql.default_socket    =       /var/lib/mysql/mysql.sock
> > >
> > >or wherever your mysql.sock is
> >
> > The mysql.sock file does not exist on the system. Is there a package or
> > install I missed?
> >
> > -A.P. Etc
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> > ________________________________________________
> > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
> >
> > PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
>
> ________________________________________________
> See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
>
> PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>