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

0
votes
2answers
7k views

MySQL shutdown unexpectedly

2013-09-09 10:21:44 5776 [Note] Plugin 'FEDERATED' is disabled. 2013-09-09 10:21:44 1624 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future ...
1
vote
1answer
51 views

1054 - Unknown column in subquery

i have 2 table one store data of relation user other buy user path table +-------------+---------------+-------------+ | ancestor_id | descendant_id | lenght | +-------------+---------------+--...
19
votes
3answers
24k views

How can I change the default storage engine in phpmyadmin?

I use InnoDB almost exclusively in my applications. However, if I'm not careful when setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM. Is there a way to change the ...
3
votes
2answers
1k views

Trying to recover/import/transfer database from MySQL data dir

I used phpMyAdmin->export to create a backup of my database but I have now discovered it did not export the whole database, some tables was missed/refused. However at the time of doing the export I ...
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
0answers
13 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....
0
votes
1answer
122 views

MySQL UTF-8 Encoding Problem

I have two MySQL databases that are for Wordpress websites. One db is for a live version of a site, the second is a copy of the original that is used in conjunction with a copy of the original site. ...
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
365 views

xampp php my admin showing loading icon constantly

I am wondering why next to first_db , a loading icon is not disappearing ?
2
votes
1answer
3k views

How to turn Event Scheduler On permanently in MySQL?

How do I turn on the event scheduler in mysqld permanently? I'm using phpMyAdmin and I have scheduled an event to copy records from one table to another everyday at a specific time, but the records ...
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 ...
0
votes
1answer
50 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 ...
1
vote
2answers
201 views

9000 rows affected message, but no rows actually changed

I'm having a problem with MySQL. When I run the code below, via phpmyadmin: UPDATE wp_posts SET post_content = REPLACE ( post_content, '31.media.tumblr.com/', '41....
0
votes
2answers
171 views

Large query with subquery runs indefinitely after mysql update

We recently did a big server update, in the process migrating from mysql-5.0 to 5.5.40 Several of the queries, which had been running well on the old server, now grind everything to a screeching halt. ...
7
votes
2answers
19k views

Server requested authentication method unknown to the client [mysql_old_password]

Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
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
406 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
147 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`, `...
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 ...
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 ...
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
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
1answer
31 views

Why does phpMyAdmin execute all queries with an apostrophe?

For example, if I use the GUI to perform an INSERT, the console will log the following execution: Why does each item have apostrophes (aside from NULL)? I know that I can do a literal INSERT via ...
0
votes
1answer
24 views

What is the significance of phpMyAdmin's configuration storage and what should I know about it?

After initializing phpMyAdmin on my server, I created a test database in the GUI platform. I realized that I had then received a notification in the phpMyAdmin browser that I needed to set up an ...
0
votes
2answers
141 views

SQL Query Help to get Quiz statistics

I'm coding a quiz web application and i need help. I've got three tables Nicknames : |USER_ID|NICKNAME| that stores USER_ID(auto increment) and NICKNAME registered to my system. Questions : |...
2
votes
1answer
1k views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
0
votes
1answer
292 views

Trying to phpMyAdmin import a database with a different name

I've been searching for answers and couldn't find anything suited for my exact situation : I have a magento website and i'm trying to "duplicate" the website into another one selling other types of ...
3
votes
3answers
4k views

How to store mp3 files in MySQL database using phpMyAdmin? [duplicate]

I am new to databases, but I want a database for my site to store mp3 files in it, so later I play them on my site by using jplayer. They say there are two ways to store data (in this case mp3 files)...
1
vote
3answers
4k views

Running an “ORDER BY CASE” query on MySQL view breaks it afterwards

Whenever I create a MySQL view and then run a query ordering the results with ORDER BY CASE WHEN (...), the view becomes unusable. The newly created view works properly and all SQL is correct. This ...
1
vote
1answer
44 views

Cannot open some tables in phpmyadmin

Recently i get backup of my database from host in that backup i get table in .ibd,.frm,.myd format . I placed this files in xampp->mysql->data->test . Now i can open the tables in php myadmin....
2
votes
4answers
5k views

How can I export just the structure of a MySQL database?

I use Ubuntu 14.10 and PhpMyAdmin. I have a 'big' MySQL database, the size is 900MB. I need just the structure of this database, to use it on my local machine. How can I export the structure only?
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
79 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
1answer
73 views

phpmyadmin to SQL Server

I have scripts generated from a MySQL database using phpmyadmin to create database and insert data. The scripts were exported using compatible with MS SQL. Needless to say they are not compatible at ...
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
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 ...
4
votes
1answer
2k views

Stuck outside MySQL / XAMPP

I have been using XAMPP (on Windows XP/XAMPP 1.7.4 /PHP 5.3.5) for quite a while now, and last morning I started to get some weird messages when I was developing my website. It happened yesterday and ...
0
votes
2answers
44 views

Commands out of sync for no apparent reason

I have a simple table and a stored routine to handle phases. CREATE TABLE faza ( numer INT PRIMARY KEY, czasUstawienia DATE )// CREATE FUNCTION obecnaFaza() RETURNS INT NOT DETERMINISTIC BEGIN ...
1
vote
1answer
115 views

MySql Workbench Data Import .csv

Hi I am trying to use to MySql Workbench Data Import facility to import a .csv file (thousands of records). However it stops importing the first 5 records. After studying the .csv file I could see ...
0
votes
2answers
9k views

phpMyAdmin configuration storage is not completely configured message

Today i have updated my PhpMyAdmin to 4.1.2 Now when i log in to PMA i am getting the message: The phpMyAdmin configuration storage is not completely configured, some extended features have been ...
1
vote
1answer
73 views

MySQL query taking too long to execute

My MySQL query is taking around 20 minutes to execute which I feel is excessive. SELECT hyp_id,MAX( player_count ) AS MAXPLAYERCOUNT , MAX( viewer_count ) AS MAXVIEWERCOUNT , SUM( player_count ...
0
votes
0answers
68 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 ...
1
vote
0answers
85 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....
0
votes
3answers
365 views

Deleted MySQL “root” user (using phpMyAdmin)…how to restore?

I'm test-running a Joomla installation (locally, using WAMP) with an MySQL database supporting it...this is in preparation to moving everything online once I have it configured. I was working in ...
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 (...
1
vote
2answers
134 views

Can error 1231 after importing a MySQL database be a compatibility issue?

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL' Query OK, 0 rows affected (0.00 sec) ERROR 1231 (42000): Variable 'collation_connection' can't be set to ...
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
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 `...
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. ...