https://wiki.ianseo.net/index.php?action=history&feed=atom&title=Common_Issues%2FenCommon Issues/en - Revision history2026-06-21T04:10:49ZRevision history for this page on the wikiMediaWiki 1.39.7https://wiki.ianseo.net/index.php?title=Common_Issues/en&diff=3827&oldid=prevFuzzyBot: Updating to match new version of source page2026-06-20T15:13:29Z<p>Updating to match new version of source page</p>
<p><b>New page</b></p><div>{{Proofreading}}<br />
<languages/><br />
<br />
== Mysql error on Windows 11 ==<br />
Windows defender sees XAMPP as a virus thus deletes or corrupts tables and files critical for i@nseo. If this happens here are 3 solutions that could fix this issue. Please also set up Windows Defender as in [[Install i@nseo]]<br />
<br />
=== Repair Mysql Database ===<br />
==== Solution 1 ====<br />
<br />
* quit XAMPP<br />
* start XAMPP as administrator<br />
* start only Apache<br />
* navigate to <nowiki>http://localhost/RepairXAMPP.php</nowiki> (or <nowiki>http://localhost/Ianseo/RepairXAMPP.php</nowiki>)<br />
* a page should appear that tries to repair permissions<br />
<br />
==== Solution 2 ====<br />
If you still get stuck, users reported the following procedure to work<br />
<br />
# Close the Xampp application (preferably using task Manager)<br />
# Open <code>C:\ianseo\mysql</code> folder (or where your ianseo installation is)<br />
# Rename the <code>data</code> folder to <code>data_old</code><br />
# Copy and paste the backup folder named <code>backup_copy</code><br />
# Rename the <code>backup_copy</code> folder to data<br />
# Open <code>data_old</code> folder, copy all folders except <code>mysql</code> folder, <code>performance_schema</code> folder and <code>phpmyadmin</code> folder.<br />
# Go to the newly renamed <code>data</code> folder, paste the folders from step 6 inside.<br />
# Open the <code>data_old</code> folder, copy <code>ibdata1</code><br />
# Paste it in the <code>data</code> folder<br />
# Start Xampp<br />
# navigate to <u><nowiki>http://localhost/phpmyadmin</nowiki></u><br />
# click on the "SQL" tab in the top menu<br />
# provided you kept the original values upon installation, type the following 2 lines '''<code>create user ianseo@localhost identified by 'ianseo';</code>''' '''<code>grant all privileges on ianseo.* to ianseo@localhost;</code>'''then press "execute"<br />
<br />
NOTE: the original values are<br />
<br />
* user: ianseo<br />
* password: ianseo<br />
* database: ianseo<br />
<br />
=== Avoid Issues with XAMPP and Windows 11===<br />
==== Set as a Service ====<br />
Users in internet reported that the issue seems to disappear if Apache and Mysql are run as services. To activate the services, you need to run XAMPP_control as administrator and flag the checkbox on the left of Apache and Mysql.<br />
<br />
If the checkboxes are disabled and xampp_control is running as administrator, you need to activate them: in the XAMPP folder search for xampp_control.ini file, edit it (click with right button and choose edit), find the block that says "[EnableServices]" and replace "0" with "1" in front of Apache and Mysql. Save, restart XAMPP as admin and the checkboxes should be enabled.<br />
<br />
Once the 2 checkboxes have a green flag all is set: start apache and mysql and from now on you can forget XAMPP: each time you switch on your computer the 2 programs will start automatically.<br />
<br />
==== Train Defender to protect XAMPP and related servers ====<br />
<br />
{{Install_Post_Installation}}</div>FuzzyBot