Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed mysql5 and mysql5-server with macports started service fine but when i did

mysqladmin5 -u root -p ping

i get

Enter password: mysqladmin5: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

after some rooting around the socket was missing so i did a shameless chmod on its location, restarted and the socket now appears but that doesn't fix my original problem

tried to reset the password (just incase it had been set by the magical password fairies or something) using this technique:

that did nothing thought I would have a look at the logs there was nothing in /opt/local/var/log/mysql5/ but it was empter did some more chmod 777ing and now .turd_mysql5-server is appearing but its empty

share|improve this question

closed as off topic by Michael Hampton, Khaled, Jay, mdpc, Stefan Lasiewski Feb 18 '13 at 5:59

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

I'm not sure what mysqladmin5 is, but I'm guessing it's the same syntax as mysql. If so, your problem is that you're using a space between the -u and the username and the -p and the password. That's why it says "Using password: NO". Try:
mysqladmin5 -uroot -pping

share|improve this answer
its mysqlamin5 cause i installed with macports which adds the version to the end so you can run multiple version, so yes its exactly the same – msaspence Nov 21 '10 at 9:50
well did my suggestion fix your issue? – James L Nov 21 '10 at 16:27

I believe only mysql passwords omit the space, as in -pyourpassword. The user name still requires the space.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.