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
1answer
8 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
0answers
18 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
17 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
34 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
35 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/...
-1
votes
1answer
26 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
47 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
45 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
26 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
28 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
28 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
33 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
157 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
17 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
24 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
38 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
16 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
19 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 ...
0
votes
0answers
479 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
25 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
220 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
16 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
761 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
57 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
1k 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
285 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
26 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
390 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
100 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
21 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
97 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
773 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
50 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)...
0
votes
1answer
42 views

JOIN in 4 tables gets phpmyadmin unresponsive

I can´t manage to create a valid query that shows me 5 columns from these 4 tables: As you can see the relationships that i'm trying to JOIN in the query are highlighted in differents colors. The ...
0
votes
1answer
277 views

Which MySQL shows CPU usage?

I am monitoring MySQL server using phpMyAdmin [Status => Monitor] function. And it shows a number of useful graphs. Which variables (or which mechanism) is phpMyAdmin using to pull this data? ps. ...
-1
votes
1answer
52 views

How can I capture user IP address and store them automatically to my database? [closed]

am currently running an open voting system with no login form. I wanted to restrict double voting using user IP Addresses, how can I record user addresses direct to my database and use them to ...
2
votes
1answer
83 views

Distribute n questions to m students with all students having the same questions but in different orders

I am building an online exam platform with PHP and MySQL. I have the following requirements for the database: The exam questions are of MCQ type and there are 20 questions. There are 30 students ...
0
votes
1answer
32 views

showing table is full on alter mysql

In my phpmyadmin , when am adding a new column to my table , mysql throwing me error table xxx is full i also search on google , but did not get help. am also gone through dba.stackexchange.com ...
0
votes
1answer
42 views

Do I need to change the delimiter when creating a procedure using PHP MyAdmin?

I know I need to change the delimiter when manually creating a MySql Procedure but I can't find evidence on how to do it when using the PHP MyAdmin new procedure form or is it even necessary to change ...
0
votes
1answer
27 views

Is there a way to get the query results (rows affected/time taken) after every query

I run multiple MySQL queries together in phpMyAdmin, I basically want to be able to see the results of each query (rows affected/time taken etc) as it completes. Say I have the following sample ...
0
votes
0answers
18 views

unable to use tables created in phpmyadmin in server

I have created a database in MySQL using phpmyadmin running on localhost (Xampp Default Settings). I created 5 tables and added little data to check it on the localhost. Now, wanted to shift this ...
0
votes
1answer
50 views

Mysql join query improvement and GROUP_CONCAT on GROUP BY

I have two tables which I need to perform a left outer join on to get the result set I want. The query I have now works but its taking too long to process. Any suggestions? Query: SELECT Date_format(...
1
vote
3answers
3k views

Default phpMyAdmin Login Credentials

I downloaded and installed phpMyAdmin 4.8.5 on my windows. Upon opening it in the browser, it immediately asks for a Username and Password. I tried to submit root for username while leaving the ...
1
vote
1answer
262 views

MySQL Triggers not working from PHP page but work for manual DB updates via phpMyAdmin

I have the following two Triggers in my MySQL DB that fire BEFORE/UPDATE and AFTER/UPDATE on the house_report_details table. The first deletes all records in my scratch table tmp_house_rpt_details and ...
0
votes
1answer
92 views

How to use Unicode chars on PHPMyAdmin?

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009). PHPMyAdmin is used for ...