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.

119 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
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
3 votes
0 answers
407 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. ...
fedejp's user avatar
  • 31
2 votes
0 answers
68 views

how to combine like and between?

i got tables like this: data_transaksi tgl_trans ket sim_wajib what i want to do is showing data from certain dates(tgl_trans) and ket values (values = SW,SS and penyesuian nilai tambah) code ...
Daniel Tan's user avatar
2 votes
1 answer
2k views

Non Super User cannot alter stored procedures and functions

I am running into an issue granted a user access to alter stored procedures and functions within MySQL 5.7.22-0 running on Ubuntu. User has ALL PRIV on the database except GRANT User has SELECT PRIV ...
Shawn's user avatar
  • 21
2 votes
0 answers
2k 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, ...
Ankur's user avatar
  • 121
2 votes
0 answers
441 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 ...
Gaia's user avatar
  • 171
2 votes
0 answers
427 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 content....
physicsmichael's user avatar
1 vote
0 answers
116 views

Auto Increment ID based on 2 columns

I have table called Logs. it has 4 columns ID, USER_ID, USER_TYPE, USER_ACTION where USER_ID is unique USER_TYPE is unique for every USER_ID and USER_ACTION can be anything 1,2,3 or A to Z. USER_ID ...
Zoheb Patel's user avatar
1 vote
0 answers
184 views

How to export MySQL in a format accepted by DigitalOcean database clusters?

I am struggling with importing my databases to Digital Ocean database clusters. They have a setting that requires the primary key to be defined in the CREATE TABLE statement, but all my tools (...
Matt Welander's user avatar
1 vote
1 answer
347 views

phpmyadmin schema dump, how to avoid alter table for key definitions?

When I dump the mysql db schema with phpmyadmin (5.2.0), I would like to get something like this: CREATE TABLE `MEASURE_TABLE` ( `measureID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sensorID` ...
ptrchv's user avatar
  • 11
1 vote
1 answer
15k views

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) - phpmyadmin

I have newly installed MySQL 8 and PhpMyAdmin. I did all the installation steps properly. but once i get login to PhpMyAdmin by root user, it always gives an set of errors at the bottom of page saying ...
rahul shalgar's user avatar
1 vote
0 answers
700 views

Multiple join with self join in MySQL and split column in row

I have four tables "Commission" , "Vendors", "Accounts" and "comsplitconfig" like commission Table commissionid vendorid accountid sales commission 1 V1 A2 ...
S113jerry's user avatar
1 vote
0 answers
5k views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
Nina's user avatar
  • 11
1 vote
0 answers
36 views

How to prevent a record from being affected by the ORDER BY RAND() function?

I am building an online exam site using php and mysql. It's just for MCQ type questions. Here is my database structure: 1) QUESTIONS ( Exam_ID, Questions_ID, Questions_Des) 2) OPTIONS ( Question_ID, ...
BlackBeard's user avatar
1 vote
0 answers
140 views

All columns of all views defined as "1" in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
Alexandre Avrane's user avatar
1 vote
0 answers
364 views

Create a table via an INSERT trigger in MariaDB

I'm trying to make a small database I can use to log changes I make to configuration files on various Linux systems. My thought was have a Database named for the system, and then a table called ...
FreelancerJ's user avatar
1 vote
0 answers
133 views

Weird database icon appears on PHPMyAdmin user interface

On my PHPMyAdmin user interface, I noticed one database which has a strange icon: What does this mean? What causes it? P.S. Note that the database in question functions well (I mean I have no issue ...
Billal Begueradj's user avatar
1 vote
0 answers
186 views

Simple/basic database design problem (with relationships)

It's been years since I've done anything with SQL databases (and I was never more than a novice). I think I've messed something up and I'm not sure how to fix it. I have 3 tables: services (as in ...
QuantiumTech's user avatar
1 vote
0 answers
87 views

Mysql dump is not full

I have installed fresh ubuntu 16.04 with apache2.4 and php7.0 on it and then installed mariadb. Here is version: mysql Ver 15.1 Distrib 10.0.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5....
Alexander Zelenchuk's user avatar
1 vote
1 answer
248 views

Can't set up Unicode support

I am creating a toy website locally with XAMPP and I want it to support Unicode. index.php contains a simple form that I can use to add a new entry (a UTF-8 string) to a table "myTable" in the DB. ...
what a disgrace's user avatar
1 vote
1 answer
80 views

Selecting from all databases from multiple tables

I've got over 2000 databases that may or may not have the same tables, but in the cases where they do, they should have the same type of information. From one table (settings) I'm trying to get the ...
DarrellD's user avatar
1 vote
1 answer
3k views

phpMyAdmin trigger error

The following oddly does work, but shows an error in PhpMyAdmin... (see image below) (in the definition block as seen in the image) BEGIN SET NEW.expiry = DATE_ADD(NOW(), INTERVAL NEW.duration ...
PerryCS's user avatar
  • 111
1 vote
1 answer
85 views

exclusive lock mysql

I want to generate the next enroll_no. It is incremented by group for each institute_id and every new institute has to start enroll_no at 1. When an institute has multiple branches then the problem ...
ravi gupta's user avatar
1 vote
0 answers
60 views

Expand indexes on Structure Tab by default

I am wondering if it is possible to expand the indexes by default by adding something to the config.inc.php file. This is how it looks by default: This is what it looks like when expanded. I want ...
FFirmenich's user avatar
1 vote
0 answers
523 views

mySQL trigger - error when declaring variable

I am using phpMyAdmin and I am trying to declare a variable but it throws an error. Using the following code, it works just fine: IF EXISTS(SELECT * FROM mytable WHERE new.val=old.val) THEN SET ...
treecon's user avatar
  • 131
1 vote
0 answers
2k views

Database design for a multiple choice question website

So I want to design a database schema for MCQ website in which I have several sections ,Lets say 3. and these section will have many sub-sections each. I want to store the questions, choices and ...
sagar bajpayee's user avatar
1 vote
0 answers
168 views

Mysql InnoDB relations vanish when exporting/importing to online database

My issue is the following : I have a local database running on EasyPhp server : WEB server : Apache/2.4.7 (Win32) PHP/5.5.8 DB server : 5.6.15-log - MySQL Community Server (GPL) PHPMYADMIN : version ...
Perceval Dev's user avatar
1 vote
1 answer
2k 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 --host=127....
Matt Clark's user avatar
1 vote
0 answers
2k 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 seems ...
Kiyarash's user avatar
  • 111
1 vote
0 answers
62 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. ...
ADT's user avatar
  • 11
1 vote
0 answers
607 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 here: ...
Sharline Sivanathan's user avatar
1 vote
0 answers
1k 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 user'...
user57443's user avatar
1 vote
0 answers
510 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 = '...
krajol's user avatar
  • 111
1 vote
0 answers
1k 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 ...
user31592's user avatar
1 vote
0 answers
469 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 ...
Frank G.'s user avatar
  • 111
1 vote
1 answer
43 views

Having troubles creating a specific TRIGGER in MySQL

So I am trying to implement a trigger in MySQL that is triggered once a new user is registered. The relation of my tables are: USER_ACCOUNTS has primary key USER_ID. RACE_TRACKS has primary key ...
Panagiotis Delphini's user avatar
1 vote
2 answers
3k 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/', '41....
Adriaan's user avatar
  • 11
0 votes
0 answers
18 views

PhpMyAdmin: How can I modify the hierarchy to show Tables and Views collapsible items?

I'm not sure how to describe this problem. I'm in the process of migrating a database to a new laptop. I installed XAMPP 5.6.20 which includes PHP, MySQL, and PhpMyAdmin. So I exported the SQL ...
Harry McKenzie's user avatar
0 votes
0 answers
8 views

Migrating a web site from shared cPanel to unmanaged Ubuntu 22.04 vps and not able to successfully import an sql file

I got an unmanaged VPS from Hostinger a week ago and am trying to host a few web sites on the server. I have to say here that I am quite new to Ubuntu 22.04 with FASTPANEL. I have migrated the files ...
mgl's user avatar
  • 1
0 votes
1 answer
43 views

Multiple resultset from mariadb procedure

I am trying to return multiple resultsets from (phpmyadmin) mariadb procedure but am failing. For example I have two tables Entities and Relations and for a test I created a procedure to select ...
user1806687's user avatar
0 votes
0 answers
92 views

Unknown Database

I have a very strange issue wth mySQL. Yesterday a Db from a server was disappear. if I log on to phpmyadmin panel i see the DB on the left side menu of phpmyadmin panel but if try to open it (click ...
Andrea_86's user avatar
  • 101
0 votes
0 answers
366 views

Recover a database accidentally deleted in phpmyadmin

I have accidentally deleted a dztabase from phpmyadmin plateforme that had no backup copy anywhere. Is there any solution to bring back this database ?
user avatar
0 votes
0 answers
25 views

Two Database Instances, need to share table data

Background Two sites, both WordPress; one is public-facing, and the second is private with restrictive access. The public-facing site has a form on it, but I need to be able to access the information ...
N. Kendrick's user avatar
0 votes
0 answers
34 views

Access MySQL remotely with terminal and PHPMyAdmin

First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'...
Zep's user avatar
  • 1
0 votes
1 answer
76 views

Replication Slave to Master

I am currently trying to figure out the replication feature for Databases. I am new to this ,as until now I only used databases for simple inserts and selects for webpages. Now I am trying to build a ...
Sam's user avatar
  • 1
0 votes
0 answers
862 views

"The mysqli extension is missing" Tried everything but still no fix!

I recently upgraded to php 8.2.7. Everything was fine until I checked phpmyadmin and got the mysqli extention is missing. I edited the php.ini file in /etc/php/8.2/apache2 directory and added the ...
mani-hash's user avatar
  • 101
0 votes
1 answer
49 views

AUTO_INCREMENT Bug in MySQL

I encountered a very strange bug in MySQL, perhaps it is something which can be fixed easily but I didn't found any solution to this problem. When I insert a new entry in any table, via php on the ...
Sam's user avatar
  • 1
0 votes
0 answers
1k views

Error mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

I'm completely new to MySQL and phpmyadmin. I was trying to add a password to my database/phpmyadmin but then I got this error: mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'...
Rori Putu's user avatar