Common Issues

Mysql error on Windows 11

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

Repair Mysql Database

Solution 1

• quit XAMPP
• start XAMPP as administrator
• start only Apache
• navigate to http://localhost/RepairXAMPP.php (or http://localhost/Ianseo/RepairXAMPP.php)
• a page should appear that tries to repair permissions

Solution 2

If you still get stuck, users reported the following procedure to work

1. Close the Xampp application (preferably using task Manager)
2. Open C:\ianseo\mysql folder (or where your ianseo installation is)
3. Rename the data folder to data_old
4. Copy and paste the backup folder named backup_copy
5. Rename the backup_copy folder to data
6. Open data_old folder, copy all folders except mysql folder, performance_schema folder and phpmyadmin folder.
7. Go to the newly renamed data folder, paste the folders from step 6 inside.
8. Open the data_old folder, copy ibdata1
9. Paste it in the data folder
10. Start Xampp
11. navigate to http://localhost/phpmyadmin
12. click on the "SQL" tab in the top menu
13. provided you kept the original values upon installation, type the following 2 lines create user ianseo@localhost identified by 'ianseo'; grant all privileges on ianseo.* to ianseo@localhost;then press "execute"

NOTE: the original values are

• user: ianseo
• password: ianseo
• database: ianseo

Avoid Issues with XAMPP and Windows 11

Set as a Service

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.

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.

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.

Train Defender to protect XAMPP and related servers

To avoid interferences between Windows Defender and XAMPP follow these steps

Step 1: Open Windows Security and go in "Protection against virus and malware"

Step 1

Step 2: At the bottom of the page click on Manage Exclusion

Step 2

Step 3: Insert which elements to exclude from the scan paying attention to upper and lower case:

• Select folder to exclude:
  • C:\ianseo
• File Types to exclude:
  • .mysql
  • .php
• Processes to exclude (type exactly as written):
  • Apache HTTP Server
  • mysqld
  • xampp-control

Step 3