error : Access denied for user ‘dbuser’@’localhost’

Archived from the Xataface Users forum.

marionjoe — Thu Jul 26, 2007 6:33 am

hi folks

installation went perfectly.

using the documentation, i began with “Creating Your First Application” on
http://framework.weblite.ca/documentation/tutorial/getting_started/first_application

in following instructions to create a database called “FacultyOfWidgetry”,
i could not create new database from phpMyAdmin as “NO PRIVILEGES” prevented me.
-you can see the screenshot here
http://www.parentsawake.com/FacultyOfWidgetry/screenshot.gif

so… i created a new database in mySql and of course there was a prefix automatically placed in front of my new database. so the database i created was called “parents_FacultyOfWidgetry”

might this be the reason that the error message is instead of the application?

error message below - you can see it on http://www.parentsawake.com/FacultyOfWidgetry/index.php

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘dbuser’@’localhost’ (using password: YES) in /home/parents/public_html/dataface/Dataface/Application.php on line 202
Error connecting to the database: Access denied for user ‘dbuser’@’localhost’ (using password: YES)

thankyou for your time
marion

---

vlad — Thu Jul 26, 2007 6:49 am

Are you sure you did not create a table called “parents_FacultyOfWidgetry” instead of a database called “parents_FacultyOfWidgetry” ?

---

marionjoe — Thu Jul 26, 2007 7:04 am

Are you sure you did not create a table called “parents_FacultyOfWidgetry” instead of a database called “parents_FacultyOfWidgetry” ?

vlad:

hi - found the solution!
see - my success here - http://www.parentsawake.com/FacultyOfWidgetry/index.php

-i was following the instructions too carefully.
the instruction miss out some vital info

---

marionjoe — Thu Jul 26, 2007 7:14 am

i was following the instructions too carefully. i deliberately did not do the usual thing of giving the database a user and password, because the instructions did not say to do so - i thought that’s unusual, but heck, i want to follow this to the letter so i will not fail”

• the instruction miss out some vital info

please add these instructions to your site …. or your version of course

when creating a database

database name “FacultyOfWidgetry”

username “dbuser”

password “secret”

host “localhost”

thankyou for your time
marion