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
0answers
21 views

Group by with Order by DESC not working using PHP MySQL codes

I have three, table one name (tbl_brands) with these columns: and second table name (tbl_loader_attachment) with these columns: and the third table name is (tbl_images) with these columns: I used ...
-2
votes
0answers
14 views

could not be able to execute. unknown column in on clause [closed]

ERROR: Could not able to execute SELECT * FROM bookingTable INNER JOIN stoelen ON bookingtable.bookingID = stoelen.stoelenid;. Unknown column 'stoelen.stoelenid' in 'on clause' This is the full error ...
1
vote
2answers
38 views

How to create a running balance column based on account number?

I have a stored procedure that returns account statement for one or multiple accounts Here is the part I have issues with: returning a running balance in each record based on account number. My query ...
0
votes
2answers
23 views

MySQL/PHP - SELECT DISTINCT column based on another column with ORDER and LIMIT

I have a table named messages that is as follows: +-----+-----------+-------------+-----+ | id | sender_id | receiver_id | ... | +-----+-----------+-------------+-----+ | . | . | ...
0
votes
1answer
28 views

Changing storage engine to InnoDb from MyIsam is dropping records from table

Currently our Database all tables are using MyIsam as a storage engine. We tried changing storage engine of our mysql tables from MyISAM to InnoDB from PHPMyAdmin operations tab. However during the ...
-2
votes
1answer
14 views

Random ID for database users

I need to create a table with a random generator ID for users including letters and numbers for example: FT128 instead of default auto-increment ID Thank you for any help.
0
votes
0answers
11 views

Error : mysql goes away when upload File in MBs [duplicate]

I have a table that store the file content of uploaded file. The datatype of the column is LONGBLOB. when i try to upload file of 9 MB in size show mysql error "mysql goes away". what i am doing in my ...
0
votes
2answers
2k views

How to switch from MariaDB to MySQL in WAMP server?

I installed wamp server on my PC and by default wamp server is connected to MariaDB as showed below How can i switch to MySQL? Thank you in advance for your help.
-1
votes
1answer
21 views

MySQL tables_priv corrupted

I have a mysql database and i need to create an user for the login. This user need the privileges to only select on only one table where the login info are. on phpmyadmin when i use the gui i receive ...
0
votes
0answers
17 views

PHPMyAdmin #2002 error - fixed by restarting mysql but it occurs again

I have a LAMP server running MySQL and PHPMyAdmin. Yesterday I got the following error trying to login to PHPMyAdmin: #2002 - No such file or directoryThe server is not responding (or the local ...
0
votes
1answer
30 views

ORDER BY with IF-ELSE statement (DESC doesn't work)

Descending sort type does not work with this syntax, please help. <?php require_once("../connection/conn.php"); $compare = $_GET["sortfield"]; if(isset($_GET["sortfield"])){ if(isset($_GET["...
0
votes
1answer
160 views

Mysql 8 accidentally lost ROOT user all privileges in localhost wampserver 3.2

Mysql 8 root user all privileges lost.I changed some permissions from phpmyadmin. . After that all tables disappeared. I found this answer Lost All Privileges in MYSQL.but did'nt help me. I am using ...
0
votes
1answer
12 views

MySQL database getting connected with any username and password [duplicate]

We have a website running on an custom Ubuntu server managed and hosted by the client himself, since last two days the website database is getting hacked and someone deletes all the db tables from the ...
-1
votes
1answer
28 views

MySQL Table is Huge Where Only Text Values Are Stored

I am using LAMP Stack...And one of my db table wp_options (Rows: 10,600) is now about 194+ GB in size... Not sure why the size growing so much huge... As far as i am concern most of the records are ...
-2
votes
2answers
28 views

i want fetch json data in mysql [closed]

I am using MySQL version 5.6.41-84.1-log, I want to fetch single column of JSON data example: I want to fetch date only id | amount_detail ---------------- 1 | {"1":{"amount":"6000","...
0
votes
1answer
60 views

Unable to Join phpMyAdmin Using MySQL Defined User

I can login to mysql via the command line just fine, but when I try to log on to phpMyAdmin with the same password that worked in the cli, it won't allow me to connect and gives me: ...
0
votes
2answers
169 views

How to turn off autocommit in phpMyAdmin

I want to practice rolling back commands, savepoints and more on phpMyAdmin but I couldn't find a way to turn off autocommit in phpMyadmin. Currently I use the command SET autocommit = 0;. ...
0
votes
1answer
26 views

Local MySQL database check for changes

Me and my friend had a website. Before closing website he dumped MySQL Database from phpmyadmin and stores it locally on his PC. Now he send me sql file. Is there a way to see if he didn't change/add/...
0
votes
1answer
583 views

How to export specific columns from a SQL table

I am cleaning some data bases and was wondering that if there is any proper way to export any single column and all it's entries from a SQL table. Being specific, I am dealing with SQL tables in ...
-3
votes
1answer
57 views

Transfer Mysql table data to client Server via TCP/IP by using Trigger [closed]

i Have Database on MySQL Server. I have one Table so called "log" in Database. Data has been insert in Database table automatic. I would like to transfer table via TCP/IP to the another Software. ...
0
votes
1answer
108 views

MySQL Trigger: Insert depending on NEW.column of type enum

I am trying to add a trigger to one of my tables. Depending on a enum-value of the newly inserted row it should execute a different insert-query. I am using phpMyAdmin and am trying to execute my ...
0
votes
0answers
41 views

Why does PhpMyAdmin put the idexes at the end of a dump?

When I export a MySQL database with Adminer or with mysqldump, it produces a .sql file with each table definition followed by (if the table is non-empty) an INSERT statement (or multiple statements ...
0
votes
1answer
35 views

How to use a MySQL database both remotely and locally

I cannot find the best solution for my problem. I made a C++ application which runs on a Kiosk under Ubuntu that needs to store and retrieve data from a MySQL database and these same data need to be ...
0
votes
0answers
30 views

Function prefixed with 0x

I have a table created with Create table log ( ip VARBINARY(16) ); I can insert into the table with Insert into log values (INET6_ATON("127.0.0.1")). When I use phpMyAdmin 4.5.4.1 in the "...
0
votes
0answers
35 views

NULL queries getting stuck and using up connections

Running show processlist in phpmyadmin for me often shows queries with an Info of NULL and a Time of apparently a few seconds, but which have in fact been stuck there for a long time (each time I run ...
0
votes
0answers
65 views

Syntax error in WITH as PhpMyAdmin procedure

Good day. I have problems creating the following stored procedure in PhpMyAdmin 4.8.5 the query is as follows. Create Procedure sp_TPbalonmDcdos() WITH cte AS ( SELECT categoria,ndeporte,genero,...
2
votes
1answer
577 views

#1036 - Table 'pma__recent' is read only in phpMyAdmin / xampp / Windows

I have about 40 databases on localhost powered by xampp 5.6.15. Some of them use MyISAM and others InnoDB. The database has been corrupt and phpMyAdmin was permanently outputing error messages. I ...
0
votes
0answers
19 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 ...
0
votes
1answer
25 views

How to connect two attributes without a PK (MySQL)

I'm a new programmer and I'm doing a database on MySQL with phpmyadmin. I have this doubt - I know that if you want to link two different tables you need an attribute that is a Primary Key, and ...
0
votes
1answer
152 views

Dates values displayed 0000-00-00

I have imported a csv file into my database created in phpmyadmin using sql. Server version: 5.6.37 - MySQL Community Server (GPL I have a column for dates which has a datatype of date. The data ...
0
votes
0answers
18 views

phpMyAdmin — how do I figure out which DB these connections and processes belong to?

I've got about 8 databases on one server, mostly corresponding to WordPress sites. I'm using shared hosting that does not give us superuser permissions. When I log into phpMyAdmin (version 3.5.2) and ...
0
votes
1answer
22 views

Which Is the Used Size Unit In DiskSpace Column at Storage Table In Zoneminder Database

Trying here, without success change the storage location of Zoneminder events and images, but having trouble with denied access of www-data user, despite have already changed both Zoneminder config ...
2
votes
0answers
1k views

mysql to mariadb: unknown collation utf8mb4_0900_ai_ci

I have a mysql 8.0 that I exported using mysqldump. I am trying to import it onto a Mariadb 10.4 database with phpmyadmin, both are the most current versions. Each time I do it though, I get: Error: ...
0
votes
0answers
30 views

MySQL: how to update a table based on changes to another table with trigger or stored procedure

Because of the limitation of a wordpress plugin I am using I cannot update tables from the website when they are created from JOIN statement. So I created a bigger table with data of all tables. But I ...
0
votes
1answer
443 views

MySql date range query not showing all records

I am working on mysql query right now. I write a query from fetch data from march 2018 to march 2019. There are more than 5000 records for this year. I write a query with date range from march 2018 to ...
0
votes
0answers
8 views

Allow only import table in phpmyadmin

We build a wordpress site as a database interface in localhost (only). We are using a plugin WpDataTables to display tables, statistics etc. Is it possible to expose somehow only the import option of ...
0
votes
0answers
28 views

MySQL db export log

I have a mySQL db shared between several users and I would like to know if when a user exports all the db into a file there is any log of that operation and who did what... I don't want the data '...
0
votes
0answers
797 views

Error Code: 1129 Host 'xxx.xxx.xx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

For the past few days, I am getting this error every morning when I tried to connect to the MySQL database using the MySQL workbench and also through some applications. So, every day I log onto the ...
1
vote
0answers
141 views

Multiple join with self join in MySQL and split column in row

I have four tables "Commission" , "Vendors", "Accounts" and "comsplitconfig" like commission Table commissionid vendorid accountid sales commission 1 V1 A2 ...
0
votes
2answers
2k views

Monthly Date and Hour wise report generation using PHP MYSQL

Attendance Portal in PHP I am facing problem at Final Attendance Report Generation I'm stuck at the final stage of the Project: I have a Table- attendance, If a student is Present I mark it as 1 if ...
0
votes
1answer
626 views

Admin on phpMyAdmin does not have Super privileges

I have Plesk via GoDaddy and I am the sole admin and user. When I go to phpMyAdmin and try to execute the following: SET GLOBAL event_scheduler = 'ON' I get the error "#1227 - Access denied; you ...
0
votes
0answers
23 views

Compare 2 products output all difference

Is it possible to compare using product id in phpmyadmin so after running in mysql it will output any differences between a product id which has been resaved and showing on front end and another which ...
0
votes
0answers
29 views

phpmyadmin “find and replace” shows only first 17 columns

I would like to use phpmyadmin's "Find and replace" function, but it shows only the first 17 columns (out of the 61 in that table's structure); the column I want to use is past the first 17 columns. ...
1
vote
0answers
779 views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
0
votes
0answers
274 views

AllowNoPassword

I installed phpmyAdmin on CentOS7 but I am not able to login. It I try to login without password, it gives following error. Login without a password is forbidden by configuration (see AllowNoPassword)...
1
vote
0answers
23 views

How to prevent a record from being affected by the ORDER BY RAND() function?

I am building an online exam site using php and mysql. It's just for MCQ type questions. Here is my database structure: 1) QUESTIONS ( Exam_ID, Questions_ID, Questions_Des) 2) OPTIONS ( Question_ID, ...
0
votes
0answers
177 views

SQL ERROR [ mysqli ] Can't find FULLTEXT index matching the column list [1191]

I faced this problem after importing the DB, recently i had to setup the fresh one so i used the already taken backup of files & db after importing db this following error shows, General Error ...
0
votes
0answers
2k views

phpMyAdmin - Cannot log in to the MySQL server

Setup a new instance of phpMyadmin and I am able to sign with root and password, but when I do the following I am unable to login. Also able to sign into mysql via command line. create user 'user'@'...
0
votes
0answers
55 views

Can't run the newest version of MySQL on phpMyAdmin

I am building a database on phpMyAdmin. However, it doesn't include the latest version of MySQL: I downloaded the latest version of MySQL from this link: MySQL Community Server 8.0.16 However, even ...
0
votes
1answer
52 views

How can I write a trigger that can subtract values between two tables

I have a table called transaction that has these fields CREATE TABLE transaction ( transaction_id INT AUTO_INCREMENT, status varchar(255), myPIN varchar(255), amount_paid varchar(255)...

1
2 3 4 5
7