MySQL error when using login script available on website

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
martens
Forum Newbie
Posts: 2
Joined: Thu Aug 29, 2002 5:17 am

MySQL error when using login script available on website

Post 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 :)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

What does the code look like? Do you have a user set up on the mysql database called mysql_user?

Mac
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
User avatar
Takuma
Forum Regular
Posts: 931
Joined: Sun Aug 04, 2002 10:24 am
Location: UK
Contact:

Post by Takuma »

Let us see the code... I hope it's no Liteshaw Login System...
User avatar
gotDNS
Forum Contributor
Posts: 217
Joined: Tue May 07, 2002 5:53 pm
Location: West Chester, PA

Post 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.)
martens
Forum Newbie
Posts: 2
Joined: Thu Aug 29, 2002 5:17 am

Sorry!!!

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply