error: mysql -u root
ERROR 1045: Access denied for user: 'root_(_at_)_localhost' (Using password:
NO)
So, how the hell am I supposed to secure the database ?
What it looks like to me is that you didn't try to start your mysql
console proper way. If password is set for user, you should use -p flag
to show that. There is two possible ways to use it:
mysql -u root -p
This gives you dialog asking for password. It is good way, so your
password isn't shown at ps listing.
mysql -u root -pyourownpassword
This way it starts right away mysql console using password
yourownpassword. And no, it isn't typo, password comes right after -p
without space. If you try to insert space after -p, it asks password
from you, and after you have given it, tries to user database
yourownpassword.
I hope I didn't misunderstand your problem here, and I read that you had
fixed this problem already, but for future use this might be useful :)
And phpmyadmin is pop for setting up things, much clearer if you aren't
too familiar with mysql :)
-Joonas
Ps. apologies of direct post, didn't double check to field. Monday
morning, that it is...