bonododo wrote:
hello!
First of all excuse me for this dumb question.
I ve installed mysql and everything ran fine. then i installed
phpmyadmin and also everything ran fine. Then i put a password to
phpmyadmin and i can log on in myadmin, but all my php scripts don t
work! as soon as i want to connect i get a mysql 1045 error saying
cannot connect to database 'Using password: NO', but i ve changed my
php scripts to connect on the databas. what s wrong? what shall i
do???
plz help me!
bonododo
What version of MySQL are you running? Sounds like you are using the
same user to run both phpmyadmin and your scripts. From what you have
posted, it looks as if your scripts are not passing the password to
MySQL for authentication which is why you are receiving the 'Using
password: NO' part. It could also be that you updated the password for
the wrong user.
For example, you might have updated the profile for 'test@%' and
'test@localhost' is the user in your scripts. Did you also remember to
run the 'flush privileges' command after updating the password?
Regards,
Wendell Jones