[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Very annoying Mysql security error.
- To: misc_(_at_)_openbsd_(_dot_)_org
- Subject: Re: Very annoying Mysql security error.
- From: Joonas Hämäläinen <joonas_(_dot_)_hamalainen_(_at_)_nettitieto_(_dot_)_fi>
- Date: Mon, 14 Feb 2005 10:38:40 +0200
error: mysql -u root
ERROR 1045: Access denied for user: 'root_(_at_)_localhost' (Using password:
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
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 :)
Ps. apologies of direct post, didn't double check to field. Monday
morning, that it is...
Visit your host, monkey.org