mysql Index for table '.\mysql\user.MYI' is corrupt; try to repair it

Here is original source that worked for me

https://stackoverflow.com/questions/57128891/how-repair-corrupt-xampp-mysql-user-table

(1) Find 'my.ini' (eg. c:\xampp\mysql\bin\my.ini )
(2) Insert 'skip-grant-tables' in a new line following label '[mysqld]'. Remove this later.
(3) Now mySQL can be started from the XAMPP control panel.
(4) Start phpMyAdmin from browser and select table 'user' from database 'mysql'
(5) Should see: #1034 Index for table 'user' is corrupt; try to repair it.
(6) Select 'mysql' from left panel then check 'user' in right hand panel.
(7) From the 'With selected' dropdown run 'analyze' then 'repair table'.
(8) If 'Repair' fails no choice but to 'DROP TABLE user' ....
(9) Recreate 'user' table from the distribution backup by copying the following 3 files.

C:\xampp\mysql\backup\mysql\user.frm 
C:\xampp\mysql\backup\mysql\user.MYD
C:\xampp\mysql\backup\mysql\user.MYI

to

C:\xampp\mysql\data\mysql\

then restarting XAMPP and adding/removing/editing users as you wish.

One last point: There seems to be some sort of association between the 'user' and 'db' tables. You may need to repair the 'db' table as per step (7).

Laravel 4 php 7 Uncaught TypeError: Argument 1 passed to Illuminate\Exception\WhoopsDisplayer::display()

after upgrade php from 5 to 7, in laravel 4 there were problems with display of exceptions and errors.
Need to make such fixes in code laravel files:

Add this to Illuminate\Exception\Handle

inside method

public function handleException($exception)

{

if ( ! $exception instanceof Exception) { $exception = new ErrorException( $exception->getMessage(), $exception->getCode(), E_ERROR, $exception->getFile(), $exception->getLine() ); }

/////// original code here

}

mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

after fresh install of windows and install xampp I had problems with mysql

to fix connection I added row
skip-grant-tables
into [mysqld] section in my.ini file for mysql

it fixed connection issue, but were problems with privileges
something like:
Table 'user' is marked as crashed and should be repaired

so, to fix it. need to add this line
skip-grant-tables
into my.ini (and restart mysql)

then go to mysql (I used phpmyadmin) and execute commands:
USE mysql;
CHECK TABLE user;
REPAIR TABLE user;

it fixed privileges tables.
after this you can remove line
skip-grant-tables
from config file and reload mysql server.

source article:
https://forum.laragon.org/topic/801/host-localhost-is-not-allowed-to-connect-to-this-mariadb-server/6

Magento 2.3 does not work properly on localhost xampp on wondows

source from

https://magento.stackexchange.com/questions/251926/magento-2-3-its-not-working-properly-in-localhost
https://github.com/magento/magento2/issues/19480#issue-386162790

solution:

#/vendor/magento/framework/View/Element/Template/File/Validator.php:139

foreach ($directories as $directory) {
    // Add this line
    $realDirectory = $this->fileDriver->getRealPath($directory);

// this is fix

    $realPath = str_replace('\\', '/', $realPath);

    // and replace `$directory` with `$realDirectory`
    if (0 === strpos($realPath, $realDirectory)) {
        return true;
    }
}

///////////////
also try to redeploy content, like
php -f bin/magento setup:static-content:deploy