OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Access denied for user 'debian-sys-maint''localhost'

From: Ian Simpson (iansmyjobgroup.co.uk)
Date: Tue Jul 22 2008 - 03:48:17 CDT

Hi Jesse,

If you're specifying the password in plain text, you shouldn't put the
PASSWORD directive in there; you only use PASSWORD if you're using the
hashed password that MySQL will actually store.

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint''localhost' IDENTIFIED
BY 'LongPasswordHere' WITH GRANT OPTION

or

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint''localhost' IDENTIFIED
BY PASSWORD 'HexadecimalString' WITH GRANT OPTION

Also, you will need to execute FLUSH PRIVILEGES once you're done, since
MySQL normally only checks the privilege tables on start-up.

On Mon, 2008-07-21 at 20:35 -0400, Jesse wrote:
> OK. This is driving me Nutz 8-p
>
> Any time I try to restart mysql, I get the error, "Access denied for user
> 'debian-sys-maint''localhost'"
>
> My understanding is that the password for the debian-sys-maint user is found
> in /etc/mysql/debian.cnf So, I edit that, and note the password.
>
> I then execute the following in MySQL (with the correct password, of
> course):
> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint''localhost' IDENTIFIED BY
> PASSWORD 'LongPasswordHere' WITH GRANT OPTION
>
> To test it out, I try a mysql -u debian-sys-maint -p, type in the password
> and get the "Access denied" error again. What's going on? Why can't I get
> this to work?
>
> Jesse
>
>
--
Ian Simpson
System Administrator
MyJobGroup

This email may contain confidential information and is intended for the recipient(s) only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email. If you are not the intended recipient(s) disclosure, distribution, copying or printing of this email is strictly prohibited and you should destroy this mail. Information or opinions in this message shall not be treated as neither given nor endorsed by the company. Neither the company nor the sender accepts any responsibility for viruses or other destructive elements and it is your responsibility to scan any attachments.