help needed

[new2learn]

This is the error when trying to use phphelpdesk
ERROR 1044: Access denied for user: @'localhost' to database 'phphelpdesk'

quite new to db's but willing to try..

 

[azzazzello]

what is the syntax that you are using to connect? what is the username and db that you want to connect with/to?

 

[new2learn]

[mikea@fedora /]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use phphelpdesk
ERROR 1044: Access denied for user: '@localhost' to database 'phphelpdesk'
mysql>

 

[azzazzello]

looks like phphelpdesk is not available for anonymous users. check permissions and log in as a user that has access to that database.

 

[new2learn]

ok..How do I do that..even with root I get the error, cause I have no previos experience in DB's and setting usernames and pwd's

tnx 4 da relply..africa is tough to learn..no gurus

 

[azzazzello]

how did you create the phphelpdesk databsae in the first place?

 

[new2learn]

with the script that came with the program I downloaded from the web...see below
[johnuser@somehost helpdesk]$mysql -u root -p < phphelpdesk.mysql
Enter password: (password is only required if you have a password set)