Ian Bicking wrote: > Angus Lee wrote: > > In dev.cfg, this works alright: > > sqlobject.dburi="mysql://username:[EMAIL PROTECTED]:3306/turbogears" > > but this causes problems: > > sqlobject.dburi="mysql://turbogears:[EMAIL PROTECTED]:3306/turbogears" > > > > Anybody knows why? > > localhost is 127.0.0.1, a different host than 162.105.57.154. You might > also be able to get away with an empty hostname, which may cause it to > connect over a local socket, like mysql://turbogears:turbogears@/turbogears
I should mention that with MySQL, localhost is NOT the same as 127.0.0.1. When you tell it the host is localhost, the client library uses an UNIX socket (or named pipe on Windows) and not TCP, and the port is ignored. If you use 127.0.0.1, then it uses TCP. For my local server setup, I have mysql://user:[EMAIL PROTECTED]/db i.e. no port number. If you are still having trouble, then you may need to do this in the command-line client: SHOW GRANTS FOR [EMAIL PROTECTED]; vs. SHOW GRANTS FOR USER@<some IP>;
