Access denied for user: 'root@localhost' (Using password: NO)

[34534534534555]

Hi folks.

I have JUST managed to set-up mySQL on my Mac. and put up a test.php on //localhost/ i was working fine.. played withthe tables talked back the correct results. But now, (after some fiddling by me, in the console typing various commands) it gives the following error: Access denied for user: 'root@localhost' (Using password: NO)

Why??

What i was trying to acheive when i messed things up was for the terminal (command prompt equiv.) to display a: "mysql>" prompt like in windows so i could begin making my db. How do i get to a similar prompt, as in windows mysql>??

TIA

Please let us know what you think of posts, feedback is always appreciated as this will help to further our knowledge as well.
---------------------------------------------------------------------------
All that's required for evil to suceed is for good men to do nothing.

 

[franklin97355]

I just now got the same error message. Now I can't get in to allow access. Anyone know what I need to do to regain control? I'll look in the FAQs but I saw this message on the top of the list so I thought I'd add my request.

 

[34534534534555]

ok. i have just changed my PHP to include a pasword when it tries to access the mySQL and now it works again!!!! whey!

I am still unsure how to bring up the mysql> command prompt on the mac in the terminal window as one would on windows in the 'DOS' window

Please let us know what you think of posts, feedback is always appreciated as this will help to further our knowledge as well.
---------------------------------------------------------------------------
All that's required for evil to suceed is for good men to do nothing.

 

[rzs0502]

You should be able to launch an X-Term Window and then go to your mysql directory.
If you're not sure you can type 'which mysql' to get the location.
It should be in /usr/bin
Normally, you would not have to change to the directory as /usr/bin is in your environment path.
So you can just type mysql -u xxx -p in the X-Term window.

 

[34534534534555]

Many Thanks i have figured it out now.

i needed to type:

/usr/local/bin/mysql




| Feedback is always appreciated as this will help to further our knowledge as well |