It's been 7 days as promised and upon checking the laragon.log I have found out that by applying the suggested method by @leokhoa; I can conclude that this issue is now solved.
Posts made by borhanuddin
RE: MariaDB 10.3 mysql.user corrupted
Yes. I did notice that after a few restart of apache and mysql this issue will happen.
Upon checking the laragon.log I did find this:
2019-03-10 17:40:16: Graceful shutdown failed!!! Did you change the root's password? - trying to force it shutdown...
ERROR: C:\laragon\bin\mysql\mariadb-10.2.22-winx64\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Is this issue happen because I change the root password using HeidiSQL?
If this is the case, how can I properly change root password without causing issue with gracefully shutdown MariaDB?
MariaDB 10.3 mysql.user corrupted
I have been testing laragon using MariaDB v10.3 and v10.2 and I frequently having issues with mysqld unable to start and further investigation I found out that mysql.user always corrupt. The only solution I have is backup the three (3) files from C:\laragon\data\mariadb-10.3\mysql which is user.frm, user.MYD and user.MYI.
If I encounter mysql error not able to start I just replace this file.
Any answer/solution about how this file always corrupt and way to fix this?
I love laragon so much but until this problem is solved, I think I will switch back to XAMPP in my development.
I'm using Windows 10 x64 with following setup:
Laragon Full 4.0.12 190228