Gil, THREE elements need to be match what is stored inside MYSQL DB. 1) username 2) password 3) hostname
You need to enable MYSQL logging, restart the DB, & try to login from PHP. Then, take a look at what MYSQL shows in its logfile & post the results here! YMMV On 5/29/05, Peter <[EMAIL PROTECTED]> wrote: > Hi, > > here is a workaround that might help you. > > I guess you have a Network card. So instead of using 'localhost' as host > use your ip e.g '192.168.0.1;. That will force MySQl use TCP/IP instead > of socket. > > Just have in mind that: > > 1. In /etc/my.cnf You should comment "skip-networking" if presenet > > 2. Make sure your user is allowed to make connections from YOUR_IP > > 3. Make sure you do not have Iptables rule that may block your access. > > > Peter > > [EMAIL PROTECTED] wrote: > > Remember guys, I went through this on the phpmyadmin list before > > turning here. > > > > I was told to run the command 'mysqladmin variables' to find out where > > the the socket was; I did that successfully and it showed up at > > /var/mysql/mysql.sock. > > > > And viola, now with mysqld running, it does show up there, at /var/ > > mysql/mysql.sock. > > When I shutdown mysqld it is gone, from /var/mysql. > > > > (Btw, once in a recent post of mine, Philip referred to my leaving out > > the leading / at 'var', that was simply a typo and it was in the script > > post.) > > > > So, running 'mysql variables' is giving me the socket path and I'm > > still lost as to what's going why I cannot connect with a simple php > > script. > > > > Help?! I'll look for the mysql error log. > > > > Gil > > > > > > On May 29, 2005, at 3:59 PM, Philip George wrote: > > > >>> mysql.sock is created by mysqld when it starts, and destroyed when > >>> it stops. > >>> > >> > >> haha. you're absolutely right. that doesn't make any sense. i > >> wasn't thinking about the nature of socket files when i wrote that. > >> > >> now that i go back and read the post i was referring to, i think the > >> poster was actually talking about the privileges of the enclosing > >> folder, not the socket itself. my bad. > >> > >> but, regardless, i think it's a path problem anyway, as i mentioned > >> earlier. > >> > >> pardon the misfire. running on zero sleep. > >> > >> - philip > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
