Page 1 of 1

MySQL error when using login script available on website

Posted: Thu Aug 29, 2002 5:17 am
by martens
Hi,

Can someone help me sort this error out. I am new to php and mysql every piece of code I try and use on my intranet which is my testing area doesn't seem to work. Finally I use the login code available on the website and I get this error.

Access denied for user. 'mysql_username@localhost' (Using password: YES).

If anyone can tell me how to fix this error i would greatly appreciate it

Kind regards

Brad :)

Posted: Thu Aug 29, 2002 5:24 am
by twigletmac
What does the code look like? Do you have a user set up on the mysql database called mysql_user?

Mac

Posted: Thu Aug 29, 2002 6:16 am
by twigletmac
Oh, and please don't cross-post, just post your question once in the most appropriate forum. Additional posts with the same question in them will be deleted.

Mac

Posted: Thu Aug 29, 2002 9:41 am
by Takuma
Let us see the code... I hope it's no Liteshaw Login System...

Posted: Thu Aug 29, 2002 4:19 pm
by gotDNS
Yes, code needs to be viewed here....*blink..blink*

Also, I dont suggest having a password....make a 'dummy' MySQL account:

Code: Select all

grant select,insert,update,delete on *.DBName to dummy@localhost;
Then just access the DB without a username as the user 'dummy'...(also, add any ohter permissions you need there.)

Sorry!!!

Posted: Thu Aug 29, 2002 5:56 pm
by martens
Just wanted to say sorry for posting it mulitple forums this will not happen again.

To everyone out there that has helped me thankyou

Regards

Brad

Posted: Fri Aug 30, 2002 1:58 am
by twigletmac
gotDNS wrote:I dont suggest having a password
Why would you want an account which has the right to insert, update and delete things from the database to be completely insecure?

Mac