Common Issues - Revision history

Deligant at 08:26, 1 July 2025

2025-07-01T08:26:43Z

← Older revision		Revision as of 08:26, 1 July 2025
Line 1:		Line 1:
	{{Proofreading}}		{{Proofreading}}
			<languages/>
			<translate>

	== Mysql error on Windows 11 ==		== 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]]		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]]
Line 46:		Line 49:

	{{Install_Post_Installation}}		{{Install_Post_Installation}}
			</translate>

Deligant at 07:07, 1 July 2025

2025-07-01T07:07:58Z

← Older revision		Revision as of 07:07, 1 July 2025
Line 46:		Line 46:

	{{Install_Post_Installation}}		{{Install_Post_Installation}}

	{{Content}}

Deligant at 07:07, 1 July 2025

2025-07-01T07:07:14Z

← Older revision		Revision as of 07:07, 1 July 2025
Line 46:		Line 46:

	{{Install_Post_Installation}}		{{Install_Post_Installation}}

			{{Content}}

Deligant at 14:59, 21 March 2025

2025-03-21T14:59:34Z

← Older revision		Revision as of 14:59, 21 March 2025
Line 1:		Line 1:
			{{Proofreading}}
	== Mysql error on Windows 11 ==		== 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]]		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]]

Deligant: /* Mysql error on Windows 11 */

2025-03-05T02:56:57Z

Mysql error on Windows 11

← Older revision		Revision as of 02:56, 5 March 2025
Line 2:		Line 2:
	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]]		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]]

	=== ~~Solution~~ 1 ===		=== Repair Mysql Database ===
		⚫	==== Solution 1 ====

	* quit XAMPP		* quit XAMPP
Line 10:		Line 11:
	* a page should appear that tries to repair permissions		* a page should appear that tries to repair permissions

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

Line 33:		Line 34:
	* database: ianseo		* database: ianseo

			=== Avoid Issues with XAMPP and Windows 11===
⚫	=== Solution 3 ===
			==== 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.		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.

Line 39:		Line 41:

	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.		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 ====

			{{Install_Post_Installation}}

Deligant: Created page with "== 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 === Solution 1 === * quit XAMPP * start XAMPP as administrator * start only Apache * navigate to http://localhost/RepairXAMPP.php (or http://localhost/Ianseo/RepairXAMPP.php) * a p..."

2024-12-10T16:49:44Z

Created page with "== 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 === Solution 1 === * quit XAMPP * start XAMPP as administrator * start only Apache * navigate to <nowiki>http://localhost/RepairXAMPP.php</nowiki> (or <nowiki>http://localhost/Ianseo/RepairXAMPP.php</nowiki>) * a p..."

New page

== 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]]

=== Solution 1 ===

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

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

# Close the Xampp application (preferably using task Manager)
# Open <code>C:\ianseo\mysql</code> folder (or where your ianseo installation is)
# Rename the <code>data</code> folder to <code>data_old</code>
# Copy and paste the backup folder named <code>backup_copy</code>
# Rename the <code>backup_copy</code> folder to data
# Open <code>data_old</code> folder, copy all folders except <code>mysql</code> folder, <code>performance_schema</code> folder and <code>phpmyadmin</code> folder.
# Go to the newly renamed <code>data</code> folder, paste the folders from step 6 inside.
# Open the <code>data_old</code> folder, copy <code>ibdata1</code>
# Paste it in the <code>data</code> folder
# Start Xampp
# navigate to <u><nowiki>http://localhost/phpmyadmin</nowiki></u>
# click on the "SQL" tab in the top menu
# 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"

NOTE: the original values are

* user: ianseo
* password: ianseo
* database: ianseo

=== Solution 3 ===
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.