apache - Error in MySQL Xampp -


i have installed mysql workbench on computer using port 3306.

i installed xampp apache server. when start services error appears:

problem detected! port 3306 in use ""c:\program files\mysql\mysql server 5.6\bin\mysqld" --defaults- ile="c:\programdata\mysql\mysql server 5.6\my.ini" mysql56"! mysql not start without configured ports free! need uninstall/disable/reconfigure blocking application or reconfigure mysql , control panel listen on different port

i changed mysql port xampp in following way:

stop xampp server, if running. edit value "port" in xampp/mysql/bin/my.ini code:

password = your_password    port =  3306  --->  3307   socket =  "/ xampp / mysql / mysql.sock"

and here also

code:

the mysql server  [ mysqld ]  port =  3306  --->  3307  socket =  "/ xampp / mysql / mysql.sock"

and started mysql service error remains.

does can me solve please?

thank all

best regards

----------------------------mysql_error.log---------------------------

140818 12:09:30 [note] plugin 'federated' disabled. 140818 12:09:30 innodb: innodb memory heap disabled 140818 12:09:30 innodb: mutexes , rw_locks use windows interlocked functions 140818 12:09:30 innodb: compressed tables use zlib 1.2.3 140818 12:09:30 innodb: initializing buffer pool, size = 16.0m 140818 12:09:30 innodb: completed initialization of buffer pool innodb: error: space header page consists of 0 bytes in data file c:\xampp\mysql\data\ibdata1 140818 12:09:30 innodb: not open or create data files. 140818 12:09:30 innodb: if tried add new data files, , failed here, 140818 12:09:30 innodb: should edit innodb_data_file_path in my.cnf 140818 12:09:30 innodb: was, , remove new ibdata files innodb created 140818 12:09:30 innodb: in failed attempt. innodb wrote files full of 140818 12:09:30 innodb: zeros, did not yet use them in way. careful: not 140818 12:09:30 innodb: remove old data files contain precious data! 140818 12:09:30 [error] plugin 'innodb' init function returned error. 140818 12:09:30 [error] plugin 'innodb' registration storage engine failed. 140818 12:09:30 [error] unknown/unsupported storage engine: innodb 140818 12:09:30 [error] aborting  140818 12:09:30 [note] c:\xampp\mysql\bin\mysqld.exe: shutdown complete  140818 12:21:45 [note] plugin 'federated' disabled. 140818 12:21:45 innodb: innodb memory heap disabled 140818 12:21:45 innodb: mutexes , rw_locks use windows interlocked functions 140818 12:21:45 innodb: compressed tables use zlib 1.2.3 140818 12:21:45 innodb: initializing buffer pool, size = 16.0m 140818 12:21:45 innodb: completed initialization of buffer pool innodb: error: space header page consists of 0 bytes in data file c:\xampp\mysql\data\ibdata1 140818 12:21:45 innodb: not open or create data files. 140818 12:21:45 innodb: if tried add new data files, , failed here, 140818 12:21:45 innodb: should edit innodb_data_file_path in my.cnf 140818 12:21:45 innodb: was, , remove new ibdata files innodb created 140818 12:21:45 innodb: in failed attempt. innodb wrote files full of 140818 12:21:45 innodb: zeros, did not yet use them in way. careful: not 140818 12:21:45 innodb: remove old data files contain precious data! 140818 12:21:45 [error] plugin 'innodb' init function returned error. 140818 12:21:45 [error] plugin 'innodb' registration storage engine failed. 140818 12:21:45 [error] unknown/unsupported storage engine: innodb 140818 12:21:45 [error] aborting

this sounds lot got 2 mysql servers running @ same time. suggest check process list process called mysqld.exe. (you can check "netstat" provided control panel) should running instance of mysql server. end 1 , try again.

in case i'd consider installing mysql server windows-service. allows "externally" manage server , make sure have 1 instance running.

you can accomplish clicking red x beside modulename , wait turn green checkmark.

control panel apache , mysql installed service

after control panel should looks ▲▲
installed both mysql , apache service, that's preference ;)

you can configure mysql workbench access running server instead of starting own.

you shouldn't required change port of mysql in case.

in addition that, apache module should able launch without mysql started...


Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv&quo
Read more

javascript - Highcharts multi-color line -

Image
i looking create highchart multi-colored line. if goes down under value, become red, , when comes on value, become green . here picture example: or maybe highcharts have other charts models differentiate high or low level color? you can achieve coloring using lineargradient coloring: color: { lineargradient: { x1: 0, x2: 0, y1: 0, y2: 1 }, stops: [ [0, 'red'], [0.25, 'yellow'], [0.50, 'green'], [0.75, 'yellow'], [1, 'red'] ] } here 0 in stops relates minimum value of series , 1 maximum value, , in between percentages between values. if find percentages according values prior creating chart use correct stops values make relate specific values in data (at least approximately). see this jsfiddle example .
Read more

javascript - Enter key does not work in search box -

tried search guys sorry. input in search box doesnt work (or search) when hit enter when user clicks search button. doing wrong? here code. thanks. <script type="text/javascript"> $(document).ready(function() { $("#submit").click(function() { var url = "http://asla.org/awardssearch.html"; url += "?s=" + $('#googlecse').val(); window.location = url; }); $('#googlecse').keydown(function(event) { if (event.keycode == '13') { $("#submit").click(); } else { //do nothing :) } }); }); </script> <form class="navbar-form navbar-right" role="search"> <div class="search"> <input id="googlecse" type="text" onblur="if(this.value=='')this.value=this.defaultvalue;" onfocus="if(this.value==this.defaultvalue)t
Read more