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