Skip to main content
16,102 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-1 votes
0 answers
25 views

I have a table in phpMyAdmin with some existing data: CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50), email VARCHAR(100) ); Currently, the email column ...
Massimo Cubello's user avatar
  • 1
Best practices
0 votes
4 replies
94 views

Table Schema: https://i.sstatic.net/82SwsonT.png A table contains ID foreign keys. If I hover over one, it shows me the Value. Another table contains the ID from the previous table. How can I show the ...
Marco ROKER's user avatar
  • 1
0 votes
2 answers
28 views

Before phpMyAdmin v5.2.1 there was a very nice feature that would group tables together that had double underscores and you could click the table group to access just those tables in the list view. ...
Andy Borgmann's user avatar
  • 73
1 vote
0 answers
179 views

I'm currently running phpMyAdmin and OAuth2-Proxy in my kubernetes cluster. OIDC authentication is working just fine, I've verified that PMA_USERNAME is being set properly, and I'm being authenticated ...
brett's user avatar
  • 189
0 votes
0 answers
28 views

When I first start XAMPP, everything works fine — I can add and see internal relations in phpMyAdmin. However, after stopping and restarting the MySQL server, all the relations disappear, and the ...
lilith43's user avatar
  • 1
-4 votes
1 answer
116 views

This is the error line of my http://localhost/phpmyadmin/ Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\phpMyAdmin\libraries\classes\ErrorHandler.php on line 192 Anyone got a ...
Batrisyia Hannani's user avatar
  • 1
0 votes
0 answers
46 views

I'm new to web development. I created and hosted a basic WordPress site on GoDaddy to showcase my product catalog. I went into phpMyAdmin to download my data so I could set up a local version of the ...
jackjx's user avatar
  • 1
-1 votes
1 answer
34 views

I'm having a problem inserting JSON into JSON columns. I'm trying to insert the basic "{}", but it gives a fatal error. Theoretically, I can insert JSON into a text data type, but this is a ...
Chief's user avatar
  • 1
1 vote
0 answers
50 views

I have a table in a MySQL database in which I have 19 VARCHAR variables (with a size ranging from 500 to 1500). After a while, I can no longer add new VARCHAR fields with a size of 1000 because I get ...
Andy McRae's user avatar
  • 752
0 votes
0 answers
61 views

[SCREENSHOT] I am getting this while opening my http://server-ip-address/phpmyadmin login page No login options (Username/Password) there! I need a little help. On Ec2 AWS Ubuntu instance, I installed ...
shubham's user avatar
  • 1
0 votes
0 answers
51 views

I've been building a site in WordPress currently based on my local hard drives using localhost. But I started receiving an "Error establishing a database connection" message. The issue has ...
MavWeb's user avatar
  • 21
0 votes
0 answers
42 views

I am creating two tables called customer and item. For the customer table customerID is the primary key and for the item table itemID is the primary key. And I am creating another table which is ...
Charith Wirul's user avatar
  • 1
0 votes
0 answers
33 views

My php version is 8.4.3, it does list mbstring as installed. I also installed all the other dependencies including all recommendations I could find on the internet Apache2 error log: [Tue Feb 11 11:...
user29295208's user avatar
  • 1
0 votes
0 answers
55 views

When I export my SQL database via the Export tab in phpMyAdmin I do a Custom export and use all the defaults with two additions: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER ...
Ben T's user avatar
  • 23
0 votes
0 answers
49 views

I'm importing spanish and other language words CSV file within phpMyAdmin. However it is showing error that is: Invalid column count in CSV input on line 2. Note: I've already setup and used utf8 ...
moazam's user avatar
  • 3
1 vote
1 answer
143 views

I have several sites developed with an old version of laravel that requires PHP 7.0 But the version of phpmyadmin requires 7.4 min. I have in Apache the following error in APACHE: [Mon Jan 13 19:00:58....
Gastón Zampar's user avatar
  • 11
0 votes
0 answers
35 views

I just noticed something weird working with mysql UPDATE statement and the WITH clause. Here's the query: WITH temp_table AS ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(...
Chimdi's user avatar
  • 379
0 votes
1 answer
181 views

This is a question I am going to answer myself, because even in the world of AI it took me far too long to get this running. The scenario is that I have a fully qualified domain a VPS service ...
T9b's user avatar
  • 3,582
0 votes
0 answers
111 views

Error: TypeError: PhpMyAdmin\Export::getFilenameAndMimetype(): Argument #5 ($filenameTemplate) must be of type string, null given, called in C:\xampp\phpMyAdmin\libraries\classes\Controllers\Export\...
Sants Chats's user avatar
  • 1
-3 votes
1 answer
102 views

For context, I'm making a programming (using C#) that acts similar to a website. Where in this website, it will show any vendor that sells a product or service within the dormitory area in university. ...
UnknownWanderer1995's user avatar
  • 1
0 votes
0 answers
58 views

I have wampserver3.3.7, PhpMyadmin5.2.1, PHP8.2.2 and MySql9.1. When I open PhpMyadmin into my Firefox browser and run a php script that will update and replace a large 500MB mysql table, this update ...
PaulDurand's user avatar
  • 1
0 votes
0 answers
66 views

I am having an issue with phpmyadmin (v5.2.1 & but have tried v5.2.2-dev) running via wamp on my local machine. Here's the problem: On most tables, when l attempt to click browse l get this error: ...
jspicher's user avatar
  • 113
-6 votes
1 answer
110 views

I’ve been using phpMyAdmin locally for developing my project, and I’m now working with cPanel for hosting. I noticed that cPanel provides two tools for managing MySQL databases: phpMyAdmin – This is a ...
Twana Khudhur's user avatar
  • 27
0 votes
2 answers
98 views

I have a .sql file with CREATE TABLE AND INSERTS TABLE sentences in it. Example: INSERT INTO `examle` (`myid`, `title`, `value`, `usefull`, `picture`, `short_description`, `description`, `wikipedia`, `...
curt's user avatar
  • 91
0 votes
1 answer
1k views

Hello I am running a wordpress site on my VPS with Coolify. I am trying to upload a .sql file of 20M on phpmyadmin. I cannot figure how to increase the size (2048kio by now). On my VPS, I have a ...
Reggio's user avatar
  • 29
-1 votes
1 answer
70 views

I am seeing the error message as shown in the screenshot. I have set up all the parameters as shown below. I am also using the MAMP application in this case. Apache port: 8888 Nginx port: 8888 MySQL ...
newuser_'s user avatar
  • 9
2 votes
0 answers
130 views

Although it did works fine 2 weeks ago, since this morning, after launched Uwamp (in no install mode), if i try to access to PHPMyAdmin, i got this error message : ( ! ) Warning: Unknown: failed to ...
Tim's user avatar
  • 37
0 votes
1 answer
59 views

I am using phpmyadmin from the official docker image. I am using the designer and I am wondering where the designer page is stored. I have read in this post that it is stored in phpmyadmin....
xdev's user avatar
  • 15
-1 votes
1 answer
55 views

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM totaldata, eventvenue, band WHERE totaldata....
Naomy v.c's user avatar
  • 11
-1 votes
1 answer
49 views

I've encountered an issue while working with my AWS Lightsail database. I successfully created a new database named "test" using the root user credentials in phpMyAdmin. However, when I try ...
Samyak Jain's user avatar
  • 1
1 vote
0 answers
97 views

I'm running a Synology NAS to host my PHP website. I'm using Web Station and Container Manager (Docker). When I create a phpMyAdmin container, link it to the exisiting mariaDB database, and run it, I ...
jeromie's user avatar
  • 17
0 votes
1 answer
709 views

The configuration below works just fine on my local machine: My docker-compose.yml file: networks: mynet: name: mynet driver: bridge services: mydb: container_name: ...
amiry jd's user avatar
  • 27.7k
0 votes
0 answers
83 views

I have a bit of a arduous task each few days whereby my new CSV files (stored locally and on Google Drive) are used for data for my website tables. The current task involves TRUNCATEing of 15 tables, ...
IrishChristof's user avatar
  • 5
1 vote
1 answer
583 views

I have spun up a fresh Azure Wordpress app service which uses MySQL flexible server. I try to access phpmyadmin logging in with the database adming credentials recorded during creation of the app ...
bamdc's user avatar
  • 13
0 votes
0 answers
49 views

I have been trying for hours to update my mysql version for wampserver, and i'm stuck in V5.7.19. Even if localhost/ root show "Mysql version 8.2.0", when I go to localhost/phpmyadmin, login ...
Thomas Rbt's user avatar
  • 1,552
0 votes
0 answers
33 views

I am using phpmyadmin to run MySQL code via XAMPP. I run: CREATE DATABASE d1; And I see a database named 'd1' is created (visible on left side of my screen). Now when I run: USE d1; I get the message ...
ramank27's user avatar
  • 13
0 votes
1 answer
26 views

I have installed a web server (Apache, PHP, Maria-DB, phpMyAdmin) from the Debian packages. Now I would like to hide the installation of phpMyAdmin, i.e. the call via "https://hostname/phpmyadmin&...
Isegrimm's user avatar
  • 21
-2 votes
1 answer
81 views

Hi everyone I'm creating a schedule command with Laravel Forge that should backup the db in phpmyadmin once a day, but the problem is that it creates an empty sql file this is my code I hope someone ...
Moreno's user avatar
  • 25
1 vote
1 answer
730 views

Issue: When using PHPmyAdmin version 5.2.1 tools to edit or insert a geometry object it throws error: #1416 - Cannot get geometry object from data you send to the GEOMETRY field. This issue was ...
EL_EL's user avatar
  • 143
0 votes
2 answers
476 views

After changing the port from 80 to 8033, only the page is displayed index.php . Previously, the second page of phpmyadmin was displayed. How do I display a page with phpmyadmin? This is how I changed ...
Dato's user avatar
  • 17
1 vote
0 answers
50 views

IONOS VPS running Plesk and two Wordpress instances, behind Cloudflare CDN. We seem to be suffering DDOS attacks on our website. When they happen, disk space runs out and we can no longer log into ...
error's user avatar
  • 11
0 votes
0 answers
36 views

I have primary key subject in table teachers. I want to use subject as primary foreign key in table marks. Subject is varchar(50). And the attribute I want to apply the foreign to it called ...
Mohammed ali Samhouri's user avatar
  • 23
0 votes
0 answers
67 views

I want to create new column from concating two columns. So I created a trigger to do that before inserting new row. ex: student_type student_id student_username student 1 student_1 the type column is ...
Mohammed ali Samhouri's user avatar
  • 23
1 vote
0 answers
32 views

I have an Ubuntu server with a LAMP stack already but recently added a react server aswell. My web domain points to port 80 of course which is the apache server but I would like to have it go to my ...
Cade Heinberg's user avatar
  • 21
0 votes
0 answers
11 views

how to fetch images stored in phpMyadmin 000webhost database into flutter mobile application I try alot f codes but always it is giving me errors I do not need to fetch one image , I need all the ...
Fatima Essa's user avatar
  • 1
0 votes
0 answers
305 views

I'm having trouble connecting my database from phpMyAdmin with NetBeans IDE 21. I get an error message saying: Not Found The requested URL was not found on this server. Apache/2.4.58 (Win64) OpenSSL/...
Gabriel Smith's user avatar
  • 1
0 votes
0 answers
93 views

So I am pretty new to Wordpress and am trying to build a website. The thing I want to do is to add some tables with people's names and some info about them. Then in the website's page containing a ...
Marita's user avatar
  • 1
0 votes
3 answers
150 views

I'm testing this in MyPhpAdmin on "10.5.24-MariaDB-cll-lve", I can not define SET statements such as "SET @x = 1;" (from the manual),they don't fail but the following statementis ...
Dennis Bareis's user avatar
  • 86
1 vote
1 answer
203 views

A fresh install with composer create-project phpmyadmin/phpmyadmin will work out-of-the-box by visiting localhost:8080/phpmyadmin (served with php -S localhost:8080). However, a typical setup with PHP ...
stealing_society's user avatar
  • 153
-3 votes
1 answer
210 views

I'm using IIS on windows 10 to set up my website for testing. I have PHP and MySQL working. however, when trying to access the phpMyAdmin login I get this error: Warning: require_once(C:\inetpub\...
User's user avatar
  • 1

1
2 3 4 5
…
323