All Questions
Tagged with mysql phpmyadmin
10,765 questions
-5
votes
0
answers
43
views
Why do I have both phpMyAdmin and MySQL Databases in cPanel? I only used phpMyAdmin locally for development. with Real life exmple please
I’ve been using phpMyAdmin locally for developing my project, and I’m now working with cPanel for hosting. I noticed that cPanel provides two tools for managing MySQL databases:
phpMyAdmin – This is a ...
-1
votes
1
answer
35
views
How to set up phpMyAdmin on OS X
I am seeing the error message as shown in the screenshot. I have set up all the parameters as shown below. I am also using the MAMP application in this case.
Apache port: 8888
Nginx port: 8888
MySQL ...
- 9
-3
votes
0
answers
17
views
Error #1054 and #1046 : Import live Wordpress website Database using phpMyAdmin to run locally [duplicate]
I'm trying to manually migrate my live site and run it locally.
I have downloaded the files all through ftp, I have downloaded the DB from my c-panel on my hosting for the live site and I'm trying to ...
- 339
-1
votes
1
answer
33
views
What is the difference between "root" and "dbmasteruser" login in aws lightsail?
I've encountered an issue while working with my AWS Lightsail database. I successfully created a new database named "test" using the root user credentials in phpMyAdmin. However, when I try ...
0
votes
1
answer
211
views
Running on docker-compose: mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'172.26.0.12' (using password: YES)
The configuration below works just fine on my local machine:
My docker-compose.yml file:
networks:
mynet:
name: mynet
driver: bridge
services:
mydb:
container_name: ...
- 27.6k
0
votes
0
answers
31
views
Wampserver: Updating mysql version but used version is still 5.7.19
I have been trying for hours to update my mysql version for wampserver, and i'm stuck in V5.7.19.
Even if localhost/ root show "Mysql version 8.2.0", when I go to localhost/phpmyadmin, login ...
- 1,534
0
votes
0
answers
12
views
phpmyadmin app is unable to connect to mysql in minkube when attaching a persistent volume to mysql data [duplicate]
I have created a 2 node cluster in minikube which should connect phpmyadmin app to mysql database in the pod. My app connects to the mysql database when the permanent volume is not attached through ...
0
votes
0
answers
29
views
USE command not working to select a database [duplicate]
I am using phpmyadmin to run MySQL code via XAMPP.
I run:
CREATE DATABASE d1;
And I see a database named 'd1' is created (visible on left side of my screen).
Now when I run:
USE d1;
I get the message ...
- 13
0
votes
0
answers
17
views
MySQL float does not work for comma-separated decimal values [duplicate]
I have a text file full of comma separated decimal numbers.
When loading the data into a table using
LOAD DATA INFILE ...
it truncates each and every one of them at the comma, and only saves their ...
0
votes
0
answers
22
views
Database created by cli not showing up on phpmyadmin
I created a database using CREATE DATABASE db7. And then I imported a sql file I had using mysql -u root -p db7 < dbsqlfile.sql. The import was successful, however it took some time. I can see the ...
- 681
0
votes
0
answers
54
views
Can't access phpmyadmin on nginx
I am trying to have "/phpmyadmin" on my website. I am using nginx as a reverse proxy, fastapi with guvicorn on the backend, and MySQL. OS: Ubuntu 22.04.4
I can't seem to find any info on how ...
- 303
0
votes
0
answers
24
views
problem in different datatype when using varchar as foreign key in database mysql xampp phpmyadmin
I have primary key subject in table teachers. I want to use subject as primary foreign key in table marks. Subject is varchar(50). And the attribute I want to apply the foreign to it called ...
0
votes
0
answers
52
views
problem the concat isn't working properly in trigger in phpmyadmin mysql database xampp
I want to create new column from concating two columns. So I created a trigger to do that before inserting new row.
ex:
student_type
student_id
student_username
student
1
student_1
the type column ...
0
votes
0
answers
49
views
XAMPP - phpmyadmin will not start any more / MYSQL issue
Please don't notice red messages in pictures. They are not important for specific picture (it's the message of the issue before)
If I try starting XAMPP Apache and MySQL, MySQL will not start under ...
- 43
0
votes
0
answers
47
views
I cannot assign migration to MySql database in C-Panel?
I have no problem when migrating to the MySql database in my locale, but I cannot migrate to the MySql database in C-Panel. After creating the database, I assign a user and set the connection string ...
- 15
0
votes
0
answers
95
views
phpmyadmin database collation issue for utf8mb4
I am using phpmyadmin mysql version 8.0.31
Default Server Connection Collation in phpmyadmin of new server is shown = utf8mb4_unicode_ci
When I download mysql database from old server with mysql v 5.7....
- 2,385
0
votes
0
answers
17
views
Copy mysql db field to another field [duplicate]
I have a database table with thousands of products. Each product have various fields. There is a field (field1) on each product that contain a link, I need that link to be copied to another product ...
0
votes
1
answer
100
views
window.location.href redirects but is causing problems on the webpage
I'm struggling with sessions and need some help. The following is my processing.php file which starts the session and assigns session variables for a user. If the user is a participant, then they are ...
- 59
0
votes
0
answers
30
views
XAMPP already installed on the MacBook, MySQL and phpMyAdmin not starting
When using //Localhost/phpMyAdmin, I get:
Forbidden
You don't have permission to access this resource.
This seenms to be a common error. None of the solutions I found resolved this problem. I ...
0
votes
0
answers
18
views
Can't connect to data base in using PHP in my website [duplicate]
I can't connect to mysql database phpmyadmin
I get following error.
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost'
(using password: NO)
My code is as follows:
try {
$pdo = new ...
0
votes
1
answer
152
views
Find & Replace Many Different URLs in MySQL for WordPress Site
hopefully my headline made some sense.
I need to update URLs in a WordPress MySQL database. I have a spreadsheet of old URLs (around 400) that need to point to new URLs. All old URLs are down column A,...
0
votes
0
answers
28
views
Log in one user at a time - Working with XAMPP MySQL and VB.NET
We're task to create a VB.NET program with a XAMPP-MySQL database that will be networked for several computers using LAN for our project. It will be a role-based system. Each user will show a ...
- 1
-1
votes
1
answer
49
views
Delete rows from a parent table without affecting the condition table
I have a main table and a secondary one. Through a query I connect the secondary with the primary on the left, to filter the results of the primary. PhpMyAdmin disables editing and deleting the ...
- 19
0
votes
0
answers
18
views
1153 - Got a packet bigger than 'max_allowed_packet' bytes - importing a small file [duplicate]
The error message sounds obvious but I'm still having a problem.
Running Wampserver on Windows and importing a .sql dump file that does have some embedded pdf files in it BUT is still only about 6MB ...
- 55
-2
votes
1
answer
43
views
mysql in xampp for php [duplicate]
I am trying to start mysql on xammp control panel, but I am getting this error.
enter image description here
I want to connect phpMyAdmin through xampp. I have tried to uninstall and reinstall xampp ...
0
votes
1
answer
227
views
How do i fix error connection timed out while connecting to remote mysql using node js?
I've been trying to make a connection to mysql db remotley using node js.Everything worked fine before my hosting providers made migration to newer cpanel version(because of installing SSL certificate)...
- 11
0
votes
0
answers
25
views
I have a table in a database in plesk that I think has over 90,000 entries. When I click on browse/refresh it keeps showing different row totals
I have a table in a database in plesk that I think has over 90,000 entries. When I click on browse/refresh in phpMyAdmin it keeps showing different row totals.
One field in the table has a timestamp, ...
0
votes
0
answers
60
views
I installed XAMPP and when clicking My SQL Admin I get this error. I followed all installation processes successfully
This error comes up in the redirected site.
Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\phpMyAdmin\libraries\classes\ErrorHandler.php on line 192
It should redirect me to a ...
- 1
-1
votes
1
answer
52
views
Can someone check my code? It says the foreign key constraint is incorrectly formed
I tried running my code to make the table for my school end year project but it says that the foreign key constraint is incorrectly formed.Also it is in malay because that is the language my school ...
0
votes
0
answers
67
views
Share WHM Mysql Database Between to cpanel
i have WHM Server. where i have multiple c panels and multiple domains.
Cpanel1 is connected to my.domain1.com
Cpanel2 is connected to my.domain2.com
Cpanel3 is connected to my.domain3.com
on Cpanel1 ...
- 6,042
-3
votes
1
answer
74
views
Is there any thing I am missing here? or better way? [duplicate]
I am trying to save Session variable in index.php page and to access in I_detail.php.
The following piece of code working fine.
index.php
<script type="text/javascript">
...
0
votes
1
answer
357
views
Migrating to MySQL 8 calculating the RANK Error
Trying to calculate the RANK of a ticket from the Table, on MySQL 8 getting "You have an error in your SQL syntax", but is working fine on lower MySQL versions. Cannot figure it out, Thank ...
- 73
0
votes
0
answers
41
views
any sql query in phpmyadmin in docker results in #1146 - Table 'DBNAME.columns_priv' doesn't exist
I install phpadmin + mysql using the following docker compose setup:
version: '3'
services:
mysql:
image: mysql:latest
restart: always
environment:
MYSQL_ROOT_PASSWORD: PASSWORD1
...
1
vote
1
answer
273
views
QNAP phpMyAdmin container: "phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection"
In a QNAP NAS, there is a MySQL Docker container with:
IP address: 10.0.3.3
MYSQL_ROOT_PASSWORD: root
Port forwarding: 32774 → 33060/TCP
When creating the phpMyAdmin Docker container, I specified:
...
- 1,735
0
votes
2
answers
57
views
How to prevent decimal values entering in db?
-- Table: Cabin
CREATE TABLE IF NOT EXISTS Cabin (
cabinID BIGINT AUTO_INCREMENT PRIMARY KEY,
cabinType VARCHAR(150) NOT NULL,
cabinDescription VARCHAR(255),
pricePerNight BIGINT NOT NULL,
...
- 11
0
votes
1
answer
45
views
Cannot update or delete a parent row
CREATE DATABASE BOOKMANAGEMENTSYSTEM;
USE BOOKMANAGEMENTSYSTEM;
CREATE TABLE Employee (
emp_id INT PRIMARY KEY,
emp_name VARCHAR(20),
emp_role VARCHAR(30)
);
CREATE TABLE Customer (
cust_id INT ...
user23204223
1
vote
1
answer
41
views
Cannot delete or update a parent row: a foreign key constraint fails delete table
the following are my sql statements:
CREATE DATABASE FOODAPPS;
USE FOODAPPS;
CREATE TABLE Customer (
C_ID INT NOT NULL UNIQUE,
C_NAME VARCHAR(35) NOT NULL,
C_CON ...
user23204223
0
votes
0
answers
25
views
Mysql - #1205 - Lock wait timeout - update of a database's table from another database's table
I have two structurally identical databases but with different data and I am trying to update one based on a shared column (a hash used as reference).
I get the "#1205 - Lock wait timeout" ...
- 103
0
votes
0
answers
21
views
User defined variable in PHPMyAdmin's console not recognized
I'm testing user defined variable directly in PHPMyAdmin's console.
I've observed that if I create:
SET @myVariable = 14;
I execute it, and then try to use it in another query during the same session:...
-2
votes
2
answers
149
views
How to reset myPHPadmin (mySql) password on MYCloud EX2 Ultra (Linux Armada 4.14.22-armada-18.09.3)
I forgot the root password for MySQL server on my MYCloud EX2 Ultra (4.14.22-armada-18.09.3)
When logging in here:
http:///phpMyAdmin/index.php
I get:
mysqli::real_connect(): (HY000/1045): Access ...
- 331
1
vote
1
answer
48
views
Stored Procedure Parameter working incorrectly
I am running an SQL stored procedure with phpMyAdmin. I am using a Netflix 2023 database and running the following procedure.
SELECT Title,Genre,HoursViewed
FROM Netflix2023
WHERE Genre LIKE '%'+@...
- 31
0
votes
0
answers
49
views
Some emojis not showing on PHPMyAdmin
I have a table that needs to display some emojis in the table. You'll see from my first screenshot, it displays the football emoji correctly and the star correctly, but the 🅰️ symbol shows as '?'.
...
0
votes
2
answers
47
views
phpMyAdmin MySQL CSV importing - get a warning if value is not in structure
When importing a CSV file into a MySQL database through phpMyAdmin, is there a way to get a warning if a value is not listed in the "values" list of a ENUM or SET field in the table's ...
- 1,413
0
votes
1
answer
66
views
workbench and phpmyadmin are showing different number of connections
I am running mysql 8.0 on centos 7.4
phpmyadmin and workbench are showing totally different information regarding the number of connections (shown below).
at the sametime this is what I am seeing on ...
- 335
0
votes
1
answer
189
views
phpMyAdmin current user cannot drop views. How do I grant it the correct privileges?
The hosting server recently got replaced due to crash and I now have a issue when trying to drop any database view in phpMyadmin I get the following:
#1227 - Access denied; you need (at least one of) ...
- 951
0
votes
0
answers
68
views
Double update problem all my row data column disappear
I have table in phpmyadmin, I update its row value from a word to a different word. My code line is :
UPDATE database213
SET category = COALESCE((
SELECT GROUP_CONCAT(Category_Name)
FROM ...
0
votes
2
answers
144
views
Mysql query multiple tables and inner join
I have 3 tables and I want to have a query that gives me the sum of the sales, the sum of the deposits and the difference between them, try this but the records are duplicated.
this is my query:
-- ...
2
votes
0
answers
149
views
xampp - extremely slow phpmyadmin via mysql server
I use a macbook PRO with an M1 processor. I downloaded xampp version 8.2.4-0 for OS X users. After installation I started the mysql server and opened "http://localhost/phpmyadmin". The page ...
- 31
0
votes
0
answers
62
views
Mysql server - failing to insert large image file
When I try to insert an image that is 1MB or higher, I get this error
MySQL server has gone away or Fatal error: Allowed memory size of
134217728 bytes exhausted (tried to allocate 14073856 bytes) ...
- 21
0
votes
0
answers
764
views
PHPMYADMIN Failed to read configuration file
I habe following Problem with PHPMYADMIN. I am using it for FiveM and the Web Interface is saying to me, that PHP has Failed to read configuration file. I already tried everythink, but it dont work... ...
- 1