Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

392 questions
55
votes
5 answers

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: Unknown collation utf8mb4_0900_ai_ci Then I went…
Frosty
  • 551
  • 1
  • 4
  • 3
31
votes
6 answers

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 default storage engine?
Kaji
  • 937
  • 1
  • 9
  • 16
25
votes
3 answers

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 phpMyAdmin. Something like a check box to reset the…
BitBug
  • 355
  • 1
  • 5
  • 9
23
votes
5 answers

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 to create said view table ?
Opaldes
  • 341
  • 1
  • 2
  • 6
17
votes
1 answer

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 truncated after 50 characters). If I run it against…
jscar
  • 511
  • 1
  • 3
  • 9
15
votes
3 answers

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 anything.
Somnath Muluk
  • 1,104
  • 3
  • 13
  • 15
12
votes
5 answers

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 syntax to use near '
Fatal error:…
grant tailor
  • 379
  • 2
  • 3
  • 7
11
votes
2 answers

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. UPDATE 'wp_users' SET 'user_pass' =…
Billy
  • 111
  • 1
  • 1
  • 3
10
votes
2 answers

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 client I get the error above while trying to connect…
Chibuzo
  • 265
  • 2
  • 4
  • 9
9
votes
2 answers

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 |…
Chris
  • 193
  • 1
  • 5
9
votes
3 answers

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 Error: Sorry, the server is currently too busy,…
Shashank
  • 387
  • 4
  • 5
  • 15
9
votes
3 answers

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 to log in on the command line (Windows 7), it won't allow me…
Edward Tanguay
  • 191
  • 1
  • 1
  • 6
9
votes
5 answers

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 Description: Subscriber list information Field …
foodil
  • 91
  • 1
  • 1
  • 4
8
votes
4 answers

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
  • 131
  • 2
  • 2
  • 3
7
votes
2 answers

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
  • 997
  • 4
  • 15
  • 18
1
2 3
…
26 27