TransWikia.com

I get these erros whenever I try to access User Accounts my phpmyadmin

Stack Overflow Asked by Celso Mauro on December 12, 2020

I transferred MySql folder from my old computer to a new xampp to keep the databases.
everything worked good but I cant access "User Accounts" so I can create new accounts and new databases

(SELECT DISTINCT User,Host
FROM mysql.user )
UNION
(
    SELECT DISTINCT User,Host
    FROM mysql.db
)
UNION
(
    SELECT DISTINCT User,Host
    FROM mysql.tables_priv
)
UNION
(
    SELECT DISTINCT User,Host
    FROM mysql.columns_priv
)
UNION
(
    SELECT DISTINCT User,Host
    FROM mysql.procs_priv
)
ORDER BY User ASC
    ,Host ASC

#126 – Incorrect key file for table ‘.mysqluser.MYI’; try to repair it Abrir nova janela do phpMyAdmin

Warning in .librariesclassesDbiDbiMysqli.php#199 mysqli::query():
(HY000/126): Incorrect key file for table ‘.mysqluser.MYI’; try to
repair it

Backtrace

.librariesclassesDbiDbiMysqli.php#199: mysqli->query( string
‘SELECT 1 FROM mysql.user LIMIT 1’, integer 0, )
.librariesclassesDatabaseInterface.php#316:
PhpMyAdminDbiDbiMysqli->realQuery( string ‘SELECT 1 FROM mysql.user
LIMIT 1’, , integer 1, )
.librariesclassesDatabaseInterface.php#2390:
PhpMyAdminDatabaseInterface->tryQuery( string ‘SELECT 1 FROM
mysql.user LIMIT 1’, integer 256, integer 1, )
.librariesclassesDatabaseInterface.php#2332:
PhpMyAdminDatabaseInterface->isUserType(string ‘super’)
.librariesserver_common.inc.php#43:
PhpMyAdminDatabaseInterface->isSuperuser() .index.php#116:
include(.librariesserver_common.inc.php)

help please.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP