Skip to main content

Questions tagged [xampp]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
217 views

Table 'any table' doesn't exist in engine without moving anything

Today after I guess a month or so I rebooted my server and now I get Table 'ANY TABLE' doesn't exist in engine in every InnoDB table that I want to open in phpMyAdmin. My ISAM tables are fine and ...
user1772630's user avatar
0 votes
0 answers
12 views

XAMPP MySQL database problem

I am working on Microsoft Windows 11. Occasionally (seems random), when I open XAMPP it appears to open an old version of my MySQL database. When this happens, all new information I entered on a ...
Nugget's user avatar
  • 1
0 votes
0 answers
49 views

MySQL not starting in XAMPP - Port is not blocked

I already verified port 3306 and it's not blocked port issue. Also, checked Netstat and 3306 is not showing in the list Upon starting MySQL XAMPP shows below error I checked mysql_error.log, below ...
Tahir Yasin's user avatar
0 votes
0 answers
188 views

MySql not starting on Xampp : InnoDB plugin not initializing due to missing MLOG checkpoints

Unexpectedly MySql server not starting. I checked error logs and found two errors: Aria recovery failed and InnoDB plugin not initializing. Aria issue is solved but InnoDB not initializing. The error ...
user avatar
-1 votes
2 answers
63 views

Problem accessing MySQL in Xampp

I installed Xampp on my Ubuntu 22.04 box. In its my.cnf, I set [client] password =mypassword port =3306 socket =/opt/lampp/var/mysql/mysql.sock I saved this and restarted MySQL. When I try ...
Gergely's user avatar
  • 101
0 votes
1 answer
54 views

How to calculate quantity based on a boolean field and retrieve values from a JSON field in MySQL

I'm working with a table called price_options that has the following fields: id, slots, list_slots, and quantity. Issue Description My objective is to calculate the quantity for each price option ...
Khuzema's user avatar
  • 13
-1 votes
1 answer
875 views

XAMPP Control Panel mysql shutdown unexpectedly

When I try to start on mysql from xampp control panel it says: 20:52:08 [mysql] Status change detected: stopped 20:52:08 [mysql] Error: MySQL shutdown unexpectedly. 20:52:08 [mysql] This may ...
Akshat Kr. Pandey's user avatar
0 votes
1 answer
138 views

MySQL denied me access after changing my password

I am new to MySQL. Today is my first day using it through XAMPP. I have managed to change my password using the code mysqladmin -u root password Suddenly I was denied access from XAMPP and from the ...
user avatar
0 votes
0 answers
1k views

Error mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

I'm completely new to MySQL and phpmyadmin. I was trying to add a password to my database/phpmyadmin but then I got this error: mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'...
Rori Putu's user avatar
0 votes
1 answer
67 views

Insert rows in 3 tables in a single query, SQL SERVER 2008

I need to insert data into 3 tables in a single query Table SkillData UserIndex SkillPoint TotalSkill 1 5202 99 Table Emblems UserIndex CountEmblem Status 1 1265 1 Table Rewards UserIndex Level ...
Ichigo Kurosaki's user avatar
1 vote
1 answer
80 views

Delete records in different tables

I need to delete the records where UserIndex = 1 and ItemNumber = 5202 in all three tables, all in a single query. I am using SQL 2008 R2. Table UserInfo1 UserIndex Itemnumber ItemCount 1 5202 99 1 ...
Ichigo Kurosaki's user avatar
0 votes
3 answers
466 views

Why PHPmyAdmin works on Windows 10 and not Windows 11?

I'm running Windows 11 and tried to install XAMPP on this machine. It installed Apache correctly, but when going to mySQL this appears: I tried everything I found online to fix this problem in order ...
Johann's user avatar
  • 1
2 votes
0 answers
34 views

Why does INSERTing to a federatedx table fail silently?

For testing, I've set up a XAMPP portable 8.1.12 with 10.4.27-MariaDB and enabled the FederatedX engine using this trick. When I now set up a SERVER that is not existing and a federated table that is &...
Bowi's user avatar
  • 121
-1 votes
1 answer
685 views

database eror localhost

ask for a solution xampp linux error like this? Error : The user specified as a definer ('mariadb.sys'@'localhost') does not exist error : Corrupt Phase 4/7: Running 'mysql_fix_privilege_tables' ...
Daeng Juf's user avatar
1 vote
1 answer
3k views

How to fix MariaDB commands out of sync, missing expression near ON?

I have the following procedure DROP PROCEDURE IF EXISTS find_transactions_past_5_days; DELIMITER $$ CREATE PROCEDURE find_transactions_past_5_days (IN input_date DATE) BEGIN ...
paigelarry342's user avatar
0 votes
2 answers
1k views

MariaDB seems to be locking all the tables

I am running MariaDB locally on windows 10. XAMPP version 3.2.4 and MariaDB Version 10.4.7 I am moving MYISAM tables to INNODB and trying to prove that the locking issues we seem to be having will be ...
Harj's user avatar
  • 1
2 votes
1 answer
329 views

MariaDB table is broken after failed dump process

I need to dump MariaDB InnoDB-database consists of several tables. One table that causes problems has nearly 13 Million rows. A fresh install of XAMPP(V.3.2.2) dump process was successful, after that, ...
Albert's user avatar
  • 21
1 vote
0 answers
138 views

ERD related, can you make one to one relationship with a single attribute entity to another entity?

ERD Here So for my database project, I designed a meat supply chain optimization project for a large organization, for example such as walmart, where every part of the chain is owned by the ...
Kazi Newaz's user avatar
0 votes
0 answers
139 views

Generate report by cross join between two tables

I wanted to generate report between two tables by using CROSS JOIN. Below shows the details of table. Table 1: kod_jawatan jawatan_id jawatan_kod jawatan_nama Table 2: tpermohonan mohon_id ...
NAS BS's user avatar
  • 1
1 vote
1 answer
3k views

Column count of mysql.proc is wrong

Im attempting to deal with a corrupted database with little success, when I try to alter this table I am giving the error Column count of mysql.proc is wrong Looking up this error online gives me ...
Marc-9's user avatar
  • 23
0 votes
2 answers
256 views

I'm trying to create a database for a hotel company with multiple hotels. I'm stuck on how to reserve a room?

I'm using Xampp phpmyadmin for the first time... So I've got the basics of the database. Customers, hotels, rooms etc. The customer can chose a check-in and check-out date. An admin can class a date ...
Katie's user avatar
  • 1
1 vote
1 answer
6k views

mysqldump: Got error: 2002: "Can't connect to MySQL server on 'x' (code)" when trying to connect

I am trying to create a back up from a server by using XAMPP (via command prompt). Unfortunately the error is: mysqldump: Got error: 2002: "Can't connect to MySQL server on 'x' (10060)" when ...
I try so hard but I cry harder's user avatar
0 votes
0 answers
295 views

MySql Service is not running in Linux

I am trying to run xampp on linux through terminal, but mysql database is not running after running the command to start Xampp server I get following output Starting XAMPP for Linux 8.0.2-0... XAMPP: ...
user avatar
1 vote
1 answer
3k views

Missing Edit Privileges Option In PhpMyAdmin [closed]

The Action column of the PhpMyAdmin is not displaying the Edit Privileges. I did not get the solution for this problem. I even tried to upgrade and degrade the PhpMyAdmin version, but nothing worked. ...
Nivetha R's user avatar
0 votes
0 answers
48 views

Deleted MySQL “root” user in phpMyAdmin through XAMPP local host…how to restore? [duplicate]

I was working in phpMyAdmin (XAMPP localhost) to add a user for a new database I created for a local WordPress website, and came upon the list of users named "root". Since I did not remember ...
TWyPGn's user avatar
  • 1
0 votes
0 answers
4k views

#1932 - Table '' doesn't exist in engine after accidental delete

I forgot to export my main table before deleting and reinstalling xampp. I recovered it from the recycling bin, but I get #1932 - Table '' doesn't exist in engine when I try to open any of the tables. ...
user avatar
0 votes
0 answers
1k views

Cannot restart myqsl even after changing port in xampp

I tried to start mysql in xampp but it stops unexpectedly. Below is the extract of the most common lines of error being recorded in error logs: InnoDB: using atomic writes. 2020-01-03 12:49:14 0 [...
wan's user avatar
  • 1
1 vote
1 answer
1k views

XAMPP - Error: MySQL shutdown unexpectedly

Last night MySQL Service on my XAMPP local server was running fine. Today... it starts for 10 seconds and then give me following error: 10:14:28 AM [main] Initializing Modules 10:14:28 AM [main]...
Mohal's user avatar
  • 111
0 votes
1 answer
1k views

MariaDB 'You do not have privileges to manipulate with the users!' [duplicate]

Apache/2.4.41 PHP 7.3.9 Windows 10 64bit I have been using XAMPP without issue for months now, and this morning when I turned on my PC adn tried to accedd my databases via HeidiSQL I received some ...
TheOrdinaryGeek's user avatar
0 votes
0 answers
29 views

Migrate 2 mysql folders on same server

I have installed wamp initailly. But now we have moved to xamp. So, I have 2 mysql folders, C:\xampp\mysql C:\wamp\bin\mysql\mysql\data Now my localhost is pointing to C:\xampp\mysql. I just wanna ...
Imran Qadir Baksh - Baloch's user avatar