Laragon 3.0.4 problem on mariadb
this happen and create a user and assigned a database
2017-05-29 17:27:19 12644 [ERROR] mysqld: Index for table '.\mysql\user' is corrupt; try to repair it 2017-05-29 17:27:19 12644 [ERROR] mysqld: Index for table 'user' is corrupt; try to repair it 2017-05-29 17:27:19 12644 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table '.\mysql\user' is corrupt; try to repair it 2017-05-29 17:27:19 0x20842017-05-29 17:27:19 0x14f82017-05-29 17:27:19 0x23b82017-05-29 17:27:19 0x2d902017-05-29 17:27:19 0x29c82017-05-29 17:27:19 0x1e5c InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6495 2017-05-29 17:27:19 0x24b8
any idea how to fix this?
@kaxias I had this same problem and found out i had mysql installed and it was causing the problem.. if you have mysql or mariadb installed uninstall or change the port on the external mysql or mariadb..
that is what worked for me;
hope this helps...cheers....gator
@kaxias Restarting pc and removed "mariadb-10.2.5-winx64" also fixed it.
still not work. I think will back to laragon 2.2.2
This post is deleted!
@kaxias : Did you install Laragon 3.0 over Laragon 2.0?
Laragon 3.0 has many changes in its core so you should upgrade it properly:
If you did, I find this article helpful. Hope it help:
Note: Laragon 3.0 can create Data Dir. Therefore, after hacking your current data, you can have a new clean one by rename data\mysql to another name.
This also works with Postgres and MongoDB.
I it is a clean installation of laragon 3.0.4, this problem happen if I restart MariaDB server.
2017-05-31 13:19:35 2148 [ERROR] mysqld: Index for table '.\mysql\user' is corrupt; try to repair it 2017-05-31 13:19:35 2148 [ERROR] mysqld: Index for table 'user' is corrupt; try to repair it 2017-05-31 13:19:35 2148 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table '.\mysql\user' is corrupt; try to repair it 2017-05-31 13:19:35 0x24142017-05-31 13:19:35 0x2244 2017-05-31 13:19:35 0x2b542017-05-31 13:19:35 0x26d4 2017-05-31 13:19:35 0xe10 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6495 InnoDB: Failing assertion: slot 2017-05-31 13:19:35 0x878InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery.
@kaxias Removed C:\laragon folder. Redownloaded/reinstalled laragon latest. Done, everything works just fine. Tried to restart mariaserver, everything still works fine. After that if you are doing import your old database and mariadb does fail then be sure "Do not import database named (mysql)"
it is clean installation of 3.0.4 this problem appear. but on laragon 2.2.2 with mariaDB 10.2.6 this problem not happen.
Strange. With Laragon 3.0, I applies graceful shutdown for MySQL and have done a lot of tests on many OSes.
i use windows 10 64bit version 1703 os build 15063.296
@kaxias Windows 10 64bit version 1703 os build 15063.332 here
I have the same problem with a fresh install of laragon.
Please see my log file attached, any idea?
@dukenst2006 : I can not see your log file. Did anyone try deleting data\mysql and click Start All again?
@leokhoa : I deleted the data/mysql and it work, Thanks, Great !!
yes i did that but same think.
I will make a new installer of Laragon which bundles with data dir by default (like Laragon 2). I think there is an issue with the
auto create data dirfeature which not work well for 100% users. @kaxias: Can you check with Postgres or MongoDB?
@leokhoa Creating user is successful but granting privileges are failing. Did get in his comp then checked on my computer.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY '123456'; (Oke)
GRANT ALL PRIVILEGES ON database.* TO 'myuser'@'localhost'; (Fail)
And To Fix it :
- Remove Laragon\data\mysql\mysql
- Copy mariadb-10.2.6-winx64.zip\data\mysql
i did try that but same. maybe it is my pc.
i give this up . problem appear if you create new user and restart MariaDB server after few seconds it is stop work.