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

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
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 michaelwilso...@gmail.com 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?

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

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

Re: How to change root password?

2009-11-15 Thread Alexey Mykhailov
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com 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

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

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

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

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.htmlhttp://dev.mys ql.com/doc/mysql/en/Resetting_permissions.html When I get to the step: shell mysqladmin -u

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.

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 MySQL

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 without