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
21 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
205 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
51 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
134 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
49 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
415 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
151 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
122 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
297 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
106 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
93 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
71 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
654 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
199 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
218 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
15 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
89 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
121 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
48 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
474 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
4k 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
198 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
340 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
276 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
26 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
20 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
81 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
46 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
69 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
36 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
88 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
28 views

how to find and replace text in phpmyadmin

We are migrating from one domain to another domain. Usually we will follow the procedure of open the database file in notepad++ software and find and replace old-domain-name to new-domain-name. But as ...
0
votes
0answers
38 views

Having MAMP #2002 error - no google or answer here has helped - any other suggestions?

phpmyadmin returns: 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 correctly ...
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
771 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
416 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
39 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
434 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
14 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