IS there a way to reset a lost mysql root password?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dustin Krysak [EMAIL PROTECTED] wrote on 11/25/2005
05:28:12 PM:
IS there a way to reset a lost mysql root password?
You obvously didn't research the issue very well. Next time search the
archives and the manual (it also has a search function):
Hi,
Here is a tutorial:
=
/*1. Kill the mysqld that may be running (not with -9):
kill `cat /var/lib/mysql/hostname.pid`
2. Restart MySQL in safe mode:
/usr/bin/safe_mysqld --skip-grant-tables
3. Connect to MySQL:
/usr/bin/mysql
4. Use the mysql database:
use mysql;
5. Run the
Thanks Brent, your solution is the one that worked for me. In 4.0.20
there was no 'Super_priv' column however. ?
On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley [EMAIL PROTECTED] wrote:
There probably is a root user, but it's not called root. You can name
the root user whatever you want.
Hi list,
First question - I have a machine that was being managed by Plesk, and
an update to mod_python left Plesk in a nonrunning state (actually
causes apache to segfault). So I am attempting to manually manage
MySQL (the way it should be done!) - but there is apparently no root
user in
There probably is a root user, but it's not called root. You can name
the root user whatever you want. You probably just don't have a user
named root, which is why you can change the password for user root.
You want to start MySQL with the skip grant tables options, just like
in the
Yes, thank you it helps !
Regards,
Jacek.
I'm not sure if you've gotton your answer or not yet... (i have 150 more
mailing list messages to go!)
Try http://www.mysql.com/doc/en/Resetting_permissions.html
On Monday 25 November 2002 06:05 pm, Jacek Mach wrote:
Hello,
I have made the
Jacek,
Tuesday, November 26, 2002, 2:05:40 AM, you wrote:
JM I have made the mistake and now have no root access to mySQL. Could you
JM help me, please, to reset the root password.
Please, look at the manual:
http://www.mysql.com/doc/en/Resetting_permissions.html
--
For technical
I'm not sure if you've gotton your answer or not yet... (i have 150 more
mailing list messages to go!)
Try http://www.mysql.com/doc/en/Resetting_permissions.html
On Monday 25 November 2002 06:05 pm, Jacek Mach wrote:
Hello,
I have made the mistake and now have no root access to mySQL.
Hello,
I have made the mistake and now have no root access to mySQL. Could you
help me, please, to reset the root password.
Regards,
Jacek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
We have a support contract with you. One of my clients has lost his root
password. How can we access his mysql?
Michael Johnson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1. Take down the mysqld server by sending a kill (not kill -9) to
the mysqld server. The pid is stored in a `.pid' file, which is normally
in the MySQL database directory:
shell kill `cat /mysql-data-directory/hostname.pid`
You must be either the Unix root user or the same user
We have a support contract with you. One of my clients has lost his root
password. How can we access his mysql?
Michael Johnson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1. Take down the mysqld server by sending a kill (not kill -9) to
the mysqld server. The pid is stored in a `.pid' file, which is normally
in the MySQL database directory:
shell kill `cat /mysql-data-directory/hostname.pid`
You must be either the Unix root user or the same user
http://www.mysql.com/doc/C/o/Command-line_options.html
See --skip-grant-tables
-Original Message-
From: michael johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 4:33 AM
To: Support at Mysql; mysql@lists. mysql. com
Subject: Lost root password
We have a support
johnson [EMAIL PROTECTED]
To: Support at Mysql [EMAIL PROTECTED]; mysql@lists. mysql. com
[EMAIL PROTECTED]
Sent: Monday, July 22, 2002 6:32 AM
Subject: Lost root password
We have a support contract with you. One of my clients has lost his root
password. How can we access his mysql?
Michael
michael,
Monday, July 22, 2002, 1:32:47 PM, you wrote:
mj We have a support contract with you. One of my clients has lost his root
mj password. How can we access his mysql?
You should take down mysqld, start the one with --skip-grant-tables option
and change password for user 'root'.
It also
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone,
I have searched the archives and read the manual but am at a loss as to
how to get my root password back (or change it)
The trick appears to be to start mysqld with --skip-grant-tables but I
can't seem to do it. Here is what I've done:
Hi Nick
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Cheers
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone,
I have searched the archives and read the manual but am at a loss as to
how to get my root
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Well, that's certainly progress of sorts :-)
It's just 'hanging' now. It says 'starting mysqld daemon with
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Well, that's certainly progress of sorts :-)
It's just 'hanging' now. It says 'starting
PM
To: [EMAIL PROTECTED]
Subject: Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Well, that's certainly progress of sorts
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gerald Clark declared
Well, that's certainly progress of sorts :-)
It's just 'hanging' now. It says 'starting mysqld daemon with databases
from /var/lib/mysql' and just hangs
It just wrote that message over the command
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gurhan Ozen declared
Are your databases in /var/lib/mysql ?IT is trying to startup with reading
databaseses from that path but i think it can't..
Also check the error log file to see what's going on.
Sounds reasonable, 2
and all of your other
accounts are unaffected.
Scott Helms
- Original Message -
From: Nick Wilson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 1:32 PM
Subject: Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier
It's OK Nick - it started. It's just writing that to the terminal
window. Hit enter to get the command prompt back (or ctrl-c if that
doesn't work).
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
It'll be something like:
Ah...
Do you have permissions over the mysql directories?
Can you start safe_mysqld as root? (purely for problem solving
purposes ;)
And of course - are your databases in /var/lib/mysql?
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gerald Clark
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
Do you have permissions over the mysql directories?
Certainly do.
Can you start safe_mysqld as root? (purely for problem solving
purposes ;)
Yep, well at least before it 'hangs'
And of course - are your
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql
* and then James Carrier declared
It's OK Nick - it started. It's just writing that to the terminal
window. Hit enter to get the command prompt back (or ctrl-c if that
doesn't work).
Ahhh,,, what a donkey (me not you) of course it
: Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gurhan Ozen declared
Are your databases in /var/lib/mysql ?IT is trying to startup with reading
databaseses from that path but i think it can't..
Also check the error log file to see what's going
Try
GRANT ALL PRIVILEGES ON *.* TO root@'%'
IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
Or you could always do a straight
INSERT INTO user VALUES('%','root',password('mypassword'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
james
---
Nick Wilson wrote:
Well, I'm in !! Now
Dear List,
I have lost the root password to my MySQL installation. What is the quickest way to
remedy this situation, uninstall and reinstall MySQL or what???. My installation runs
on a RaQ4 server.
Thanks for your help in advance
Regards
Temi
==
Tel: +44(0)702 112 0990 * Fax: +44(0)8707
At 03:39 29-8-01 -0700, temi odurinde wrote:
Dear List,
I have lost the root password to my MySQL installation. What is the
quickest way to remedy this situation, uninstall and reinstall MySQL or
what???. My installation runs on a RaQ4 server.
Take a look at the manual and this lists archive.
temi odurinde ([EMAIL PROTECTED]) writes:
Dear List,
I have lost the root password to my MySQL installation. What is the quickest way to
remedy this situation, uninstall and reinstall MySQL or what???. My installation
runs on a RaQ4 server.
The quickest way is to RTFM :) The searchable
!
Hope this helps,
Chris
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 9:51 AM
Subject: Re: Lost Root password
temi odurinde ([EMAIL PROTECTED]) writes:
Dear List,
I have lost the root password to my MySQL
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 9:51 AM
Subject: Re: Lost Root password
temi odurinde ([EMAIL PROTECTED]) writes:
Dear List,
I have lost the root password to my MySQL installation. What
36 matches
Mail list logo