94

Created a new database but can't create new user account due to this error. Does anyone know how to fix this? I can't find any solution to fix this.

1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria

error picture

Burgi
  • 421
  • 8
  • 24
neph
  • 943
  • 1
  • 6
  • 7
  • Possible duplicate of https://stackoverflow.com/questions/58765779/mysql-issue-when-creating-a-new-user – Mohit Mar 26 '20 at 10:01
  • 1
    You should tag this with the database server you're using, which I'm guessing could be MySQL or MariaDB from the error message. The tag you've used, phpmyadmin, is for an application that can help system administrators manage a MySQL or MariaDB instance, and isn't relevant here unless you're getting this error through phpMyAdmin itself (in which case you should indicate how exactly you're trying to create the user account). – Isaac Bennetch Mar 27 '20 at 20:56
  • Also read: [1030 – Got error 176 “Read the page with wrong checksum” from storage engine Aria](https://devnote.in/1030-got-error-176-read-the-page-with-wrong-checksum-from-storage-engine-aria/) – Fefar Ravi Aug 23 '22 at 04:43

6 Answers6

276

In my case above solution not worked. But the solution is similar to suggest by the @user13439511

Follow the below steps.

  1. Select "mysql" database from the list of database. enter image description here

  2. Select all tables inside "mysql" database. enter image description here

  3. Scroll down and select "Repair Table" option in combobox.

  4. Click on Go button.

Done.

Rifky Niyas
  • 1,737
  • 10
  • 25
Pankaj Lahoti
  • 2,792
  • 1
  • 7
  • 8
  • Had this same error while editing privileges when my app crashed saying it had no permissions to the database. I ended up having to run "Repair Table" twice, then was able to edit the user and re-add the privileges (which were all gone). Thanks! – Demonslay335 Jul 28 '20 at 17:52
  • Wish I didn't drop and recreate the db before finding this, tnx! – Rok Sprogar Oct 12 '20 at 10:37
  • Thanks! It works, but I'm also interested to know the cause of this problem – mwck46 Oct 31 '20 at 16:37
  • 2
    Using Xampp and from phpmyadmin trying to access useraccounts resulted in the error as titled. This solution worked to solve it. – RkdL Nov 27 '20 at 22:35
  • 3
    **Not for InnoDB**: The solution mentioned above will not work on InnoDB. REPAIR TABLE works for MyISAM, ARCHIVE, and CSV tables. Here's the reference > https://dev.mysql.com/doc/refman/8.0/en/repair-table.html – Dexter Sep 08 '21 at 06:59
  • it worked for me – Mohsin Khan Nov 15 '21 at 16:53
  • @Dexter I have InnoDB, and it worked for me... – 5px Aug 30 '23 at 09:12
16

I was attempting to add a user to a new database with 'Privileges' and received this error: "#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria"

Select mysql from the list of databases. From the Table list, tick the box beside 'db'. Scroll to the bottom of the page, in the selection box that says 'With selected' scroll down to and select 'Repair Table' then select 'Go'. Worked for me .:m

user13439511
  • 161
  • 3
5

Spent a long time trying to fix this, but the repair method wasn't working. MySQL repairs thinks it fixed all the tables, but it wasn't fixing the error (checking the tables showed they still had errors).

I did fix it by dropping and recreating the affected tables. Instructions as follows:

  1. Select the 'mysql' database
  2. Select all the tables as described in other fixes, but run a 'check tables' instead of a 'repair tables'.
  3. For tables that are broken, (mine was the mysql.db table), you need to select the table and export it. In phpmyadmin, view the table and click export.
  4. Select custom export, and check the 'Add DROP TABLE / TRIGGER statement' option, then export. Save the sql file.
  5. In the import tab, import the sql file you just created.

This drops the table and recreates it, which fixed the issues I was having.

I'm not sure why this worked, where as repairing the table didn't.

Snowblind
  • 51
  • 1
  • 1
  • Hi, I am not sure if anyone tries your solution before. But, I just tried and it solved my issue. Thanks for posting!! – KApril Feb 18 '22 at 15:15
1

In the PHPMyAdmin panel go to the MySQL database, select the DB table and from the bottom dropdown menu select the repair table option.Your error will be resolved.

Salman Tayyab
  • 21
  • 3
  • 3
    Welcome to Stack Overflow. While your contributions are welcome, please be sure to review the existing answers prior to adding a new one. In this case, there is already [an answer from last month](https://stackoverflow.com/a/61849288/3025856) with nine votes that provides the same guidance—along with more detailed explanation. – Jeremy Caney Jun 28 '20 at 23:35
0

In my phpMyAdmin version (5.0.4) the mysql db gets corrupted when stop and restart the MySQL server, I solved it by running the task as a service

Ismael rojas
  • 11
0

If you can't access to the structure of mysql database, just log out then try again to repaire tables of it.

Hesam Moosapour
  • 510
  • 5
  • 12