All Questions
166 questions
-1
votes
1
answer
51
views
Delete rows from a parent table without affecting the condition table
I have a main table and a secondary one. Through a query I connect the secondary with the primary on the left, to filter the results of the primary. PhpMyAdmin disables editing and deleting the ...
- 19
0
votes
0
answers
948
views
PHPMYADMIN Failed to read configuration file
I habe following Problem with PHPMYADMIN. I am using it for FiveM and the Web Interface is saying to me, that PHP has Failed to read configuration file. I already tried everythink, but it dont work... ...
- 1
-1
votes
3
answers
97
views
How do you query a main table with known duplicates that also have tags?
I have a main table called pics that has an ID number and the origin site from which it was pulled from. I also have another table called tags that has a list of all the tags that were also pulled ...
- 190
1
vote
0
answers
89
views
Laravel Migration: Second foreign key not created as secondary key in phpMyAdmin
Description:
I'm facing an issue with Laravel migrations when creating a pivot table. I have a migration that defines a pivot table with two foreign keys and a composite primary key. However, when I ...
0
votes
1
answer
125
views
how do i increment an id based on an enum value
I have a table for users that includes a default user_id column. Additionally, there is a donator_id column that is null by default, but I want it to auto-increment in case the user_type is set to &...
-1
votes
2
answers
212
views
Login to phpMyAdmin with encrypted password [closed]
I am using MariaDB 10.6.
I have a user "test" with a password, the password is MySQL encrypted, which is like '*E494B31EA7DDA68A012783C852F1AB397877B17A'
The only thing is I don't have the ...
- 734
0
votes
1
answer
38
views
Table exported with phpmyadmin can't be reimported
I have two servers, a dev and a prod kind of, with the same softwares installed on them. I want to export the db from prod to dev, so i used phpMyadmin, but when reimporting the sql on the dev server, ...
- 417
0
votes
1
answer
143
views
phpMyAdmin error "Connection for controluser as defined in your configuration failed."
I removed the root account in mysql in an attempt to harden the server. I have created another user (let's call it AdminAccount) and granted all privileges on % and localhost. Since then, I have ...
- 1,383
0
votes
0
answers
1k
views
XAMPP Error - InnoDB: Operating system error number 3 in a file operation
Generally server works fine without any issues. But recently after opening my XAMPP and got this on morning
2022-12-10 9:55:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
...
0
votes
3
answers
104
views
PHPMyAdmin Grab specific strings from table
So I have a table in my SQL and it saves ServerID from discord, now like 500 users verified and on the table it says like ServerID: 123 User: Test
Now I accidentally I have deleted the server on ...
- 1
0
votes
1
answer
422
views
How do I configure my PhpMyAdmin to connect to a MariaDB from another network?
I have a computer inside a LAN network at my workplace which hosts the MariaDB database from Xampp and which is accessed through PhpMyAdmin. It is accessible throughout the LAN at the workplace, ...
1
vote
0
answers
321
views
Create Trigger for audit table
Newbie here. i needed audit triggers for my db tables in phpmyadmin and a friend recommended a guide to follow but im stuck and need help. below is the code.
Sample table (accounts table):
CREATE ...
- 11
0
votes
0
answers
320
views
How do I properly overwrite entries in MySQL(MariaDB database) with exported file?
If that makes a difference, here are my server data:
SQL version: 10.3.35-MariaDB - MariaDB Server
Database tool: phpMyAdmin 4.9.7
I have a table called phpbb_posts. It's a huge table with 17 949 ...
2
votes
1
answer
120
views
Using replace on a string from select in MySQL with column data leads to same output for different rows
Here is a simplified version of what I'm trying to do, which shows the problem best. My database looks like this:
users table:
user_id
first_name
1
Bob
2
Dave
3
Steven
settings table:
name
value
...
- 33
0
votes
1
answer
340
views
Mysql (MariaDB) connect with https://www.phpmyadmin.co
I would like to manage my database with https://www.phpmyadmin.co. But it doesn't want to bind. After like 20 Seconds there comes an errror.
error picture
I can use it for my minecraft plugins with ...
user17984950