ok sorry to repeat everything already said
- Original Message -
From: Adam Voigt
To: Sunfire
Cc: Gibbs, Liam - SXIA ; [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:00 PM
Subject: Re: [PHP] MySQL Madness
MySQL infact perfectly understands what localhost is
MySQL infact perfectly understands what localhost is, example:
GRANT ALL PRIVILEGES ON dbname.* TO bob@localhost IDENTIFIED BY 'password';
The above will work fine, and aslong as you connect in your PHP with the username
"bob", and host "localhost" with pass "password" you'll be fine.
hi..
i came across the same problem before and it was well lets say i probably
dont have any hair left (from pulling it out) hehe.. anyways you need to go
into the grant tables and look to see what is set up for users.. most likely
you dont have a root@localhost user because as far as i understand
If MySQL is configured on your system correctly, you need a password in
your script. I'm curious, though, why you're accessing it as root?
Usually I create a user account in mysql and grant only the priviledges
needed for that account. It may be a mute point, but if a bug were to
crop up and yo
If you're using root, then you must use the root password in mysql_connect().
- Original Message -
From: "Gibbs, Liam - SXIA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 8:45 AM
Subject: [PHP] MySQL Madness
First off, when executing this command:
$conn
put your password in the mysql_connect. mysql_connect("localhost", "root",
"yourpassword");
or create a new user in mysql that has no password and minimal permissions.
> -Original Message-
> From: Gibbs, Liam - SXIA [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 9:46 AM
>
6 matches
Mail list logo
