Questions tagged [xampp]
The xampp tag has no usage guidance.
27
questions
-1
votes
2
answers
37
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 ...
- 101
0
votes
1
answer
45
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 ...
- 13
-1
votes
1
answer
620
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 ...
0
votes
1
answer
79
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 ...
Learner123
0
votes
0
answers
159
views
MySQL shutdown unexpectedly in xampp
Every time I start xampp I got MySQL shutdown unexpectedly error. I have uninstalled and installed xampp, I have done mysql/data to mysql/data_old solution but it's a temporary solution. My database ...
0
votes
0
answers
934
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'@'...
0
votes
1
answer
61
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
...
1
vote
1
answer
61
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
...
0
votes
3
answers
331
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 ...
- 1
2
votes
0
answers
31
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 &...
- 121
-1
votes
1
answer
464
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'
...
0
votes
1
answer
2k
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
...
0
votes
2
answers
646
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 ...
- 1
2
votes
1
answer
298
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, ...
- 21
1
vote
0
answers
104
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 ...
- 11
0
votes
0
answers
128
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
...
- 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 ...
- 23
0
votes
2
answers
206
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 ...
- 1
1
vote
1
answer
5k
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 ...
0
votes
0
answers
260
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: ...
michael johnson
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. ...
- 11
0
votes
0
answers
46
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 ...
- 1
0
votes
0
answers
3k
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. ...
terw ewr
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 [...
- 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]...
- 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 ...
- 177
0
votes
0
answers
27
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 ...
