Mysql Error 1044

[Jclark312]

I'm not sure if this is where i am suppose to post this or not ( Newbie ), But when ever i try to type Create Database Eq; It gives me a Error 1044 Access Denied for user: '@localhost' to database eq;....
Must be doin somethin wrong or missing a file or somethin.. If anyone could help please respond...Thank you

[Jclark312]

Never mind, I figured it out =)

[Tigerstyle]

well how did u work it out, i tried all the things i might eventually come up with and... damn.. i tried to solve this shit myself cause you guys are all... hmm u dont do c+++ so f u but i failed, any help would be very appriciated, thanks in forehand!

[OMGIMAPIMP]

I used to think the people on the forums where ass holes. But the more I see people asking questions that were answered on these boards its starting to chap my ass P. If you ever have any thoughts bout people not answering your questions it could be cause its on the forums already so RTFF (forums).

[Tigerstyle]

that was the kind of reply i could expect, but the thing is i get error 1045 in mysql, and i try the GRANT ALL PRIVILEGES ON *.* for blabla... and i get the answer that im not allowed to grant... this makes med unavailable to start my server, i had one b4 for half a year ago but now it seems that everything is harder and my mysql is fucjking things up for me

[killspree]

Setting up the server now is the same as it was half a year ago.

[krich]

Tiger:

Just guessing at your setup...log in to mysql, thusly:

mysql -u root mysql

do your grant command, exit, then login with the ID you created for the database.

Regards,

krich

[Tigerstyle]

Thanks, that was indeed what i was looking for, i typed grant right but used the wrong prompt, im glad someone not judging could take the time...

[Jerrysn]

Thanks Krich for not being a smartass and giving an answer.

I quote from a guide..

"if the last step, the GRANT... command, gives you an access denied error, exit out of mysql.exe & open it again via the command prompt with mysql.exe --user=root eq & repeat the GRANT... command)"

This guide has two minus signs. Myself knowing didly-squat about SQL wonders what the difference between one and two minus signs in front of a parameter?


-Jerry

[krich]

Originally Posted by Jerrysn

Thanks Krich for not being a smartass and giving an answer.

I quote from a guide..

"if the last step, the GRANT... command, gives you an access denied error, exit out of mysql.exe & open it again via the command prompt with mysql.exe --user=root eq & repeat the GRANT... command)"

This guide has two minus signs. Myself knowing didly-squat about SQL wonders what the difference between one and two minus signs in front of a parameter?


-Jerry

Jerry,

Under Linux, and I assume a similar setup in Windows, the:

-u <userid>

and

--user=<userid>

are equivilant. Not sure if that holds true under Windows. Also not sure what the reason is for the double minus options, but that's just the way it is (duplicate/identical command line options).

Regards,

krich