This is my first xampp installation. In phpMyAdmin I am seeing following screen:
ave replication state from table mysql.gtid_slave_pos: 1146:
@Z() mysqld.exe!?do_command@@YA_NPAVTHD@@@Z() mysqld.exe!?
TIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYS
see``,
Routine_name
,Routine_type
) VALUES("ma_test_host"
umm last_update in table "mysql"."innodb_table_stats" is BIN
x_threads=501 thread_count=2 It is possible that mysql co
exe!my_security_attr_free() mysql.exe!simple_key_cache_rea
abort. Query (0x106e2f50): FLUSH PRIVILEGES Connection ID
'ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CR
iv
(
host,
Db,
User,
Routine_name,
Routine_type`) VA
,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_c
RROR] Missing system table mysql.roles_mapping; please run m
b50 InnoDB: Error: Column last_update in table "mysql"."inno
localhost
or misconfigured. This error can also be caused by malfunc
127.0.0.1 DB: Error: Column last_update in table "mysql"."innodb_table e '.\mysql\procs_priv.MYI'; try to repair it 151101 21:18:0
md_resignal@@UBE?AW4enum_sql_command@@XZ() mysqld.exe!?ha_i
I googled and found this link but when am going to mysql website then there I am seeing 5.7x version
UPDATE:
I installed Xampp and I can see localhost. The Xampp starts apache + MySQL with no errors but when I click ==>phpMyAdmin ==> User Accounts then I was seeing aforementioned error.
Today when I restarted my laptop and again gone to phpMyAdmin==> user accounts then I am seeing SQL error:
(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` ASCrr
Error
Static analysis:5 errors were found during analysis.
Unexpected closing bracket. (near ")" at position 51)
Unexpected closing bracket. (near ")" at position 108)
Unexpected closing bracket. (near ")" at position 174)
Unexpected closing bracket. (near ")" at position 241)
Unexpected closing bracket. (near ")" at position 306)
SQL query: Documentation
(SELECT DISTINCT `User`, `Host` FROM `mysql`.`user`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`db`) UNION (SELECT DISTINCT
User
,Host
FROMmysql
.tables_priv
) UNION (SELECT DISTINCT
User
,Host
FROMmysql
.columns_priv
) UNION (SELECT DISTINCT
User
,Host
FROMmysql
.procs_priv
) ORDER BYUser
ASC,Host
ASC LIMIT 0, 25MySQL said: Documentation
#126 - Incorrect key file for table '.\mysql\user.MYI'; try to repair it
UPDATE-1:
I again restarted and seeing the following:
Warning in .\libraries\dbi\DBIMysqli.class.php#261 mysqli_query():
(HY000/1030): Got error 9 "Bad file descriptor" from storage
engine MyISAM
Backtrace
.\libraries\dbi\DBIMysqli.class.php#261: mysqli_query( object, string
'SELECT * FROMmysql
.db
LIMIT 1', integer 0, )
.\libraries\DatabaseInterface.class.php#246:
PMA_DBI_Mysqli->realQuery( string 'SELECT * FROMmysql
.db
LIMIT
1', object, integer 0, ) .\libraries\check_user_privileges.lib.php#46:
PMA_DatabaseInterface->tryQuery(string 'SELECT * FROMmysql
.db
LIMIT 1') .\libraries\check_user_privileges.lib.php#395:
PMA_checkRequiredPrivilgesForAdjust()
.\libraries\List_Database.class.php#17:
require_once(.\libraries\check_user_privileges.lib.php)
.\libraries\PMA.php#17:
require_once(.\libraries\List_Database.class.php)
.\libraries\common.inc.php#1089: include_once(.\libraries\PMA.php)
.\server_privileges.php#12: require_once(.\libraries\common.inc.php)
Please advise
Thanks in anticipation
0 comments:
Post a Comment