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
9 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
22 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
21 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
21 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
17 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
18 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
8 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
30 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
53 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
48 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
20 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
33 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
38 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
79 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
25 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
18 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
16 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
35 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
2answers
212 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
60 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
24 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 ...
0
votes
0answers
9 views

I am trying to import mybb Database through phpmyadmin but failing?

I have made the database through cPanel. Now I am trying to import it in my wamp server. But everytime I try only 22 tables gets imported and others don't. How to fix it? My file isn't that big in ...
0
votes
0answers
27 views

MYSQL #1146 : does it mean the data was lost?

I delete WampServer with all databases and install a new version (AppServ) with php,mysql,apache before I deleted it I copy the wamp64 folder to D:\wamp64 then I just move the folder D:\wamp64\bin\...
0
votes
1answer
18 views

Why does the column content say “Array”?

I got this problem when I'm doing mysql that every time that I post pictures on the blog it will say to the database that I got array on image column. it is supposed to have the image that I inserted
0
votes
1answer
8 views

Can I upload database backup made through cPanel into phpmyadmin?

I have been using mybb forum software. As, I use shared hosting so they had provided me cPanel. Through it I had make a backup which is a .gzip file. Now, my query here is that I want to upload it to ...
1
vote
0answers
17 views

All columns of all views defined as “1” in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
0
votes
0answers
62 views

MySQL (phpmyadmin) update query from one table to another table

I have an issue with my SQL query as I have two tables named Student_Summary and Fees_Master. In Student Summary I have a column named Admission_fees and in fees master we have Fees_Type. For fees ...
0
votes
1answer
72 views

How to remotely manage (with PhpMyAdmin) a MySQL RDS on a load-balanced AWS Elastic Beanstalk setup?

Although there are similar questions and topics, I can't find a solution that currently works. I specifically wrote remotely manage because I'd like to use my home computer's PhpMyAdmin to directly ...
1
vote
1answer
43 views

Handle 4 tables and to show 4 columns as result

i can't figure out how to build the correct query that involves 4 tables and shows these 4 columns: I want to show this 4 rows, each from a different table. EDIT: Each company belongs to a Sector. ...
0
votes
2answers
21 views

How do I export a multi table database with exceptions?

I am working out of phpmyadmin to export data using an sql. I have an 88 table database. I would like to export all data to a .csv from 85 of those tables where I am only keeping the rows in which my ...
-2
votes
1answer
52 views

Error in stored procedure on Phpmyadmin [closed]

I have created this simple StoredProcedure in the Phpmyadmin SQL console but I keep getting syntax errors. I have looked at similar created StoredProcedures but can't seem to figure out what the error ...
0
votes
0answers
27 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
0answers
236 views

Display Dynamic Pivot MySql Table to PHP

i need help on how to display this on html or php. i have this dynamic pivot table code. SET @sql_dynamic:= (SELECT GROUP_CONCAT(DISTINCT CONCAT('if(sum(if(attendance_date = "', ...
-2
votes
1answer
22 views

Where I can see phpMyAdmin release/schedule dates? [closed]

I've tried, but failed to find the source, where I can see the schedule of phpMyAdmin release dates. For example, on official site, it's 4.8.4 version, however, 5.0 version is on github. Where I can ...
0
votes
2answers
56 views

query to replace text with sequential numbers

I have an images database, the default sort is the "name" column, and the "description" column content is the exact same in all files in the table. what I need is to replace certain text in the "...
1
vote
0answers
38 views

Create a table via an INSERT trigger in MariaDB

I'm trying to make a small database I can use to log changes I make to configuration files on various Linux systems. My thought was have a Database named for the system, and then a table called ...
1
vote
0answers
22 views

Weird database icon appears on PHPMyAdmin user interface

On my PHPMyAdmin user interface, I noticed one database which has a strange icon: What does this mean? What causes it? P.S. Note that the database in question functions well (I mean I have no issue ...
-1
votes
1answer
53 views

phpMyAdmin 4.8 vs 5.0 comparison

doc says that since release 5.0, only php 7.1 and later are supported. Can you tell me, where I can viw & compare features among phpMyAdmin versions? why v5.0 is so special that it can't be run on ...
0
votes
1answer
136 views

Auto update “TIMESTAMP” column only when a manual phpmyadmin edit occurs?

I have a column in my MySQL database that uses a "TIMESTAMP" to capture the current time. I have an attribute set to "on update CURRENT_TIMESTAMP" so it auto updates the column whenever and update ...
0
votes
2answers
52 views

Replace some rows in one table with rows of another table

I have two tables and a set of primary key values. I want to replace all rows of the first table whose primary keys are in this set with the corresponding (having the same primary key) rows of the ...
0
votes
1answer
176 views

#1146 table 'db.tablename' doesnt exist

I use AMPPS for localhost server purpose. I was working on one of my client site on localhost. When I start working the other day, it suddenly start giving me such error table does not exist Even ...
1
vote
1answer
32 views

Having troubles creating a specific TRIGGER in MySQL

So I am trying to implement a trigger in MySQL that is triggered once a new user is registered. The relation of my tables are: USER_ACCOUNTS has primary key USER_ID. RACE_TRACKS has primary key ...
1
vote
2answers
76 views

Mysql optimization edit my.cnf

Firstly, I am a beginner. I have a server, which has 32 GB RAM and 16 CPUs. I am working on MySQL optimization, but I have a problem. I am trying to set the InnoDB buffer pool instances = 8. But it'...
-1
votes
1answer
80 views

Inserting data into a 3NF database [closed]

I have 6 tables with ~2-15 attributes each, each one of these 6 tables has an ID which is constrained from another table. This 7th table has its own ID and the 6 other table ID's, as well as a date ...
0
votes
1answer
92 views

Does phpMyAdmin only works with HTTPS?

I have manually setup phpMyAdmin (downloaded from official site) on my site. However, when I enter my User&Pass in login page, i get warning: When i try same page with HTTPS, it logins. Any idea ...
1
vote
1answer
137 views

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1 Query 1: SELECT * FROM table Number of records : 103 Load time : 0.0005 sec Query 2: SELECT * FROM table ...
1
vote
1answer
40 views

Fetch ids(Primary Key) from table where ids not available in table within range

I have table named Student. It have primary key student_id which is auto increment and not null. Now Student contains around 5000 records. After passed out from university, we need to delete ...
0
votes
2answers
114 views

Update from PHP 5 to PHP 7.0 - PHPmyAdmin will show two server logins: localhost / localhost:3306

I updated my Linux 14.04 LTS to 18.04 and had to downgrade the PHP 7.2 to 7.0 as I need to run some software which is not capable of the preinstalled PHP 7.2. I used PHP 5 so far. After I got ...
1
vote
0answers
52 views

Simple/basic database design problem (with relationships)

It's been years since I've done anything with SQL databases (and I was never more than a novice). I think I've messed something up and I'm not sure how to fix it. I have 3 tables: services (as in ...