Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

-1
votes
1answer
29 views

Load a database into a host or in place to which I can access from different applications [on hold]

I've just started working with databases. I create them and modify them using Python as a means to create dinamically a good amount of data. Moreover all the applications that I develop are written ...
-2
votes
1answer
21 views

Where I can see phpMyAdmin release/schedule dates? [closed]

I've tried, but failed to find the source, where I can see the schedule of phpMyAdmin release dates. For example, on official site, it's 4.8.4 version, however, 5.0 version is on github. Where I can ...
0
votes
2answers
28 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 "...
-1
votes
0answers
20 views

Data in MySQL is changed, any way to find what happened?

I have a two tables: Customers Sales (has a "customer_id" foreign key) On the saturday, I saw that all sales in the past has a same customer ID and only who has access to the DB were my worker and ...
1
vote
0answers
15 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 ...
1
vote
0answers
14 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 ...
-1
votes
1answer
24 views

phpMyAdmin 4.8 vs 5.0 comparison

doc says that since release 5.0, only php 7.1 and later are supported. Can you tell me, where I can viw & compare features among phpMyAdmin versions? why v5.0 is so special that it can't be run on ...
0
votes
1answer
22 views

Auto update “TIMESTAMP” column only when a manual phpmyadmin edit occurs?

I have a column in my MySQL database that uses a "TIMESTAMP" to capture the current time. I have an attribute set to "on update CURRENT_TIMESTAMP" so it auto updates the column whenever and update ...
0
votes
2answers
30 views

Replace some rows in one table with rows of another table

I have two tables and a set of primary key values. I want to replace all rows of the first table whose primary keys are in this set with the corresponding (having the same primary key) rows of the ...
0
votes
1answer
13 views

#1146 table 'db.tablename' doesnt exist

I use AMPPS for localhost server purpose. I was working on one of my client site on localhost. When I start working the other day, it suddenly start giving me such error table does not exist Even ...
0
votes
0answers
18 views

SHOW CREATE TABLE <tablename> not showing foreighn key name

I wanted to drop the foreighn key ,so i followed link & tried to find foreighn key constraint by below query : SHOW CREATE TABLE ecomexpress_awb; but it gave below result, its not showing ...
1
vote
1answer
31 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 ...
1
vote
2answers
47 views

Mysql optimization edit my.cnf

Firstly, I am a beginner. I have a server, which has 32 GB RAM and 16 CPUs. I am working on MySQL optimization, but I have a problem. I am trying to set the InnoDB buffer pool instances = 8. But it'...
-1
votes
1answer
42 views

Inserting data into a 3NF database [closed]

I have 6 tables with ~2-15 attributes each, each one of these 6 tables has an ID which is constrained from another table. This 7th table has its own ID and the 6 other table ID's, as well as a date ...
0
votes
1answer
24 views

Does phpMyAdmin only works with HTTPS?

I have manually setup phpMyAdmin (downloaded from official site) on my site. However, when I enter my User&Pass in login page, i get warning: When i try same page with HTTPS, it logins. Any idea ...
1
vote
1answer
115 views

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1 Query 1: SELECT * FROM table Number of records : 103 Load time : 0.0005 sec Query 2: SELECT * FROM table ...
1
vote
1answer
33 views

Fetch ids(Primary Key) from table where ids not available in table within range

I have table named Student. It have primary key student_id which is auto increment and not null. Now Student contains around 5000 records. After passed out from university, we need to delete ...
0
votes
2answers
42 views

Update from PHP 5 to PHP 7.0 - PHPmyAdmin will show two server logins: localhost / localhost:3306

I updated my Linux 14.04 LTS to 18.04 and had to downgrade the PHP 7.2 to 7.0 as I need to run some software which is not capable of the preinstalled PHP 7.2. I used PHP 5 so far. After I got ...
1
vote
0answers
36 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 ...
0
votes
2answers
43 views

phpmyadmin/ mysql how to copy a table with all its constraints

I tried to copy a table which is connected to another table through a foreign key using $query = "CREATE TABLE table1 AS SELECT * FROM table 2"; but when I run this query it copies every thing but ...
0
votes
1answer
360 views

Unable to read master log position while setting up MySQL slave

Hi I am trying to setup a data replication server. I am using MariaDB and phpMyAdmin to interface with the 2 DB's I have set up my master with adding the following configuration to my my.ini file ...
1
vote
1answer
103 views

How to open a file in MySQL event scheduler?

I am currently creating my first event in MySQL: CREATE EVENT check_for_uploads ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE ON COMPLETION PRESERVE DO // I would like to open a .php file ...
0
votes
1answer
169 views

Update value in table based on condition in other table with trigger

I have 2 tables, first stores the details of all the races 1: and second the users who have joined which races 2: I want to update the race_status to Full and record_status to 2 in race table, if ...
1
vote
1answer
404 views

Can't connect to a remote server using phpMyAdmin

I tried with two different servers, one had no issue but the other gave me this error: MySQL said: Cannot connect: invalid settings. mysqli_real_connect(): The server requested ...
0
votes
0answers
31 views

phpmyadmin keeps telling me that NEWID() doesn't exist as a function?

I was trying to use the newID() function to generate a newid(). I was trying to use this query `UPDATE `user_data` SET `uniqueID` = newid() WHERE `shortid` = 1` I tried writing with newid() in ...
1
vote
1answer
749 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 ...
1
vote
0answers
52 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....
0
votes
1answer
363 views

How to execute dependent multiple SQL queries from multiple databases via same PHP web page?

We can connect a single PHP page with more than one databases. But what about executing multiple dependent queries that belong to different databases? mysqli_multi_query(connection,query); does not ...
0
votes
1answer
204 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 ...
3
votes
2answers
146 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 ...
2
votes
1answer
623 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 ...
1
vote
1answer
31 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. ...
0
votes
1answer
11 views

php single table language separated autoincrements?

I have 1 table for posts. And my columns are Id | id_language | lang I want to achieve, that there is a second autoincrement id for its language. For example the 80.post is the 5.post written in ...
0
votes
0answers
78 views

Sql query issues in cake php

If I run this query in mysql - then its run I just want to show all record in payment table who's booking_status = 0 then it does not run in web page whats wrong with this query - SELECT `...
0
votes
0answers
230 views

Some foreign keys and tables not displaying in phpMyAdmin

I have a small database (9 tables, 17 fields) that I was trying to build using phpMyAdmin. When I go into the designer view for my database, many of the foreign key constraints are missing from the ...
-2
votes
1answer
47 views

I want to make a database where an ID can have multiple records [closed]

I am currently making an inmate information system in which the admin can insert multiple visitations records for a certain prisoner This what my prisoner table looks like Visitations table: I want ...
0
votes
1answer
38 views

Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?

I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider. For some reason this other ...
1
vote
1answer
217 views

Error 1215: Can't find how to solve it

I'm currently building a database and adding my foreign keys constraint on phpMyAdmin but I'm struggling with one of them. Indeed, I've looked on the internet for many possible solutions but any of ...
1
vote
2answers
620 views

Auto_Increment After deleted data from the table [duplicate]

How can I reset the auto_increment of a field? I want it to start counting from 1 again after I delete all the data.
0
votes
0answers
26 views

Website taking 30+ seconds to load on remote DB connection

So I recently set up a remote mysql connection where it connects my website hosted on a web hosting service to my VPS server that accesses the DB and game server. When I go on my the website which is ...
0
votes
0answers
30 views

MySQL 5.7 Memory problems

I have an issue with MySQL..I just upgraded from 5.6 to 5.7 .I used thesame Global Buffers and Thread Buffers(Memory) settings on 5.7 with thesame number of databases..but i am having memory problems....
1
vote
1answer
52 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 ...
0
votes
0answers
483 views

PHP+Mysqli Auto Increment after deleting a row in a user-interface table

** I have a table with add edit delete, if I delete one row,(example I deleted an 8th row, after refresh it should show me 8,9, and not 7,9)in middle, automatically it should change to next value. **...
0
votes
1answer
66 views

Exporting an Excel Spreadsheet containing a pivot table and charts to MySQL

I am looking at moving a large Excel spreadsheet to an SQL database - most likely MySQL. The excel spreadsheet contains 12 worksheets, with one of them being the Master, and the other 11 set up to ...
0
votes
0answers
351 views

3 nodes Master-Master Mysql replication sync problem

I have 1 haproxy server with roundrobin method that distribute multiple connections between 3 dedicated Centos servers that running as webserver and Master-Master Mysql replication I followed method ...
0
votes
0answers
21 views

Feedback for db design

I just want a quick feedback from you about the design of my database. I don't know that much about db and hope you can give some hints of a better structure, so my queries would be optimized. My ...
0
votes
1answer
464 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 ...
0
votes
2answers
830 views

MySQL upgrade (5.5 to 5.7)

I upgraded my MySQL version from 5.5 to 5.7 and in phpmyadmin I get this error message. I tried to reinstall and reconfigure it but I have still this problem. Can you help me? I am using Linux Mint. ...
0
votes
0answers
22 views

Include_Path Complications Using XAMPP

I'm creating a login system for a website using php. I have finished the code, but whenever I must include() a php file the code runs into the error: Warning: include(db.php): failed to open stream: ...
0
votes
2answers
1k 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 ...