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.
386
questions
0
votes
1
answer
31
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 ...
- 1
-3
votes
0
answers
19
views
I have 2 table. In Role table have merit point for each roleid. How to get total sum of merit point for student id 100, as like table below in SQL [closed]
How to get total sum of merit point for student id 100, as like table below in SQL.
I have two table :
Table 1 - Student Activity.
Activity_id
Student_id
Activity_id
roleid
1
100
12
2
2
100
16
3
3
...
- 1
0
votes
0
answers
238
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
140
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 ...
0
votes
0
answers
26
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; ...
- 1
1
vote
0
answers
36
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 ...
- 11
0
votes
1
answer
131
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 ...
- 103
0
votes
0
answers
17
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 ...
1
vote
0
answers
55
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 (...
- 111
0
votes
0
answers
107
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. ...
- 1
0
votes
0
answers
72
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 ...
- 1
0
votes
3
answers
181
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
0
votes
1
answer
48
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 ...
- 185
0
votes
1
answer
191
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 ...
- 317
0
votes
0
answers
19
views
How to change the FROM clause of multiple views at once (phpmyadmin)?
I have created multiple SQL views in a database (say views-db). Some of them refer to other views in the same database, others refer to tables in another database (say table-db). Now I have to migrate ...
- 101
0
votes
0
answers
67
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 ...
- 1
0
votes
0
answers
65
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. ...
0
votes
2
answers
39
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 ...
- 5
2
votes
1
answer
264
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 ...
0
votes
0
answers
80
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 ...
- 111
0
votes
1
answer
10
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
...
0
votes
1
answer
29
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 ...
-3
votes
1
answer
945
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:
- 11
1
vote
1
answer
160
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` ...
- 11
1
vote
1
answer
27
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
...
- 23
2
votes
2
answers
206
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:...
- 31
0
votes
0
answers
182
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 ...
0
votes
0
answers
459
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?
- 9
0
votes
0
answers
113
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 (...
-2
votes
1
answer
257
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:
1
vote
1
answer
10k
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 ...
- 111
-1
votes
1
answer
2k
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 ...
0
votes
2
answers
291
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 ...
- 119
0
votes
1
answer
54
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 ...
0
votes
2
answers
340
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?
- 3,205
-1
votes
1
answer
281
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 ...
- 3,205
0
votes
1
answer
59
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 ...
- 3,205
0
votes
1
answer
400
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 ...
- 61
0
votes
1
answer
270
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 ...
user237107
0
votes
1
answer
94
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 ...
- 1
0
votes
0
answers
118
views
Sql query + wpml in one language only
I'm not a developer, just a normal user, so please don't expect me to be like you :)
I'm managing my website in WordPress, Running 4 languages using WPML, (en,de,cz,pl)
My concern is, I want to search ...
0
votes
1
answer
637
views
How to speed up queries for 2m Datasets in PHP & Mysql
We have a SaaS Application site, where we would have over 2M records in a table.
Server version: 8.0.19 - MySQL Community Server - GPL
Protocol version: 10
Even with the indexes these queries are ...
- 1
0
votes
1
answer
26
views
Inserting data from one database to another database in specific columns not working [closed]
I have csv formatted data, i want to put the data to my existing database's table in specific columns. I was trying to do it with LOAD DATA INFILE... and i have even uncomment the mysqli....
- 111
-1
votes
2
answers
120
views
Creating Tables with the same table names from other databases doesn't have any bad effects?
I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
0
votes
1
answer
900
views
Why do I get #2006 MySQL server has gone away and how can I fix this?
What I'm doing is I'm trying to restore MySQL tables from frm and ibd files. Most of the tables have been restored successfully.
I do it like this:
mysqlfrm --diagnostic "C:/<path_to_frm>/...
- 141
0
votes
2
answers
98
views
SQL query for getting Count of distinct items along with Total [closed]
I'm using MySql (hosted locally at xampp) to store sale information
I want the output something like this
Is there a single query that gets me the output in this format or should I write multiple ...
- 111
2
votes
3
answers
3k
views
Export and import a table without a specific column
I'm trying to export a table with an Auto Increment rowid column and then import it in another server.
Considering that the column is primary key and can't accept duplicate keys if i import rows after ...
- 149
0
votes
0
answers
300
views
Force double quotes in phpMyAdmin export dump
I have a varchar column in my table but when I export it in phpMyAdmin (4.6.6deb5ubuntu0.5), the values are quoted with single quotes. How do I force double quotes? I don't see a setting.
CREATE TABLE ...
- 101
0
votes
1
answer
287
views
Why transaction blocking simple insert in MySQL? [closed]
transaction Query
mysqli_begin_transaction($conn);
$sql = "UPDATE foldertable SET trashed = 1 WHERE serverToken = (SELECT serverToken from servertoken where userToken = ? limit 1) and
...
- 113
0
votes
2
answers
159
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