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
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
c if this helps:
1.. Cold Reboot the machine and hit the SPACE bar to stop loading when
this message appears:
Hit[ENTER] to boot immediately or any other key for cmd prompt. Booting
kernel in 9,8,7?
2.. Type: boot -s (machine now in single user mode.)
You will see the following message
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 contrac
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
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
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
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
, 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
25 matches
Mail list logo
