Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
trouble connecting to mysql
Posted by: codewrecker (---.alt.east.verizon.net)
Date: February 14, 2008 02:14AM

I'm sure I've got the localhost, user, and password correct but I still cannot connect to the database. I'm not sure why. here's the error.

Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\testing.php on line 2
Access denied for user 'SYSTEM'@'localhost' (using password: NO)

any thoughts?

Options: Reply•Quote
Re: trouble connecting to mysql
Posted by: yfastud (Moderator)
Date: February 14, 2008 02:16AM

Check Setup Password guide on my personal website

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: trouble connecting to mysql
Posted by: codewrecker (---.alt.east.verizon.net)
Date: February 14, 2008 03:09AM

thanks that did help correct the root problem but I think there is another problem related to using wamp. I have a php page that I am trying to make a connection to the mysql server. the erro indicates "SYSTEM" as the user. I'm using a different user. I'm puzzled. here's a snippet of what I'm talking about:

user 'SYSTEM'@'localhost' (using password: NO)

notice "system at localhost. usually the db user is displayed when I've seen this error in the past. any insights?

Options: Reply•Quote
Re: trouble connecting to mysql
Posted by: yfastud (Moderator)
Date: February 14, 2008 03:16AM

Then check Setup Database guide on my personal websites, and while you're there, I suggest you should check other useful guides too ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: trouble connecting to mysql
Posted by: codewrecker (---.alt.east.verizon.net)
Date: February 15, 2008 03:21AM

I checked the guides for this specific problem but found nothing that helped. i can log into the phpmyadmin using both usernames and passwords i've set up. I've also tried giving the users specific access to the databases I need to access. When I create the php page and try to connect to the database none of the users can connect and I get the error that I've pasted above. "SYSTEM" is not a user that I"ve defined.

could it be a php or mysql configuration problem?

Options: Reply•Quote
Re: trouble connecting to mysql
Posted by: yfastud (Moderator)
Date: February 15, 2008 03:49AM

Quote

I've also tried giving the users specific access to the databases I need to access
If you actually follow my guide step by step, you don't need to do this step

Quote

Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\testing.php on line 2
Access denied for user 'SYSTEM'@'localhost' (using password: NO)
It doesn't mean to look for user SYSTEM but it means you provided the wrong username/password

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login