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
31
votes
4answers
48k 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 ...
23
votes
3answers
154k views

How can I reset a mysql table auto-increment to 1 in phpMyAdmin?

I know that in MySQL at the command line I can reset a table's auto-increment field to 1 with this: ALTER TABLE tablename AUTO_INCREMENT = 1 I am curious if there is a way to do this from within ...
13
votes
2answers
27k views

How to export mysql database based on a where condition

I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20). How to export mysql database based on a where condition from phpMyAdmin or ...
12
votes
5answers
67k views

importing large SQL file phpmyadmin

I am trying to import this SQL file in phpmyadmin and got this message #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
11
votes
2answers
20k views

Running SQL Query on all databases

I have one hosting account using cPanel and phpmyadmin. I have 50 databases under this account, all WordPress. I need this query modified so that it runs through all databases to update the password....
10
votes
5answers
38k views

How to retrieve the query I used to create a view?

for my company I created a view which is used for exporting. Maybe there is a problem with the query that is used to create this table. So here is my question: Is it possible to get the query I used ...
9
votes
3answers
187k views

How to resolve too many connections and fatal error in mysql running on vps

I am running an application PHPlist on my linode server, simultaneously running 12 PHP scripts, each of which opens a MySQL connection. Now when I access PHPlist it often shows this error: Fatal ...
9
votes
4answers
78k views

How to display database structure in phpMyAdmin?

Is there any way to generate a report of my database structure using phpMyAdmin? What I would like is a table format like the following, and an Entity Relationship table. Table name: List ...
9
votes
3answers
36k views

Why can't this mysql user log in with password?

In phpmyadmin I created a user called "edward" with password and all privileges: Yet when I try to log in via phpmyadmin, it says "Cannot log in to the MySQL Server". When I try ...
9
votes
2answers
8k views

Is this a normal set of MySQL privileges?

Using phpmyadmin on a local test wamp setup, and well as pretty much the title states, there are 3 users marked as user = ANY, password = NO, such as: USER | HOST | Password | Global Priv | Grant -...
8
votes
2answers
39k 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 ...
7
votes
1answer
7k views

Output getting truncated in phpMyAdmin

I am writing a drop statement (in phpMyAdmin) to get rid of some unneeded tables in my database. If I run this query against our live database I am not seeing the full drop statement (it is getting ...
7
votes
2answers
23k views

MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench

I just setup the phpMyAdmin and I have this problem: When I login, I can't see any tables. I had tried this with MySQLWorkbench and I got the same result. Any suggestions ?
6
votes
4answers
50k views

How to use 2 auto increment columns in MySQL phpmyadmin

Is it possible to use 2 auto increment values ? One starting from 0 Another starting from 4000400 Please help me
6
votes
1answer
30k 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 ...
6
votes
2answers
2k 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 ...
6
votes
5answers
8k views

There is no export as SQL option

As CMS I use Wordpress. I want to export a whole category (windows 8) so I run the SQL command : SELECT * FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships....
6
votes
0answers
4k views

mysql to mariadb: unknown collation utf8mb4_0900_ai_ci

I have a mysql 8.0 that I exported using mysqldump. I am trying to import it onto a Mariadb 10.4 database with phpmyadmin, both are the most current versions. Each time I do it though, I get: Error: ...
5
votes
1answer
1k views

MySQL: Delete a record from all tables in one shot

I have a MySQL database, with one table that has a primary key, f_id that is referenced in multiple table as a foreign key. I want to delete all records where f_id is a specific value from all ...
5
votes
5answers
5k views

Fast way of delete MySQL record

I have a 1.2 million record in a database table( it use index column also) I want to delete old 1 million record. I try to do it using PhpMyadmin but it take more time. DELETE FROM `table` WHERE `id`...
5
votes
2answers
3k views

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3 [closed]

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither ...
4
votes
1answer
14k views

how to retrieve rows of different dates using IN clause

My table structure: +-----------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------...
4
votes
6answers
140k views

“Table doesn't exist in engine” after moving tables from one VPS to another

I have two VPS's running right now. One, which I will refer to as the "old" server, runs on Debian 7 and gives this output for mysql --version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (...
4
votes
2answers
1k views

PHPMyAdmin for multiple servers w/ single pma database

We have PHPMyAdmin setup for our various MySQL instances. The annoying part is the current setup is requiring an individual pma database on each instance. Because of this the severs that are slaves ...
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-...
4
votes
1answer
3k 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 ...
4
votes
1answer
5k 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 ...
3
votes
1answer
1k views

How can I get MySQL to use the value returned by a function as a default?

I have a pre-existing table that has a column to that can hold a UUID. I'd like to be able to define a default such that new rows coming in (from legacy systems) will still get a UUID defined, via ...
3
votes
2answers
7k views

What is the difference between using varchar(100) and varchar(255)?

I want to know difference between varchar(100) and varchar(255) in terms of memory usage and programming problems of using more memory.
3
votes
1answer
11k views

DB Restart Taking too long, site is down

I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing. What can I do? I can still access the server via SSH but I cannot connect to ...
3
votes
4answers
59k views

How could I connect to MySQL database running on WAMP server from other computers in same LAN?

I'm new in web development. I'm requesting help from all of you. My problem is: I installed WAMP server in my desktop computer. My desktop computer has a static LAN IP (192.168.0.101). I'm able to ...
3
votes
1answer
2k views

“zip” a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: 5.3....
3
votes
2answers
1k views

Exporting table from MySQL 5.7 to MySQL 5.6 (Error)

While running the following queries on MySQL 5.6.39, DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(10) UNSIGNED ...
3
votes
2answers
5k views

checking availability of rooms

I have 3 table in my sql database: Table Room roomnumber roomtype 1 DeluxeRoom 2 DeluxeRoom 3 DeluxeRoom 100 StandardRoom ...
3
votes
2answers
348 views

optimize table in stored produce using phpMyAdmin causes out of sync error

I get the following error when running the code in phpMyAdmin. NOTE: I can run any other sql code (update, insert, replace) via phpMyAdmin in a stored procedure; but an optimize causes issues. NOTE: ...
3
votes
3answers
3k views

All My Databases Are Gone?

Today I changed my username and password in MySQL and I logged into phpmyadmin to see that all my databases were gone. I've tried changing the datapath but then I realized I didn't see any of my ...
3
votes
1answer
91 views

How identify tables with millions of entries

On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
3
votes
1answer
2k 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?
3
votes
2answers
4k views

PhpMyAdmin Missing parameter

Everything was working fine until this moment I want to create a new database and I'm receiving this error db_create.php: Missing parameter: new_db (FAQ 2.8) Also when I was trying to export my ...
3
votes
3answers
22k 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)...
3
votes
0answers
17k 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 ...
3
votes
0answers
320 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. ...
2
votes
1answer
6k views

What is the difference between MySQL and PostgreSQL in terms of writing SQL queries? [closed]

Other than performance and security is there really any difference between MySQL and Postgres like SQL queries, built-in functions, procedures and so on? I'm asking this because I'm familiar with PHP ...
2
votes
3answers
14k views

Foreign Keys and Data Import

I have: a CSV file (5000+ records); an empty item table; am empty favourite table; a number of other empty tables. I would like to populate the item table with the contents of the CSV file. Then I ...
2
votes
2answers
5k views

“Error creating foreign key (check data types)…” but they do match…

I'm getting the following error trying to create a constraint: Error creating foreign key (check data types) Problem is… those column data types do match. The target is an int(10) unsigned NOT ...
2
votes
2answers
1k views

What exactly do database passwords protect?

I would like to know what exactly I am password protecting on my server when I set a database password. I am unclear as to what people are referring to when saying to password protect a database. Are ...
2
votes
1answer
86 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 ...
2
votes
1answer
2k views

Why is ON DUPLICATE KEY not working as expected?

Before I start, I'm not a web developer by trade. I'm self taught using google and StackOverflow. So I recently moved my site from a shared hosting to a VPS. My provider moved my site / files over ...
2
votes
4answers
15k 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?
2
votes
2answers
84 views

Delete all highscores from a certain country

I have two tables: tbl_players tbl_highscores I need to delete all highscores that are registered from a certain country. My problem is that the language are set per player, rather than by highscore....

1
2 3 4 5
7