Re: Problem Connecting to MySQL from PHP3...Please Help...

Hi Hendrix! On Tue, 27 Jun 2000, Hendrix wrote: > +-----------+---------+ > | host | user | > +-----------+---------+ > | hendrix | tpenney | > | hendrix | root | > | localhost | root | > | localhost | tpenney | > +-----------+---------+ > > mysql_connect ("localhost","tpenney", "<password_here>"); > > But... I can't connect to the server with this command: > > mysql_connect ("hendrix","tpenney", "<password_here>"); > > > Obviously, the server is excepting connections from "localhost" but not > from "hendrix"... Although they represent the same machine, and I have > entries for them in the respective privilege tables.... I'm thinking > that there may be an entry in the "hosts" file that I am missing, but I > am unsure...!!! Is it true that if I am sitting at the server, I can > only connect to it by using the "localhost" connection name...???? Here > is a list of the error messages that I recieve: from what I see in your logs you are trying to access the MySQL as apache user, and obviously he has not rights, nor it is a user in the users table. Also, I don't understand what's with hendrix.BluesCafe, is that the database? If so, check the proper syntax and don't forget to grant right to the user accessing the tables. Maybe if you provide the code of submitform lines arround 3-8? -- teodor