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
Burgi
4219 silver badges24 bronze badges
asked Mar 26, 2020 at 9:36
3
In my case above solution not worked. But the solution is similar to suggest by the @user13439511
Follow the below steps.
-
Select «mysql» database from the list of database.
-
Select all tables inside «mysql» database.
-
Scroll down and select «Repair Table» option in combobox.
-
Click on Go button.
Done.
answered May 17, 2020 at 8:56
Pankaj LahotiPankaj Lahoti
2,3821 gold badge6 silver badges8 bronze badges
6
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
answered Apr 30, 2020 at 8:52
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:
- Select the ‘mysql’ database
- Select all the tables as described in other fixes, but run a ‘check tables’ instead of a ‘repair tables’.
- 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.
- Select custom export, and check the ‘Add DROP TABLE / TRIGGER statement’ option, then export. Save the sql file.
- 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.
answered Mar 29, 2021 at 4:39
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.
answered Jun 28, 2020 at 17:48
1
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
answered Jan 13, 2021 at 20:53
If you can’t access to the structure of mysql database, just log out then try again to repaire tables of it.
answered Aug 26, 2021 at 8:37
Today, we will learn about #1030 – Got error 176 “Read the page with the wrong checksum” from storage engine Aria. when I add a user to a new database with Privileges Or when want to open a user account localhost/phpmyadmin and received this error: #1030 – Got error 176 “Read the page with the wrong checksum” from storage engine Aria. And this tutorial I will solve this error: #1030 – Got error 176 “Read the page with the wrong checksum” from storage engine Aria.
1030 – Got error 176 “Read the page with wrong checksum” from storage engine Aria
Step 1: Select “mysql” database
Select mysql database from the list of databases.
Step 2: Select all tables
Select all tables inside mysql database.
Step 3: Repair Table
Scroll down and select the Repair Table option in the dropdown menu.
Step 4: Solve
Finally, When you select Repair table option it will take action and show the below result.
Categories:
#mysql #laragon
Вопрос:
Есть только 2 команды, необходимые для миграции, но первая, похоже, не работает для меня.
mysqldump.exe —все базы данных > …путьalldb.sql
и вот в чем ошибка
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) when trying to connect
затем я попытался указать пользователя с помощью быстрого пароля.
mysqldump.exe -u root -p —все базы данных > …путьalldb.sql
но там написано
mysqldump: Got error: 1556: You can't use locks with log tables when using LOCK TABLES
Заранее спасибо за любое решение для этого.
Примечание: Только первый раз работаю с этими командами, так что я действительно понятия не имею. Я также попытался добавить опцию —skip-lock-tables, но все равно потерпел неудачу и просто с другой ошибкой.
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `columns_priv`': Got error 176 "Read page with wrong checksum" from storage engine Aria (1030)
Комментарии:
1. Вполне вероятно, что базы данных с таблицами, вызывающими у вас проблемы, являются внутренними базами данных mysql. Если у вас не так много собственных баз данных, вы можете попробовать сбросить их специально. Если это сработает, единственное, что вы, скорее всего, пропустите, — это учетные записи пользователей, которые вы также можете сбросить и восстановить.
2. Не могу найти никакого решения, поэтому я просто сбросил нужные мне базы данных, и это работает просто отлично. Спасибо!