Restart mysqld with --skip-grant-tables option and reset password and
flush privileges..
See: http://www.mysql.com/doc/en/Resetting_permissions.html
Hope this helps..
Gurhan
On Fri, 2002-09-06 at 10:37, Adam Cripps wrote:
> I'm locked out of mysql database - it seems that all my users can't acce
Try the manual.
It has a section on resetting the root password.
Basically you restart the server with --skip-grant-tables option
Check out chapter 20.11
Adam Cripps wrote:
>I'm locked out of mysql database - it seems that all my users can't access
>it, through lack of privileges, even root. T
At 08:06 PM 12/17/01 +, Kevin Donnelly wrote:
>On Monday 17 December 2001 15:04, David VanHorn wrote:
> > I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> > grep mysql)
> > Then I restart with safe_mysqld --skip-grant-tables
> > Trying to log in to mysql in any way
On Monday 17 December 2001 15:04, David VanHorn wrote:
> I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> grep mysql)
> Then I restart with safe_mysqld --skip-grant-tables
> Trying to log in to mysql in any way, including mysql -h localhost mysql
> or mysql root or my
At 09:20 AM 12/17/01 +, Carl Troein wrote:
>David VanHorn writes:
>
> > At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
> > >This should help:
> > >
> > >A.4.2 How to Reset a Forgotten Password
> > >http://www.mysql.com/doc/R/e/Resetting_permissions.html
> >
> > Works ok up through step 2.
>
David VanHorn writes:
> At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
> >This should help:
> >
> >A.4.2 How to Reset a Forgotten Password
> >http://www.mysql.com/doc/R/e/Resetting_permissions.html
>
> Works ok up through step 2.
> mysql -h localhost mysql gives me error 1045 again.
> Can't g
At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
>This should help:
>
>A.4.2 How to Reset a Forgotten Password
>http://www.mysql.com/doc/R/e/Resetting_permissions.html
Works ok up through step 2.
mysql -h localhost mysql gives me error 1045 again.
Can't get in with mysqladmin either.
--
Dave'
This should help:
A.4.2 How to Reset a Forgotten Password
http://www.mysql.com/doc/R/e/Resetting_permissions.html
Good luck.
Doug
On Sun, 16 Dec 2001 22:43:39 -0500, David VanHorn wrote:
>
>I'm root on a small server.
>My co-sysop has managed to lock us out of mysql.
>I can't get in with -u
On Fri, 2 Mar 2001, Gerald L. Clark wrote:
> The manual tells you how to reset a forgotten password.
> It also tells you not to mess with these tables, but to use.
> GRANT and REVOKE. We all have to explore everything,
> dont't we?
>
> Worst case, kill mysqld and reinstall privilege tables with
The manual tells you how to reset a forgotten password.
It also tells you not to mess with these tables, but to use.
GRANT and REVOKE. We all have to explore everything,
dont't we?
Worst case, kill mysqld and reinstall privilege tables with
mysql_install_db --user=mysql
Asaf Maruf Ali wrote:
>
Hi-
I think you are getting tripped up by the same thing as I was when I
tried to install MySQL. When you are prompted "Enter password:", you do
NOT type the new password. You simply hit enter.
--Quentin
> Subject:
>
> Locked out of mySQL.
> From:
>
> "AJ Hawks" <[EMAIL PROTECTED]>
> Date:
>
In the manual
First off, have you tried the following ...
6.15 Causes of Access denied Errors
If you encounter Access denied errors when you try to connect to the MySQL
server, the list below indicates some courses of action you can take to
correct the problem:
After installing MySQL
12 matches
Mail list logo
