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.

learn more… | top users | synonyms

4
votes
1answer
1k views

SQL set profiling

I'm setting up an automatic database backup for a website. When I try to do a backup it comes up with the error" MySQL error: The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-...
1
vote
1answer
30 views

Is it possible to reorder tables in phpMyAdmin?

By default, database tables are ordered in alphabetical order. Can this be reordered? For example: default alphabetical: company, profile, user common User Flow: user, profile, company Maybe the ...
1
vote
1answer
219 views

Default user group in phpMyAdmin

I am setting up a multi user environment for shared hosting. Since phpMyAdmin 4.1.0 it's possible to create user groups, add users to them and define which functions they may use. Now this is a great ...
1
vote
1answer
1k views

phpMyAdmin Error After Upgrade to 3.5.8.1

Im Nubie in mysql, I use that only for PHP. to the point, I try to upgrade myphpadmin 3.5.8.1, after I that, I cant accses my database and have error like This: #1064 - You have an error in your ...
0
votes
1answer
16 views

Using value of a column in another table for ENUM/SET values

I have two tables tbl_events with a column location_id. Then I have a table specifically to hold locations and their IDs,the columns in table tbl_locations are location_id and name. I want the ...
0
votes
1answer
56 views

PostgreSQL to MySQL migration to use database for WordPress site - how to's?

I have a complex issue to solve, related to database migration. I have a website full of news to migrate that is currently based on a PostgreSQL database and written in PHP, without a CMS. I have a ...
0
votes
1answer
147 views

MySQL PHPMyAdmin Autocommit Off

I have global autocommits off but I was wondering if it were possible to set autocommit on for PHPMyAdmin during login without doing so manually. Turning off autocommit makes the PHPMyAdmin GUI not ...
0
votes
1answer
50 views

Fetching data from 3 tables

Wanna fetch data from 3 tables by mysql query to display in feed. But stack. My query is "SELECT f.leaderId, f.followerId, c.ccId, c.ccTitle, c.ccCity, c.ccCountry, c.ccFlag, c.uId, c.ccStartingDate,...
0
votes
1answer
28 views

Renumbering post ID's

I have been rebuilding my site in a local host environment (Wamp)and have made a number of posts in the new site. I would like to import the database from the online iteration of my site but I am ...
0
votes
1answer
464 views

Cannot use phpmyadmin in XAMPP

I have installed XAMPP 5.5.30 for Linux(64 bit), which consists of phpmyadmin version 4.5.1. For the first time when I went to phpmyadmin, saw a warning at the bottom saying The phpMyAdmin ...
0
votes
1answer
173 views

Error code 1064 when trying to add anything manually

So i tried adding via php and i noticed i got a error , so i went into phpmyadmin and tried adding it manually by clicking the SQL in phpmyadmin and write in INSERT INTO `test`(`IDtest`, `...
0
votes
1answer
124 views

MySQL Circular Replication

I have this scenario where I have 4 MySQL servers (A,B,C,D), as this: Server (A) is always online, and serves as the main website. Servers (B,C and D) are online on random periods of the day, and ...
0
votes
1answer
311 views

How to use explode mysql function in where condition with cakephp

I am using cakephp 2.6. I have payment_method fields in mysql table which store the values like 54,52,59,57 . Now my question is that how can i check if new posted payment method id is available in ...
0
votes
1answer
115 views

MAMP #2002 error

phpmyadmin returns this: #2002 - Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not ...
0
votes
1answer
95 views

Exporting / copying a database with phpMyAdmin

I have a database on a hosting website so I am using phpMyAdmin to experiment with it, before I change anything I would like to make a copy of it or download it and look at it through MS Access or a ...
2
votes
0answers
73 views

Why is our 1000 MB database file not uploading completely via phpMyAdmin?

We have an e-commerce Magento site and a large database of 1000 MB for that site. When we try to import the database through phpMyAdmin, it's not uploading the full databse, a lot of tables will be ...
2
votes
0answers
666 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
2
votes
0answers
301 views

PhpMyAdmin: UploadDir & SaveDir

Regarding UploadDir & SaveDir in phpmyadmin, I have them both set to './save' with permissions at 755. I am the only one using phpmyadmin, but still, could I make this tighter? Thanks PHP 5.3.3 ...
2
votes
0answers
200 views

phpMyAdmin slow for small database

I have a small database (<100 KB when dumped) that will hang in phpMyAdmin when I try to sort by various columns. Sometimes it hangs when I try to edit columns by directly clicking on their ...
2
votes
0answers
219 views

Can't access a specific database from phpMyAdmin

I've installed WAMP on a computer some months ago. Now I'm trying to use it and I was trying to surf the databases using phpMyAdmin. So I went to localhost/phpmyadmin and it showed me the databases. ...
1
vote
0answers
19 views

Mysql InnoDB relations vanish when exporting/importing to online database

My issue is the following : I have a local database running on EasyPhp server : WEB serv : Apache/2.4.7 (Win32) PHP/5.5.8 DB serv : 5.6.15-log - MySQL Community Server (GPL) PHPMYADMIN : version 4.1....
1
vote
0answers
110 views

Connecting PhpMyAdmin to two different MySQL instances on the same host

I currently have running two MySQL instances on my machine, production and development - I can connect to each one using the following: mysql --host=127.0.0.1 --port=3306 -u root -p mysql --host=127....
1
vote
0answers
130 views

phpmyAdmin doesn't display one table's data

Sorry if this sounds like a very basic question but I couldn't find the answer on this site or with web searches. I have a table in my database that have this structure: And these indexes: It ...
1
vote
0answers
30 views

Source dump interrupted by computer restart

I'm have a wamp server installed on my windows machine (apache 2.4.9, mySQL 5.6, php 5.5, PHPmyAdmin 4.1). I was recently performing a source dump operation to restore a tables in a database. ...
1
vote
0answers
50 views

Organizing databases and tables in phpMyAdmin

I have 2 servers, on one server the access6_identical sql file is on the second directory under identical as can be seen here: On the other server, it is on the parent directory as can be seen here:...
1
vote
0answers
491 views

How to display multiple row records of similar ID's in single row?

I have two tables user and work. Work table has multiple user's work experience.I have to retrieve most recent 2 companies on the basis of start date. Conditions : 1.If Work Table has multiple user'...
1
vote
0answers
5k views

Table already exists error when trying to import sql file

I am trying to upload a backup sql file through phpMyAdmin. I create the empty db with the same db name as in my import file in phpMyAdmin then use the import function selected from within this empty ...
1
vote
0answers
203 views

#1046: No database selected in phpMyAdmin

I have a problem with phpMyAdmin. When I click on any database on the left I get an error like: SELECT tracking_active FROM.`pma_tracking` WHERE db_name = 'information_schema' AND table_name = '...
1
vote
0answers
343 views

MySQL Link to PHPMyAdmin/MS Access

I have a mysql database stored on a server via phpmyadmin. I want to link this to MS Access for other users. I often link mysql databases to MS Access which are stored locally, but never DB's stored ...
1
vote
0answers
277 views

phpmyadmin Lock Down

I have a client that wants to use myphpadmin to manage his mysql database 5.x on my server. I found this article on how to hide databases from myphpadmin but I don't like this because if I don't ...
0
votes
0answers
36 views

Error creating foreign key on (check data types)

Very weird problem. I need help, I can't figure out and I don't know how to trace the specific errors in phpmyadmin. I have 2 tables and I want to create FK between them. The first table is keywords:...
0
votes
0answers
29 views

how to remove create relation foreign key in phpmyadmin

I am having problems in PhpMyAdmin Designer Section. I'm not able to do anything like I cant even move them to see their relations. When I try to click on tables the screen shown in picture appear ...
0
votes
0answers
21 views

Is it possible to connect PHPMyadmin to MySQL Server

I'm using MySQL Workbench (Windows 10) to model my database, after it's done and all set up I would like to connect and see it using phpmyadmin. I have more knowledge maintaining stored data using the ...
0
votes
0answers
43 views

Can't see any databases in phpMyAdmin

I'm running EasyPHP Devserver 16.1 on my local machine. I've got my HTTP server running with Apache 2.4.18, PHP 5.6.17 and Database is MySQL 5.7.10. I started the PhpMyAdmin 4.5.3.1 module and added ...
0
votes
0answers
93 views

Select query keep showing “loading” message in phpMyAdmin

This query works fine: select * from prospect p JOIN prospect_company c ON p.prospect_id=c.prospect_id JOIN prospect_address a ON a.prospect_id=c.prospect_id; However, the following query keeps on ...
0
votes
0answers
48 views

MySQL Errror “Cannot Connect Invalid Settings”

I was working with mysql using phpmyadmin on a local server and when I clicked on a table it took a very long time to do anything so I let it do its thing, I walked away and when I came back I had the ...
0
votes
0answers
77 views

Phpmyadmin not displaying table data

I have a table named "log", which basically stores error log for my php application. My application has database running on rds, and recently i had to delete logs from this table, so i downloaded a ...
0
votes
0answers
22 views

Dreadful encoding issue

I've got several Drupal sites, and all their tables are latin1 and collations are latin1_swedish_ci. Recently, I wanted to shrink my ibdata1 so I proceeded to read this answer and I dropped my tables (...
0
votes
0answers
37 views

When create trigger then after error shown in inserting the values

When I create trigger then after error shown in inserting values in phpmyadmin. Code for create trigger as shown below- CREATE DEFINER=`root`@`localhost` TRIGGER `mobile_no` BEFORE INSERT ON `...
0
votes
0answers
34 views

Exporting/importing database with foreign characters

Please help with foreign characters issue i have: On our website we have reviews from foreign languages - German, Spanish, Danish, etc. Lot's of these reviews contain foreign characters - for example ...
0
votes
0answers
90 views

call a stored procedure from sql window in PHPMyAdmin

I have a simple stored procedure that selects rows from a table. In phpMyAdmin, in the list of my procedures, if I click the Execute option, it executes properly, returning the desired rows, and ...
0
votes
0answers
48 views

MySQL: routines removed but still in information_schema

I have a MySQL server with a lot of stored procedures (around 150). When I tried to list the routines with PHPMyAdmin it requires a lot (around 2-3 minutes) in order to load all of them. So I started ...
0
votes
0answers
1k views

Combine and display multiple row data with same column data in MySQL

I have a menu, from where every item ordered is stored in a row. For a single order, there can be multiple rows.What I want is that when I display it, for same order_number ( number) all rows data is ...
0
votes
0answers
777 views

MySQL: #126 - Incorrect key file for table '/tmp/#sql_9dc_1.MYI'; try to repair it

I've been reading possible solutions to this problem but until this time, those solutions don't work with my case. Activity: In phpMyAdmin, the following error pops up while opening a View. Error: #...
0
votes
0answers
425 views

Result of query not showing in phpmyadmin

I have a 500,000 row database that I am running a reasonably complex query on: SELECT yfog, (SELECT AVG(yds) FROM pbp_yards_gained p2 WHERE p2.yfog=p1.yfog AND type = '...
0
votes
0answers
40 views

Trying to import an addressbook

I'm trying to import a .sql-file that I got by converting an .dbf-file. The problem is this line: INSERT INTO address values ('', '', 'Dekanat', '', 'Fachhochschule Hildesheim/Holzminden/Göttingen', ...
0
votes
0answers
30 views

How can i update two tables

On my server, after insert on one table, I want to update two other tables. How can I do this using trigger?
0
votes
0answers
435 views

Error in creating trigger in phpMyAdmin

I have 4 tables: event: event_id(p.k) | uid | circle_id(f.k) activity: uid | performed_activity_id(f.k->event_id) | activity_type_id follow: follower_id | circle_id(f.k) notification: sender_id ...
0
votes
0answers
89 views

Configure phpmyadmin to run on different hosts

Just created locally a new host pointing to a new Virtual Host. And added through command line a new user at the new host. So like 'user1'@'localhost' I now have 'user2'@'local2' . The problem is I ...
-3
votes
0answers
18 views

date wise convert row to column with sum of amount in mysql

i want dynamic table for dynamic date wise with sum of amount....plz help me guys.. Thanks in advance