Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [phpmyadmin]

phpMyAdmin is an open source tool written in PHP to handle administration of MySQL over the web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; monitor MySQL health status, or managing users and permissions.

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

PhpMyAdmin: How can I modify the hierarchy to show Tables and Views collapsible items?

I'm not sure how to describe this problem. I'm in the process of migrating a database to a new laptop. I installed XAMPP 5.6.20 which includes PHP, MySQL, and PhpMyAdmin. So I exported the SQL ...
Harry McKenzie's user avatar
0 votes
0 answers
5 views

Migrating a web site from shared cPanel to unmanaged Ubuntu 22.04 vps and not able to successfully import an sql file

I got an unmanaged VPS from Hostinger a week ago and am trying to host a few web sites on the server. I have to say here that I am quite new to Ubuntu 22.04 with FASTPANEL. I have migrated the files ...
mgl's user avatar
  • 1
0 votes
1 answer
34 views

Multiple resultset from mariadb procedure

I am trying to return multiple resultsets from (phpmyadmin) mariadb procedure but am failing. For example I have two tables Entities and Relations and for a test I created a procedure to select ...
user1806687's user avatar
0 votes
0 answers
78 views

Unknown Database

I have a very strange issue wth mySQL. Yesterday a Db from a server was disappear. if I log on to phpmyadmin panel i see the DB on the left side menu of phpmyadmin panel but if try to open it (click ...
Andrea_86's user avatar
  • 101
0 votes
0 answers
246 views

Recover a database accidentally deleted in phpmyadmin

I have accidentally deleted a dztabase from phpmyadmin plateforme that had no backup copy anywhere. Is there any solution to bring back this database ?
user avatar
0 votes
0 answers
25 views

Two Database Instances, need to share table data

Background Two sites, both WordPress; one is public-facing, and the second is private with restrictive access. The public-facing site has a form on it, but I need to be able to access the information ...
N. Kendrick's user avatar
0 votes
0 answers
24 views

Access MySQL remotely with terminal and PHPMyAdmin

First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'...
Zep's user avatar
  • 1
0 votes
1 answer
44 views

Quickly duplicate the same row with 1 random column

I need assistance duplicating a single row in phpmyadmin 1000 times with the same data except for 1 column for codes. The code has to be random. Here's a sample: Is there an easier way to do this ...
iJchael's user avatar
0 votes
1 answer
76 views

Replication Slave to Master

I am currently trying to figure out the replication feature for Databases. I am new to this ,as until now I only used databases for simple inserts and selects for webpages. Now I am trying to build a ...
Sam's user avatar
  • 1
0 votes
2 answers
111 views

Can I display more than one column as foreign value description in phpMyAdmin?

phpMyAdmin allows me to select a different column to display foreign values, so instead of having to look for the key, I can look for something more understable from human perspective like a city name:...
xerez's user avatar
  • 1
0 votes
0 answers
786 views

"The mysqli extension is missing" Tried everything but still no fix!

I recently upgraded to php 8.2.7. Everything was fine until I checked phpmyadmin and got the mysqli extention is missing. I edited the php.ini file in /etc/php/8.2/apache2 directory and added the ...
mani-hash's user avatar
  • 101
1 vote
2 answers
440 views

Migrating MySQL databases to a new server with phpMyAdmin

Looking for the best way to migrate a dozen or so MySQL databases from an old Mac mini to a new one. I've tried the source machine's phpMyAdmin (v. 4) EXPORT command, using what looked like reasonable ...
Rob Lewis's user avatar
  • 111
0 votes
1 answer
47 views

AUTO_INCREMENT Bug in MySQL

I encountered a very strange bug in MySQL, perhaps it is something which can be fixed easily but I didn't found any solution to this problem. When I insert a new entry in any table, via php on the ...
Sam's user avatar
  • 1
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
2k views

unlock the only MySQL account

By accident I locked my root account in MySQL which I launch using wamp server, the error message from phpMyAdmin is Access denied for user 'root'@'localhost'. Account is locked. How can I unlock ...
Allaw Hussein's user avatar
0 votes
0 answers
53 views

PhpMyAdmin doesn't encrypted on login

I have server on DO. I already use ssl https. On url showing my ssl was running but when I login to my phpmyadmin, why login information showing without encrypted? I also add $cfg['ForceSSL'] = true; ...
Eve's user avatar
  • 1
1 vote
0 answers
110 views

Auto Increment ID based on 2 columns

I have table called Logs. it has 4 columns ID, USER_ID, USER_TYPE, USER_ACTION where USER_ID is unique USER_TYPE is unique for every USER_ID and USER_ACTION can be anything 1,2,3 or A to Z. USER_ID ...
Zoheb Patel's user avatar
1 vote
1 answer
2k views

Remove new lines in rows

Seem to have an issue with some rows in my database from when I was manually copy/pasting data from excell into phpmyadmin the fields also copied new lines in. When I export the database and open it ...
Toodarday's user avatar
  • 113
0 votes
0 answers
86 views

Should i rely on PhPMyAdmin's table normalizing tool or do i carry out the changes myself?

Full disclosure: The images themselves are in spanish, i want to bring attention to the design only so i'm not modifying the former. This may or may not be part of an actual information system that ...
Ismael Párica's user avatar
1 vote
0 answers
178 views

How to export MySQL in a format accepted by DigitalOcean database clusters?

I am struggling with importing my databases to Digital Ocean database clusters. They have a setting that requires the primary key to be defined in the CREATE TABLE statement, but all my tools (...
Matt Welander's user avatar
0 votes
0 answers
233 views

Cannot create a new column in MySQL using workbench, why?

I am currently running linux mint. The MySQL tutorial that I am using calls for workbench GUI along with XAMPP. As usual, support for linux is crap. I had to make do with the workbench ubuntu file. ...
SM Umair's user avatar
0 votes
0 answers
210 views

How to include "CHECK" constraint to backup done via phpMyAdmin?

When I export my database from phpMyAdmin (quick method), it does not include CHECK constraints. However, when I run SHOW CREATE TABLE table, I see the constraints. Moreover, foreign constraints are ...
xerez's user avatar
  • 1
0 votes
3 answers
429 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
0 votes
1 answer
81 views

Is replication on by default on MySQL 8.0.30 ? How to stop it?

I am running MySQL 8.0.30 on Rocky Linux 9. While importing some ~100GB sql files, I noticed the /var/lib/mysql is filled with binlog.000123 files, over 100GB. I assume these are created because ...
adrianTNT's user avatar
  • 195
0 votes
1 answer
319 views

Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2

Not sure to post on the right StackExchange forum. If not, let me know! Working environment: OpenSUSE Leap 15.4 MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB PHP 8.0.25 (cli) (built: Oct 31 2022 ...
wiltomap's user avatar
  • 317
0 votes
0 answers
240 views

How edit .sql file in windows (excel)

I'm not very expert in SQL, i just want edit some tables on my website's phpmyadmin and it takes a lot of time.so I want to export the sql file and edit it on Microsoft excel or any similar tools, but ...
Sophia's user avatar
  • 1
0 votes
0 answers
136 views

edit privileges not showing

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. ...
Harshika Gawade's user avatar
0 votes
2 answers
60 views

Visualize MySQL Database int to text with bitwise

I have a column which is int. It stores user's info as flag. I created a flag table so that some numbers correspond to some properties. For example: User's flag: 7 Flag table values means: 1= Full ...
Emrexdy's user avatar
2 votes
1 answer
496 views

Optimize a query multiple tables & Multiple conditions

I need to optimize the query which has multiple joins. And also with multiple OR AND conditions which varies depending upon the user input. The query which gets generated is: SELECT emp.name as ...
Parikshit Bharadwaj's user avatar
0 votes
0 answers
140 views

phpmyadmin cannot upload and read the longblob bin file

I need to upload 20-30 MB longblob bin file to my table. I have changed the PHPMyAdmin config file: memory_limit = 128M upload_max_filesize = 100M post_max_size = 128M The first issue is after I ...
ITnewbie's user avatar
  • 111
0 votes
1 answer
12 views

Select rows that are not present in the table based on criteria

I have two tables student table and fee table: First Table (Student): std_id std_name 1 A 2 B 3 C 4 D 5 E 6 F Second Table(Fee): fid std_id amount Month 1 1 500 2022-07 2 2 500 2022-07 3 4 ...
Sikander Shahzad's user avatar
0 votes
1 answer
73 views

Select rows that are not present in the table

I have two tables student table and fee table: First Table (Student): std_id std_name 1 A 2 B 3 C 4 D 5 E 6 F Second Table(Fee): fid std_id amount 1 1 500 2 2 500 3 4 500 I want to fetch ...
Sikander Shahzad's user avatar
-3 votes
1 answer
1k views

errno: 150 "Foreign key constraint is incorrectly formed", can't create table

How do I resolve this problem? I'm trying to import database into a hosting site, but got this message: From this section in the .sql file:
Kirito7070's user avatar
1 vote
1 answer
327 views

phpmyadmin schema dump, how to avoid alter table for key definitions?

When I dump the mysql db schema with phpmyadmin (5.2.0), I would like to get something like this: CREATE TABLE `MEASURE_TABLE` ( `measureID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sensorID` ...
ptrchv's user avatar
  • 11
1 vote
1 answer
32 views

how to write mysql query for the following problem?

products table table1 which has item names item_cid item_id item_name 8 403 Tequila1 8 404 Tequila2 8 405 Tequila3 8 406 Tequila4 8 407 Tequila5 8 408 Tequila6 2 409 budwiser1 2 5 budwiser2 ...
gopal's user avatar
  • 23
2 votes
2 answers
229 views

Does this kind of data/field in this table needs normalization in MYSQL?

I have this uom table in MYSQL: id uom 1 piece 2 dozen 3 set and this products table in MYSQL: id itemNo title uom 1 19421 test1 1:1:10.00,3:1:56.17 2 7878 test2 1:1:24.33 3 123456 test3 2:12:...
Algo's user avatar
  • 31
0 votes
0 answers
240 views

phpMyAdmin Export duplicates column name

I have a MYSQL 8.0.28 server as well as phpMyAdmin running in docker containers. Everything seems to work except that when exporting the database to a dump file through phpMyAdmin one of the views has ...
Steam Trains's user avatar
0 votes
0 answers
560 views

Phpmyadmin error Notice in ./index.php#305 Undefined index: utf8

I installed PHPMyAdmin and work with MariaDB 10.6. When accessing the main page I receive an alert with the message: Notice in ./index.php#305 Undefined index: utf8 Any idea how I can fix it?
enggal's user avatar
  • 9
0 votes
0 answers
133 views

phpmyadmin Triggers

welcome I have three tables in a database and I want to link them videos channels channels2 i have code SET @channel=(Select channelnumber from channels where flag='0' and channelnumber not in (...
Hossam Merhe's user avatar
-2 votes
1 answer
346 views

How to calculate balance from debit and credit columns for mysql

I Have two columns Debit and Credit and want query to calculate balance from debit and credit for individual customer as shown below in the image:
Sikander Shahzad's user avatar
1 vote
1 answer
15k views

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) - phpmyadmin

I have newly installed MySQL 8 and PhpMyAdmin. I did all the installation steps properly. but once i get login to PhpMyAdmin by root user, it always gives an set of errors at the bottom of page saying ...
rahul shalgar's user avatar
-1 votes
1 answer
3k views

errno: 150 "Foreign key constraint is incorrectly formed

create table Users( id float(6) primary key, username VARCHAR(20), foreign key(id) references Emps(id)); /*inserting records into users table*/ insert into Users (id) select Employee_Id from emps ...
Benzir Ahammed Shawon's user avatar
0 votes
2 answers
474 views

Show "0" instead of empty with phpmyadmin

When I run this query the result is empty and it doesn't show me anything select pr.idpreorden,p.DescProducto,pr.Id_Producto, pr.pre_preciounitario, pr.pre_cantidad,pr.pre_total from ...
kenny's user avatar
  • 131
0 votes
1 answer
59 views

How to get the maxium row value for a similar values

In my table below, I have id and job_id fields with some of the job_id fields being duplicates. I want to get the MAXIMUM value of the id field corresponding to each unique job_id. I have now tried ...
Ernest Elikem's user avatar
0 votes
2 answers
570 views

Does using the export option to backup a MySQL database (12GB size) cause any performance issues or locking on database?

I have a 12GB database. I want to take a compressed backup using the export option via phpmyadmin. Does this cause any performance impact or locking on the database?
variable's user avatar
  • 3,634
-1 votes
1 answer
583 views

How to take a database backup to a binary file in MySQL using phpmyadmin?

I am using phpmyadmin user interface to mysql database. I want to take a full database backup, and if possible then a compressed one. I know that I can export the database into a .sql file. How to ...
variable's user avatar
  • 3,634
0 votes
1 answer
67 views

Is there a MSSQL `copy only` equivalent in MySQL?

In MSSQL, so that a randomly requested full backup does not affect the differential and transaction log backup chains, we have the option to use the copy only mode. Is there an equivalent of this mode ...
variable's user avatar
  • 3,634
0 votes
1 answer
507 views

Error #1064 on DB Import via PHPMyAdmin

I am using: mysql Ver 15.1 Distrib 10.3.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 I have a wordpress db that I am trying to migrate from one dev environment to another, but I am ...
yupthatguy's user avatar
0 votes
1 answer
406 views

Column collision in Left join with many columns vs PHPMyAdmin resultset

I have 4 tables (75 columns each table approx) but they share columns with the same name: Table Master_Producto Master_Product.PD_Prof_21 Table Product_Structure Product_Structure.PD_Prof_21 I am ...
user avatar
0 votes
1 answer
135 views

Importing MySQL dumps to multiple MySQL instances in one machine

In case of title is not clear, I would like to explain myself further. I have 6 MySQL instances in my server. Let's call them, M1, M2, .., M6. The reason I have 6 MySQL instances here, I have also ...
emir ko's user avatar

1
2 3 4 5
8