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
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
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
1 vote
1 answer
1k views

Secure method beside phpMyAdmin for remote mysql

Recently, one of my centos linux servers was hacked and the cause of due to phpMyAdmin. It was said due to this problem PhpMyAdmin vulnerability CVE-2011-2505 (http://www.cve.mitre.org/cgi-bin/cvename....
newbie14's user avatar
  • 969
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
3 votes
5 answers
18k views

You do not have privileges to manipulate with the users!

Error message: You do not have privileges to manipulate with the users! Appears in PhpMyAdmin using Mariadb 10.3.7 on MacOs High Sierra installation from Homebrew I'm logged in as root installed ...
Danny F's user avatar
  • 133
2 votes
4 answers
22k 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 ...
Superion's user avatar
1 vote
1 answer
7k views

mysql trigger / stored procedure - update another table row by row

I've already, searched and read, many answers about this issue for 3 days, but couldn't get a clear answer on how to do this. this will be a little long, be patient please. First of all, I am trying ...
Who Cares's user avatar
  • 187
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
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
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
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
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
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
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
2 votes
1 answer
99 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 ...
BlackBeard's user avatar
2 votes
1 answer
1k views

TokuDB database size unknown in phpmyadmin

In mysql server, I installed the TokuDB storage engine. I converted database engine InnoDB to TokuDB, but my table sizes show unknown in phpmyadmin.
KK Patel's user avatar
  • 151
2 votes
2 answers
3k 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 ...
Mocking's user avatar
  • 131
1 vote
2 answers
905 views

Questions since MySQL Startup

Have a weird question / (bug?) here. Using PHP My Admin I installed via apt-get on Ubuntu 13.10 Versions are as follows: Server version: 5.5.35-0ubuntu0.13.10.2 - (Ubuntu) Apache/2.4.6 (Ubuntu) ...
Anthony S.'s user avatar
1 vote
1 answer
823 views

Update of db yields "Error Code: 1215. Cannot add foreign key constraint"

A phpmyadmin export of a remote MySQL db is used to update a local instance of the db. Disable foreign key checks is selected. Yet running the export either as a phpmyadmin import or as a script in ...
geoB's user avatar
  • 147
0 votes
2 answers
623 views

query to replace text with sequential numbers

I have an images database, the default sort is the "name" column, and the "description" column content is the exact same in all files in the table. what I need is to replace certain text in the "...
Mike's user avatar
  • 105
0 votes
1 answer
2k views

MySQL 5.1.73 to 5.6.17 structure + data export

Are there any known issues to export structure and data from MySQL 5.1.73 to 5.6.17? Nothing fancy and to export-import user will use phpMyAdmin. Thanks
JackTheKnife's user avatar
0 votes
1 answer
272 views

Insert mysql query results into database column with corrensponding ids

I'm trying to store some data from a temporary query into a table, but it doesn't work. Suppose we have the following data Table_A Submission_id Salesman Customer name Hobby Carline Fuel ...
Francesco Marcucci's user avatar