On Thursday, Jun 07, 2001, h3rb wrote:

> How do I set the root password for mysql?  I can't add any database's or 
> anything cause it tells me that root@localhost is denied access.  I switch to 
> the user mysql and try to change the password that way.  And mysql tell's me 
> that the user mysql doesn't have permission to change passwords for other 
> users.  Could anyone point me in the right direction?  I have gone to 
> mysql.com and tried their solution to change a forgotton password.  And that 
> doesn't work either.  I still can't connect to my database.  I have setup 
> mysql from scratch on other distro's.  But this one with MDK8 is just about 
> driving me nutz.

/usr/bin/mysqladmin -u root password 'whatever-password-you-want'

should do it...

-- 
[EMAIL PROTECTED], ICQ#: 25370820, OpenPGP key at www.keyserver.net
1024D/39F0BBF4     2024 B7CB 10BF 6BE7 2ECE  E0FD 1360 0181 39F0 BBF4

Current Linux uptime: 6 days 13 hours 1 minutes.

Reply via email to