Re: How to change root password?

2009-11-16 Thread Michael Wilson
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

Re: How to change root password?

2009-11-16 Thread John Daisley
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

Re: How to change root password?

2009-11-16 Thread Michael Wilson
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

Re: How to change root password?

2009-11-15 Thread Alexey Mykhailov
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

Re: How to change root password?

2009-11-15 Thread Pintér Tibor
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

How to change root password?

2009-11-15 Thread Michael Wilson
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 specific password. What s

Re: how to change root password

2006-02-28 Thread Sam Tran
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

how to change root password

2006-02-28 Thread Arnel Pastrana
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 password of root? or is is passible that my mysql is curr

Re: How to change root password - getting error

2004-12-25 Thread Gleb Paharenko
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

How to change root password - getting error

2004-12-23 Thread Don
Hi, I am trying to change my root password for mysql 4.1.7 running on Linux (as I forgot it) using the docs found at: HYPERLINK "http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html"http://dev.mys ql.com/doc/mysql/en/Resetting_permissions.html When I get to the step: shell> mysqladmin -

Re: how to change root password

2002-07-17 Thread Victoria Reznichenko
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

Re: how to change root password

2002-07-17 Thread denonymous
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

how to change root password

2002-07-17 Thread pornost4r
Hi 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. thanx M. -