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
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
Dear List,
I have solved my problem I think.
For some reasons 'alias mysql=/usr/local/mysql/bin/mysql' didnt work for me.
When I type '/usr/local/mysql/bin/mysql -u root' I can log in as a root
and change password.
Later I can log in: '/usr/local/mysql/bin/mysql -u root -p'
Thank you,
Olga
Olga Lyashevska wrote:
e7253:mysql olichka$ /usr/local/mysql/bin/mysql
Try:
$ /usr/local/mysql/bin/mysql -u root -p
It looks like you aren't logging into MySQL as root, so you don't have
permission to set the root password. (If you don't give -u, it uses
your OS X short user name a
Dear List,
I have installed a binary package mysql-5.0.51a-osx10.5-x86_64.dmg
I can start up/shutdown MySQL and connect to MySQL server, but I cant
change a root password as required.
---begin example---
e7253:~ olichka$ cd /usr/local/mysql
e7253:mysql olichka$ sudo ./bin/mysqld_safe
Pass
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
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
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
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 -
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
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.
-
If you need to, use the "kill -9
-9 is a definite kill and it will work
-Original Message-
From: JP Audette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:52 PM
To: [EMAIL PROTECTED]
Subject: having trouble killing mysqld to restart and change root
password
Howdy,
I'm trying to reset a forgotten password for a MySQL server, and I can't
kill mysqld via the method mentioned in the documentation (or by any method
for that matter). When I try using the command...
kill 'cat /var/lib/mysql/mysqld.pid'
...I get a message saying that there is no such p
Please forgive me. I have searched all over for help with this problem
to no avail. I have just installed from RPM mysql 3.23.22-6 on a RedHat
7.0 system. I keep getting the message mysqladmin: cannot connect to
server at 'localhost' failed
error; Can't connect to local MySql server through soc
19 matches
Mail list logo
