Common Issues/it

Errore MySQL su Windows 11

Windows Defender rileva XAMPP come un virus e, di conseguenza, elimina o danneggia tabelle e file fondamentali per i@nseo. Se ciò dovesse accadere, ecco 3 soluzioni che potrebbero risolvere il problema. Si prega inoltre di configurare Windows Defender come indicato in Installa i@nseo

Riparazione del Database MySQL

Soluzione 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

Per evitare interferenze tra Windows Defender e XAMPP, segui questi passaggi

Step 1: Apri "Sicurezza di Windows" e vai alla sezione "Protezione da virus e minacce" e clicca su "Gestisci impostazioni"

Step 1

Step 2: In fondo alla pagina clicca su "Aggiungi o rimuovi esclusioni"

Step 2

Step 3: Inserisci gli elementi da escludere dalla scansione, prestando attenzione alle maiuscole e alle minuscole:

• Selezione cartella da escludere:
  • C:\ianseo
• Tipi di file da escludere:
  • .mysql
  • .php
• Processi da escludere (digitare esattamente come indicato):
  • Apache HTTP Server
  • mysqld
  • xampp-control

Step 3