-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
14 matches
Mail list logo