php - phpMyAdmin error: I am seeing errors in user accounts -

-

this first xampp installation. in phpmyadmin seeing following screen:

here screen shot

ave replication state 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" bin

x_threads=501 thread_count=2 possible 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. error can caused malfunc 127.0.0.1 db: error: column last_update in table "mysql"."innodb_table e '.\mysql\procs_priv.myi'; try repair 151101 21:18:0 md_resignal@@ube?aw4enum_sql_command@@xz() mysqld.exe!?ha_i

i googled , found link when going mysql website there seeing 5.7x version

update: installed xampp , can see localhost. xampp starts apache + mysql no errors when click ==>phpmyadmin ==> user accounts seeing aforementioned error.

today when restarted laptop , again gone phpmyadmin==> user accounts seeing sql error:

(select distinct `user`, `host` `mysql`.`user`) union (select distinct `user`, `host` `mysql`.`db`) union (select distinct `user`, `host` `mysql`.`tables_priv`) union (select distinct `user`, `host` `mysql`.`columns_priv`) union (select distinct `user`, `host` `mysql`.`procs_priv`) order `user` asc, `host` ascrr

error static analysis:

5 errors found during analysis.  unexpected closing bracket. (near ")" @ position 51) unexpected closing bracket. (near ")" @ position 108) unexpected closing bracket. (near ")" @ position 174) unexpected closing bracket. (near ")" @ position 241) unexpected closing bracket. (near ")" @ position 306) sql query: documentation  (select distinct `user`, `host` `mysql`.`user`) union (select distinct `user`, `host` `mysql`.`db`) union (select distinct

user, host mysql.tables_priv) union (select distinct user, host mysql.columns_priv) union (select distinct user, host mysql.procs_priv) order user asc, host asc limit 0, 25

mysql said: documentation  #126 - incorrect key file table '.\mysql\user.myi'; try repair

update-1: again restarted , seeing following:

warning in .\libraries\dbi\dbimysqli.class.php#261 mysqli_query(): (hy000/1030): got error 9 "bad file descriptor" storage engine myisam

backtrace

.\libraries\dbi\dbimysqli.class.php#261: mysqli_query( object, string 'select * mysql.db limit 1', integer 0, ) .\libraries\databaseinterface.class.php#246: pma_dbi_mysqli->realquery( string 'select * mysql.db limit 1', object, integer 0, ) .\libraries\check_user_privileges.lib.php#46: pma_databaseinterface->tryquery(string 'select * mysql.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

the actual problem found windows 8.1 not allowing programs change c:/programs.. folders.

i re-installed on d: drive creating folder d:/php/xampp , started working fine


Comments

Post a Comment

Popular posts from this blog

javascript - Slick Slider width recalculation -

-
i'm trying add slide in panel on slick container css. carousel works except new width not being calculated when space has been added. recalibrate once advance next slide i'd happen each time panel opened or closed. i've tried adding both margin , padding, neither makes difference. ideas? https://jsfiddle.net/mhigley/dpf7mlpl/ html: <button type="button" id="button"><i class="fa fa-arrow-right"></i></button> <aside> <h2>slide in panel</h2> <ol> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> </ol> </aside> <main role="main"> <div class="sections"> <section> <article> <h2>first slide</h2> <p>lorem ipsum d...
Read more

jsf - PrimeFaces Datatable - What is f:facet actually doing? -

-
looking through primefaces code in app noticed following line: <f:facet name="header">#{trainsearch.traincount} trains</f:facet> it looks overriding header, makes sense, can explain me in little more detail? what happening line of code? complete code listed below: <p:datatable id = "results" value = "#{trainsearch.trains}" var = "train" rendered="#{not empty trainsearch.trains}" styleclass = "train-search-table horizontal-border"> <f:facet name="header">#{trainsearch.traincount} trains</f:facet> <p:column headertext = "train id"> <p:panelgrid columns="1" styleclass = "train-id-grid" layout = "grid"> <h:outputtext styleclass = "train-id-label" value="#{train.traini}"/> <h:outputtex...
Read more

angular2 services - Angular 2 RC 4 Http post not firing -

-
i trying fire post request app , it's not working, tried multiple ways. don't see request being fired under network tab in chrome. not sure problem is, appreciated. import { injectable } '@angular/core'; import { http, headers } '@angular/http'; @injectable() export class userservice{ private _url="users"; constructor(private _http: http){ } checkifusernameexists(username){ return this._http.get(this._url+"/"+username) .map(response => response.json()) } createuser(user){ let headers = new headers(); headers.append('content-type', 'application/json') console.log(json.stringify(user)); return this._http.post(this._url, json.stringify(user),{headers: headers}) .map(response => response.json()) } } first need capture error , solve error: this._http.post(this._url, json.stringify(user),{headers: headers}) .subscribe( ...
Read more