6 messages in com.mysql.lists.mysqlRe: Please Help !!| From | Sent On | Attachments |
|---|---|---|
| Venugopal | 12 Sep 1999 01:36 | |
| Clinton Gormley | 12 Sep 1999 01:37 | |
| Benjamin Pflugmann | 12 Sep 1999 03:43 | |
| Venugopal | 12 Sep 1999 06:58 | |
| Sasha Pachev | 12 Sep 1999 21:14 | |
| sas...@freeservers.com | 13 Sep 1999 10:15 |
| Subject: | Re: Please Help !! |
|---|---|
| From: | Benjamin Pflugmann (phil...@spin.de) |
| Date: | 09/12/1999 03:43:37 AM |
| List: | com.mysql.lists.mysql |
Hi.
More easily you can switch off authorization checking by starting MySQL with
mysqld -Sg (you probably want to use /usr/bin/safe_mysqld -Sg)
This will allow *everyone* access to your MySQL instance, so be sure to stop and restart MySQL after you are done.
You can set the root password with
mysqladmin -uroot password 'your-new-password'
Bye,
Benjamin.
On Sun, Sep 12, 1999 at 09:37:44AM +0100, cli...@drtech.co.uk wrote:
With root access to your filesystem, you need to delete and recreate your grant tables (found in ???/var/??/mysql),then shut down mysql.
you may be lucky, if mysql.server exists and works, you may be able to call "mysql.server stop" and have the database shutdown gracefully.
otherwise, you will have to kill all of the processes and risk corruption of your tables - repair them afterwards.
Hope this helps
clint
-----Original Message----- From: Venugopal [mailto:v.v...@team.indiainfo.com] Sent: 12 September 1999 09:37 To: mys...@lists.mysql.com Subject: Please Help !!
Hi,
I have forgot the password for the root password set for the mysql database. Is there any way to crash the database and restart again? If so pls respond to me. I need it badly. Thanks if any one is able to help this. If you are busy also then just give me the hint where to go and all.