Step # 1 : Stop mysql service
# /etc/init.d/mysql stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Step # 4: Setup new MySQL root user password
mysql> use mysql;
mysql> update user set pas
I actually get the feeling you are not connecting as root.
Try mysql -uroot -p test instead of just mysql test
Have a nice day,
- Martijn
On Wed, Aug 26, 2009 at 03:02, Joe wrote:
> OK, thanks, that got me in. But upon inspection, the user.host
> values do not look fouled up as I thought they w
When you are in without the flag , issue the following:
Select current_user();
It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'
It should work If you did not mess too much with grant tables.
Claudio
Il giorno 26 ago, 2009 4:36 m., "Todd Lyons"
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>> > to adjust/add remote user access, we accidentally did the
>> > following:
>> >
>> > use mysql;
>> > update user set hos
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled up as I thought they were (it appears
the bogus update may have aborted). But my access problem
remains
If I start with --skip-grant-tables, 'show databases' shows all
DBs. But without that flag, I only
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
> nee
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can't get into the DB to fix
The error message says to go to
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn
how to set the different recovery options for innodb.
On 9/21/06, Sayed Hadi Rastgou Haghi <[EMAIL PROTECTED]> wrote:
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/my
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/mysql/start
I get these lins in my error log
060921 13:00:14 mysqld started
060921 13:00:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ib
Elekes Attila wrote:
>
> Steve Ruby wrote:
>
> > Elekes Attila wrote:
> > >
> > > Hi!
> > >
> > > The mysql server (version 3.22.32-4) has hanged up, and the restarting
> > > causes a part of the
> > > *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> > > from these files
Steve Ruby wrote:
> Elekes Attila wrote:
> >
> > Hi!
> >
> > The mysql server (version 3.22.32-4) has hanged up, and the restarting
> > causes a part of the
> > *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> > from these files :(
> > Is there any method to recover the my
Elekes Attila wrote:
>
> Hi!
>
> The mysql server (version 3.22.32-4) has hanged up, and the restarting
> causes a part of the
> *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> from these files :(
> Is there any method to recover the mysql tables from the remaining
> *.M
Hi!
The mysql server (version 3.22.32-4) has hanged up, and the restarting
causes a part of the
*.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
from these files :(
Is there any method to recover the mysql tables from the remaining
*.MYD, *MYI and *.frm
files ? Thanks for AN
14 matches
Mail list logo
