Questions tagged [phpmyadmin]
phpMyAdmin is an open-source, web-based MySQL administration tool written in PHP. Use this tag for problems related to using this tool and not for general query problems
phpmyadmin
16,339
questions
0
votes
2
answers
33
views
there can be only one auto column and it must be defined as a key
I'm trying to install this 4chan clone: https://github.com/Ro0ul/4Chan-Clone
I'm executing one of the queries on the sql folder on phpmyadmin:
CREATE TABLE comment(
id INT AUTO_INCREMENT,
...
-1
votes
0
answers
34
views
i am getting error while logging into phpMyAdmin [closed]
while trying to logging into my php admin with username: username and password:password, i am getting following error:
error message while logging into phpMyAdmin
my config.inc.php file under /opt/...
0
votes
0
answers
13
views
How do I get @variables in a sql query to stay set when I export the query results to cvs from phpmyadmin?
I'm using phpmyadmin.
I have a query like this
set @months := '36';
select bla, bla, bla
From tables
where date = @months;
Runs great from the sql tab. When the results come up I hit export at the ...
-2
votes
0
answers
27
views
DATABASE PHPMYADMIN AND SENDING EMAIL [closed]
I'm trying to create an ink request form where submitting the form sends an email to the admin, who then confirms the status by sending another email to the requester. However, it appears that storing ...
-1
votes
0
answers
19
views
Getting "unsupported compression" error on importing .ods file to MySql
I am getting this error on uploading ods file to mysql:
" You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your ...
-1
votes
0
answers
18
views
Access denied for user 'dynamicuser@'localhost' (using password: YES) [closed]
I have a new server, running almalinux and whm, and i am getting errors like this mysqli_sql_exception: Access denied for user 'cpses_byb4ftzmt8'@'localhost' (using password: YES) when I try and ...
0
votes
0
answers
23
views
how should i print data to pdf fetched from phpmyadmin in codeigniter 3 view page?
in codeigniter 3 view page i use following ajax to fetch some data from phpmyadmin which consisted of some html data:
$(document).ready(function() {
$('#fetchDataButton').click(function() {
...
0
votes
0
answers
13
views
Column value wrong [duplicate]
I have a big gap from id 50653, it jumps right on 80001, is there any easy way to make them consecutive or do I need to edit them one by one manual ? Someone changed one ID to ID 80000 and now it ...
0
votes
0
answers
110
views
phpMyAdmin import CSV file fails
I am trying to import some data from a CSV file into an existing table in MySql database using phpMyAdmin. I’ve created and saved a CSV file GU_t_rf_imgTp.csv, here it is:
Now in phpMyAdmin I do:
...
0
votes
0
answers
20
views
Need to add substring from colum, column and custom value but returns 0 in SQL (phpMyAdmin)
I need to update the value of a column that should equal to initial from name + last name + "@simuladores"
The name column is called nombre_jefe, the last name column is called apellido_jefe,...
0
votes
0
answers
10
views
Wrong values for SELECT * FROM 'XXX' in 2 different PHPmyadmin Versions
even after several hours of investigation i can't solve a big problem regarding different counts for table rows in PHPmyadmin. The shop on the old server is online, working. Our shop system never ...
0
votes
0
answers
9
views
main panel throwing javascript error on fresh install
Trying to expand the MORE menu item, and getting an error about a javascript function not being found.
Have refreshed the install, and rebooted server multip times, and there is a missing function ...
1
vote
0
answers
28
views
XAMPP and phpMyAdmin configuration on Windows: "Access is Denied" error when resetting folder permissions
I'm facing a critical issue while setting up XAMPP on my Windows machine. Specifically, I'm unable to reset permissions for essential directories such as mysql\data, resulting in repeated "Access ...
0
votes
0
answers
41
views
It seems I stumble upon a code error while i was using phpmyadmin
It seems I encountered a fatal error on my phpmyadmin and I can't seem to find any video on this I hope someone could help me.
Fatal error: Uncaught Error: Call to a member function getDisplay() on
...
0
votes
0
answers
34
views
connecting from localhost Laravel website to Hostinger shared hosting MySQL database is too slow
Connecting from localhost Laravel website to Hostinger shared hosting MySQL database is too slow.. it takes around 20 seconds to load login page. What can be the problem and how to solve it.
I also ...