[Resolved] MYSQL Problems

shifty18

Ok so im reading Foundation Dreamweaver MX (friendsofed) and i am up the section about MYSQL (Page 324).

Now when i type GRANT ALL ON book_db.* TO pault@localhost IDENTIFIED BY "sesame";

i get <Error 1044: Access denied for user: '@ to database 'book_db'>

What am i doing wrong MYSQLd is running and I had apache running to ilimunate that out of the problem. This is the 4th time this has happend

thanks in advance

Chris

weekender

try putting paul@localhost in quote marks

weekender

try putting paul@localhost in quote marks

shifty18

i typed it in with "pault@locahost"

and I still get

ERROR1044:Acess denied for user: '@' to database book_db

it seams not to like the @ bit

weekender

i always use single quotes within sql statements - it just makes it easier i find. try that?

shifty18

nope, but in the book that i am using "Foudation Dreamweaver MX" (Friends Of Ed) i am doing everything to the letter, even the use of Capitials where they have used them. and that goes fine. they use " on the password but know were else

is their another way i can do this same procedure?

weekender

i never use command line sql as it's just too messy. if you have a php server running, download phpmyadmin and use that!

sorry i can't be more help

shifty18

when you say PHP server do you mean Apache??

ok thanks, it did say you can use that but get familer with command line first, but ill just use PHPmyadmin

thanks

weekender

yeah apache is the web server - php runs on top of that, so you'd need to install both

shifty18

yeah i got PHP and Apache working fine, been doing scripts and stuff, just want to add a databse in to them now, alrite thanks for your help