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 upda
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):
http://dev.mysql.com/doc/refman/4.1/en/r
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]
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
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 doc
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 MySQL's
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
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.
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
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)
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 d
chael 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. On
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
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 m
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)
http://lis
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 mysql
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)
http://lists.m
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 I'
TECTED]
Subject: 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
-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 'ha
-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 yo
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
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
ack in with the root password 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 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 quest
-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 comma
2002 1:33 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'
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 s
-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 da
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
-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:
temi odurinde ([EMAIL PROTECTED]) writes:
> Chris + All,
> Thanks for your postings. God knows why but I still cannot login to MySQL, I could
>not kill and start MySQL in safe mode as suggested. (I come from a Windoz background.
>I am a total newbies Unix/command line stuff) but I found instruc
ssword query to update root password, and you are on your way!
>
>Hope this helps,
>Chris
>
>- Original Message -
>From: "Ed Carp" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Wednesday, August 29, 2001 9
, and you are on your way!
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 PROTE
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
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 archi
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 44
37 matches
Mail list logo
