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

1
vote
2answers
118 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/', ...
3
votes
1answer
938 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 ...
1
vote
1answer
143 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
22 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
123 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
50 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
98 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
239 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
74 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
106 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 ...
0
votes
1answer
66 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 ...
0
votes
1answer
40 views

Putting some calculations on a database entry from phpmyadmin

I am creating an online store website for sale/purchase. I have to put a specific percentage of an amount (User enters) in database. for example If user enters 100. I have to deduct 30% of it and I ...
0
votes
1answer
233 views

xampp php my admin showing loading icon constantly

I am wondering why next to first_db , a loading icon is not disappearing ?
0
votes
1answer
88 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
39 views

Use Oracle on Web App (New Question)

Our database project is about creating a web application where the user can add or edit information. My concern is How do I connect Oracle 11g with my PHP? Note: Our teacher did not teach us about ...
0
votes
1answer
61 views

SQL File Upload to MySQL Server

I'm fairly new to databases. I want to upload a .sql file to a mysql server. However the database I want to update contains many .frm .myi .myd files. Should I delete those files and replace with the ...
0
votes
1answer
53 views

Migrating database with views trough phpMyAdmin causes error in second host

I'm trying to migrate a database which contains some views and I'm doing trough phpMyAdmin export feature. MySQL version on servers are: Server to migrate: Server version: 5.5.34-0ubuntu0.12.04.1 ...
0
votes
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 ...
2
votes
0answers
59 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
577 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
281 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
187 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
210 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
16 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 ...
1
vote
0answers
62 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
26 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
35 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 ...
1
vote
0answers
331 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 ...
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
182 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
297 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
225 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
29 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
26 views

Access a remote mysql from a remote node application

I'm approaching MySQL for the first time in life. I have a machine with a MySQL and Wordpress environment correctly working (let's say at 1.1.3.4) but I want to access it from a remote node.js ...
0
votes
0answers
22 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
30 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, ...
0
votes
0answers
21 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
34 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
25 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
71 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
22 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
35 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
42 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
740 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
339 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
28 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
417 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
86 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 ...