List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 28 2002 1:01am
Subject:Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting
starting
View as plain text  
At 20:31 +0100 1/27/02, Helmuth Lutz wrote:
>Am Sonntag den, 27. Januar 2002, um 19:15, schrieb Michael Collins:
>
>>At 6:43 PM +0100 1/27/02, Helmuth Lutz wrote:
>>>I can not connect to mysql neither do some tests:
>>>
>>>[hlutz:/usr/local/mysql] hlutz% mysqladmin version
>>>mysqladmin: connect to server at 'localhost' failed
>>>error: 'Access denied for user: 'hlutz@localhost' (Using password: NO)'
>>
>>
>>Did you establish a password for the root user?
>>
>>[hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -p version
>>
>>If you did not set a root password, just hit return. If you did, 
>>then enter that password.
>
>Thanks and the result:
>
>[hlutz:~] hlutz% cd /usr/local/mysql
>[hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -p version
>Enter password:
>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>[hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -p version
>Enter password:
>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>[hlutz:/usr/local/mysql] hlutz%
>
>As I remeber I set a password. But as you see either it is wrong or 
>does not work.
>
>Question back: Which password is ment?:

The one that you used when you set it, as you say you did three sentences
ago.  In your list below, this would be the MySQL root user.  Login account
passwords don't have anything to do with MySQL accounts.

>- OSX user
>- OSX root
>- MySQL root
>
>I tried all of them.

Looks like you don't remember the password that you used when you set it.
Kill the server (kill -9), bring it back up with -S (skip grant tables)
so that you can reset the root password:

UPDATE user SET Password=PASSWORD('new-password')
WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;

Then bring the server down and again and restart it normally.

>
>Do you have other ideas how to test?
>
>Thanks
>Helmuth
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread97612@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting startingHelmuth Lutz27 Jan
  • Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me gettingstartingMichael Collins27 Jan
    • Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting startingHelmuth Lutz27 Jan
      • Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me gettingstartingPaul DuBois28 Jan