Skip to main content

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
41 votes
5 answers
43k 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: ...
Frosty's user avatar
  • 411
31 votes
5 answers
57k 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 ...
Kaji's user avatar
  • 937
25 votes
3 answers
189k 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 ...
BitBug's user avatar
  • 355
19 votes
5 answers
67k 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 ...
Opaldes's user avatar
  • 301
17 votes
1 answer
11k 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 ...
jscar's user avatar
  • 501
15 votes
3 answers
33k 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 ...
Somnath Muluk's user avatar
12 votes
5 answers
68k 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 ...
grant tailor's user avatar
11 votes
2 answers
22k 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....
Billy's user avatar
  • 111
10 votes
2 answers
40k 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 ...
Chibuzo's user avatar
  • 265
9 votes
3 answers
194k 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 ...
Shashank's user avatar
  • 397
9 votes
5 answers
90k 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 ...
foodil's user avatar
  • 91
9 votes
3 answers
38k 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 ...
Edward Tanguay's user avatar
9 votes
2 answers
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 -...
Chris's user avatar
  • 193
8 votes
4 answers
62k 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
user2106221's user avatar
7 votes
2 answers
24k 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 ?
Mokus's user avatar
  • 1,017
6 votes
1 answer
34k 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 ...
user1930115's user avatar
6 votes
8 answers
197k 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 (...
Mitch Talmadge's user avatar
6 votes
2 answers
3k 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 ...
cecilli0n's user avatar
  • 305
6 votes
5 answers
9k 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....
tarkan dost's user avatar
5 votes
4 answers
22k 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?
nikolr8's user avatar
  • 71
5 votes
2 answers
13k 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.
user2106221's user avatar
5 votes
1 answer
2k 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 ...
Aditya Kumar's user avatar
5 votes
1 answer
18k 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 ...
Hector's user avatar
  • 155
5 votes
5 answers
9k 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`...
user231410's user avatar
5 votes
2 answers
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 ...
Ali Samii's user avatar
  • 171
4 votes
1 answer
7k 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 ...
Ram Babu's user avatar
  • 161
4 votes
2 answers
11k 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 ...
Marshall Banana's user avatar
4 votes
1 answer
15k views

how to retrieve rows of different dates using IN clause

My table structure: +-----------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------...
Shashank's user avatar
  • 397
4 votes
2 answers
7k 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 ...
mohamm's user avatar
  • 41
4 votes
5 answers
62k 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 ...
Al-Amin Khan's user avatar
4 votes
2 answers
2k 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 ...
atxdba's user avatar
  • 5,273
4 votes
1 answer
2k 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-...
user avatar
4 votes
1 answer
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 ...
Ted's user avatar
  • 143
4 votes
1 answer
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 ...
jonboy's user avatar
  • 231
4 votes
1 answer
1k views

Why does PhpMyAdmin put the indexes at the end of a dump?

When I export a MySQL database with Adminer or with mysqldump, it produces a .sql file with each table definition followed by (if the table is non-empty) an INSERT statement (or multiple statements ...
TRiG's user avatar
  • 221
3 votes
3 answers
20k 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 ...
jonboy's user avatar
  • 231
3 votes
1 answer
2k 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 ...
Rowland Shaw's user avatar
3 votes
1 answer
4k 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 ...
Bonxy's user avatar
  • 31
3 votes
1 answer
4k 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....
user3871's user avatar
  • 213
3 votes
2 answers
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 ...
YD8877's user avatar
  • 139
3 votes
2 answers
446 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: ...
Chris Muench's user avatar
3 votes
3 answers
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 ...
AutoJukebox's user avatar
3 votes
1 answer
94 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 ...
rubo77's user avatar
  • 816
3 votes
3 answers
14k views

Not able to access stored procedure from my application

I have written few stored procedures and executed in my server that is having php myadmin now while calling this stored procedure from my application it is showing following exception ...
user2302288's user avatar
3 votes
1 answer
22k 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 ...
cecilli0n's user avatar
  • 305
3 votes
1 answer
3k 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?
Achu's user avatar
  • 131
3 votes
2 answers
5k 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 ...
Ali's user avatar
  • 131
3 votes
2 answers
2k views

#1194 - table 'user' is marked as crashed and should be repaired

I have problems getting into Mysql on phpmyadmin (mysqli_real_connect()(HY000/1130)Host 'localhost'is not allowed to connect to this MariaDB server ) I have found out its a crashed file in mysql ...
Kontractor's user avatar
3 votes
1 answer
689 views

How to store search keyword or browsing history in database [closed]

I'm making my final year project. Which is a website. Things I can't do: Store the browsing history of users between their login and logout session on the site. Or Store the search keywords. But I ...
Shumail ansari's user avatar
3 votes
3 answers
13k views

Error on re-import: #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Using phpMyAdmin, I was getting an error when importing a MySQL dump file to which I'd made a simple global find-and-replace: Error SQL query: /*!40101 SET CHARACTER_SET_CLIENT=@...
Jeremy Carlson's user avatar

1
2 3 4 5
8