Okay, that worked, thank you!
-Mike
On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote:
> On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson
> wrote:
>
>> I don't know what the password is for the Unix mysql user...
>>
>> You mean sign in as mysql in the OS X Login Window?
>
> Just open a term
Make sure your mysql server is not accessible to anyone else, its a good
idea to disconnect all network connections because the server will be
totally insecure for a short period of time!
Start your MySQL server with the --SKIP-GRANT-TABLES option.
At a shell prompt type
mysql -uroot
None, of these suggestions worked...
Tried the following ways to reset the password:
(1) Shut down MySQL via System Preferences pane
(2) Placed the following in a text file:
UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';
FLUSH PRIVILEGES;
(3 Invoked the following command from t
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson
wrote:
> I am running MySQL 5 on OS X Snow Leopard...
>
> Have it set up (by installing the pref pane) to always be running as
soon
> as my MacBook starts.
>
> For some odd reason, I can't remember the password I issued for "root"
> user and wis
Michael Wilson írta:
I am running MySQL 5 on OS X Snow Leopard...
Have it set up (by installing the pref pane) to always be running as soon as my
MacBook starts.
For some odd reason, I can't remember the password I issued for "root" user and
wish to either change it back to blank or a new spe
On 2/26/06, Arnel Pastrana <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I was installing drupal on my webserver with mysql after i followed
> instructions on how to configure and setup drupal i cant't access the
> root password of my mysql. my password won't work all.
>
> Any idea how to change my
Hello.
>Worst case, do I just uninstall and reinstall mysql?
Don't panic :)
My opinion: this situation looks similar to the example described
at:
http://dev.mysql.com/doc/mysql/en/Connection_access.html
May be you have several entries at user table. Can you login using your old
passw
pornost4r,
Wednesday, July 17, 2002, 4:45:18 PM, you wrote:
p> i have a simple question. how can i change mysql root password? if i
p> change it using winmysqladmin.exe, and changing it in my.ini, nothing
p> happens. i can change passwords using phpmyadmin, but i would like to
p> change it withou
From: <[EMAIL PROTECTED]>
> i have a simple question. how can i change mysql root password? if i
> change it using winmysqladmin.exe, and changing it in my.ini, nothing
> happens. i can change passwords using phpmyadmin, but i would like to
> change it without it.
Do you have access to the MySQ
