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, Joemysql@bluepolka.net wrote:
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled
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
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
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, Joemysql@bluepolka.net wrote:
We have an inaccessible MySQL v5.0.45 DB
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,
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
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
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
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
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
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
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
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 mysql tables from
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 :(
Is there any method
13 matches
Mail list logo
