Mailing List Archive: cant set password for root user in mysql install

You should look into the mySQL documentation for this kind of stuff.
There's a section that deals with setting initial passwords and other
authorization related issues.

If this really is a freshly installed mySQL just entering

mysql -u root

should let you open the mySQL interface since root initially has an
empty password by default. When you're in follow the instructions
mentioned in the mySQL docu.

Nick Smith schrieb:
> why cant i set the root pass for the root user on a fresh mysql install,
> mysql is running, here is what i get:
> fileserver root # /usr/bin/mysqladmin -u root password 12345678
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> following the directions on this
> http://www.gentoo.org/doc/en/virt-mail-howto.xml howto for setting up a
> mail server...
> any ideas?
>
> nick
>

--
Mit freundlichen Grüßen

Heinz Sporn

SPORN it-freelancing

Mobile: ++43 (0)699 / 127 827 07
Email: heinz.sporn@sporn-it.com
heinz.sporn@utanet.at
Snail: Steyrer Str. 20
A-4540 Bad Hall
Austria / Europe

--
gentoo-user@gentoo.org mailing list