Category "phpmyadmin"

SELECT * FROM `Languages` WHERE `Google` IS NOT NULL; returns NULL values?

In my mariadb database this query: SELECT * FROM `Languages` WHERE `Google` IS NOT NULL; Returns rows where column "Google" is NULL, which it shouldn´t. A

Connection for controluser as defined in your configuration failed on ubuntu20.04 container

I'm trying to have one docker container with: ubuntu 20.04, on top of which I add apache, php, mysql and phpmyadmin (all on the same container) What's installed

PhpMyAdmin v5.1.3 Export Suddenly Stop Working Chrome Failed - Network Error

Have anyone experienced an issue with phpmyadmin suddenly stop exporting? I am running MariaDB 10.3.28, nginx, Php 8.0.17 on Rocky Linux. I don't know if the re

phpmyadmin : Depends: php-twig (>= 2.9) but 2.6.2-2 is to be installed. WHAT?

I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I

What is wrong with this inner join sql query

I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the cou

PHPMyAdmin not working as intended at remote server. Error 500, $respond not found

I am just starting my journey with servers so I bought one VPN. I installed there ubuntu 18, apache 2.4, php8, webmin, mysql etc. I have two sites based on symf

Error while importing CSV file in database

I try to import a CSV file in my database, I don't have any error but no rows are insert I checked my field name My table structure is: CREATE TABLE IF NOT E

Laravel print last executed SQL query with Query log

DB::enableQueryLog(); $mines = Cranks::where([['crank_id', '=', $this->crank_id], ['mine_id', 'like', '%'.$script_value->mine_id.'%'] ])->get(); $query

phpMyAdmin Database Updates using sql file

I have two machines each with phpmyadmin installed which have a mirror setup - same databases, same tables...and so on. I updated one of these instances with a

xampp Access denied for user 'pma'@'localhost' (using password: NO)

My phpmyadmin used to load but with the following errors. Haven't found a solution for it yet. Please let me know what I can do, thanks for your time and help.

Export Failed - Network error when i exporting from phpmyadmin

Apache/2.4.41 (Ubuntu) PHP version: 8.1.4 Server type: MySQL Server version: 8.0.28-0ubuntu0.20.04.3 - (Ubuntu)

phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

I keep getting the following errors with mysql connection through XAMPP and I don't know what to do: That's the code in the config.inc.php <?php /* * Th

Laravel Sail Docker PHPMyAdmin : SQLSTATE[HY000] [2002] No such file or directory

I have some trouble connecting to PHPMyAdmin. So I always get the following message. SQLSTATE[HY000] [2002] No such file or directory I looked for a solution

definer/invoker of view lack rights to use them

When I import my database all the tables are imported successfully, but when I'm trying to access the "views" then I got the message below on phpmyadmin's scree

Dropped database phpmyadmin

I was deleting some databases from the phpMyAdmin and I dropped the database phpmyadmin. Now that's causing all kinds of problems. Do I have to reinstall phpMyA

How can I change the type of database in phpmyadmin from mariadb to mysql?

I'm using phpmyadmin with xampp on both of my home and work machines. Some queries didn't work for me when I was working on one computer, but it worked on anot

Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

I am using windows 10 command line for a django project using python34 however, I am facing difficulties with SQL. I have already installed mysqlclient using

Missing comma before start of a new alter operation. (near "CHARACTER SET")

Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SE

Table doesn't exist After Creating a Temp Table

Hi I am creating a temp table and insert a record using CREATE TEMPORARY TABLE temp_table_extension_details ( `Id` int NOT NULL,

phpmyadmin exports an .sql file that contains html

I want to export my database from phpMyAdmin to import it to another server. I go through the steps explained here and here but all I get is a 50kb .sql file th