Sign in to follow this  
Bobroglaz

Sql Database error

2 posts in this topic

I'm installing a new database on our test server, I'm using XAMPP and MyPHPadmin.

When I click on Privileges and go to the UN: root and click on edit privileges and get the following error.

SELECT * FROM 'mysql','db' WHERE 'User' = 'root' AND 'Host' = '127.0.0.1' ORDER BY 'Db' ASC

#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it.

any help with this would be appreciated.

 

Share this post


Link to post
Share on other sites

your server may be running out of space in the /tmp directory, change it in your mysql config file or make sure the directory has space available.

Then run

REPAIR TABLE tbl_name USE_FRM

 

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.