MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH'; GRANT ALL ON mydb.* TO...

Grant privileges on MariaDB

I'm trying to grant privileges for user on MariaDB 10, but I've got an error 1045 [[email protected] ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your...

uninstall mysql completely from linux mint

I have mysql 5.5 installed in my system and i want to install new version ie. mysql 5.7 , so i am struggling to uninstall the older version. when i will try to install 5.7 ,it is installing 5.5....

MariaDB cannot start after update: [Warning] Can't create test file /home/mysql/beta.lower-test

I've just updated MariaDB using apt-get dist-upgrade. Now it won't start using service mysql start anymore. I can however, run it as root or do: sudo -u mysql mysqld_safe then MariaDB starts up...

No suitable driver found for jdbc:mariadb (Netbeans)

I'm using the mariadb-java-client-1.5.7.jar connector for MariaDB, and it does not work. Here's the connection code: public DataAccess() throws SQLException, ClassNotFoundException { ...

Select max() of every value mariaDB

I have a table that looks like this: name price class a 10 x a 20 y a 15 z b 40 y b 35 z c 5 x c 10 y c 15 z c ...

ERROR 13 (HY000): Can't get stat of '/tmp/file1.csv' (Errcode: 2) while trying to import CSV file into MariaDB

I am trying to import CSV file into MariaDB (version: 5.5.50-MariaDB MariaDB Server), using this command: LOAD DATA INFILE 'file1.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES...

Mariadb columnstore autoincrement not working

I'm trying to use Mariadb columnstore, but I'm having some errors when inserting data in a table with a autoincrement column defined. The issue happens when using the JDBC driver. CREATE TABLE...

Laravel 5.5 Error Base table or view already exists: 1050 Table 'users' already exists

Specifications: Laravel Version: 5.5.3 PHP Version: 7.1 Database Driver & Version: MariaDB 10.1.26 Description: C:/Users/user/code/blog/>php artisan...

mariadb JSON_UNQUOTE get's ignored on special characters

I'm using MariaDB 10.2.7 to select a value from a JSON document. After investigating a bit i red that i have to extract and unquote the results. But now i encounter the following issue when using...

Heroku JawsDB max user connection

I am trying to use the JawsDB Maria with spring boot application on Heroku. I always got the error when trying to create the connection, not only the program but also the sql browser. The error as...

Hibernate has difficult with create table using MySQL

I'm doing a school project in architecture client-server with JavaFX, Maven, Hibernate etc I have big problem with implementation alone Hibernate (without Spring). Im not sure that is problem...

Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin

I've just downloaded phpMyAdmin 4.8.1 via composer on my local machine (windows) after installing my lamp stack apache 2.4, php 7.2, mariadb 10.3, but when I login using root (without password) it...

phpmyadmin A symbol name was expected! (near ")" at position 312)

I exported this code from phpmyadmin for another database that I used, I've no idea why I can't use it again error free. -- phpMyAdmin SQL Dump -- version 4.8.1 --...

Kubernetes Pod Warning: 1 node(s) had volume node affinity conflict

I try to set up Kubernetes cluster. I have Persistent Volume, Persistent Volume Claim and Storage class all set-up and running but when I wan to create pod from deployment, pod is created but it...

How to rename a column name in maria DB

I am new to SQL, I was trying to change column name in my database's table. I am using 'xampp' with 'maria DB' (OS - Ubuntu 18.04) I tried all of the followings: ALTER TABLE subject RENAME COLUMN...

The requested PHP extension ext-mysqli * is missing on php 7.2 on ubuntu 16.04

when I composer create-project phpmyadmin/phpmyadmin I got the problems: - The requested PHP extension ext-mysqli * is missing from your system. Install or enable PHP's mysqli extension. I had...

Debian 10 MariaDB 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Good evening Community, I am in despair because I cannot install MariaDB on Debian10. There are similar Stackoverflow questions but none of them helped to solve my problem. What I've tried: $ sudo...

mysqldump: Error 1412: Table definition has changed, please retry transaction

I run a web application on a shared LiteSpeed server with Mariadb version 10.3.22. I do have access to a terminal. Cron is set up to perform a daily mysqldump, but I now get the error...

Ansible Playbook Error Handling Problem [need explanation]

Today I'm learning Ansible with labs and I'm stuck with understanding something related to errors handling. This is my playbook : --- - hosts: db become: yes vars: web_package: http ...

pgAdmin4: How do I edit the SELECT query generated by "View/Edit Data > All Rows"?

I recently migrated from MariaDB and there was a useful shortcut to construct a query in MySQL Workbench - you would right click the table and select "Select rows - Limit 1000". pgAdmin4 has an...

"The given key 'utf8mb4' was not present in the dictionary

i have a problem with sql in C#. I try to use ExecuteReader(), i get an error in this line: MySqlDataReader reader = readcmdQuery.ExecuteReader(); System.Collections.Generic.KeyNotFoundException ...

MySQL JSON_SEARCH for multiple arguments of nested objects

I have a db-table containing json formated strings: CREATE TABLE `template` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `TemplateData` longtext NOT NULL, PRIMARY KEY (`Id`) ); INSERT...

Error trying to connect Power BI Desktop with MariaDB running on Docker CentOS 7

I was trying to make the connection but Power BI shows this error: "The 'Driver' property with value '{MariaDB ODBC 3.1 Driver}' doesn't correspond to an installed ODBC driver." I've been...

"Illegal mix of collations" error with stock install of phpMyAdmin

Problem I have a stock install of Debian 11 (testing) with a brand new install of MariaDB (10.5.9-MariaDB-1), phpMyAdmin (5.0.4deb2) and Lighttpd (1.4.59). After adding a user and logging in,...

Setting UTF-8 in MariaDB server ignores character_set_system

I have the following Dockerfile definition file for a MariaDB server: version: "3.8" ... services: database: command: ["mysqld", "--character-set-server=utf8mb4",...

DBeaver export to csv: "No database selected"

select * from users u where u.id < 1000 When I right-click to script, and export I get no database selected error. When I add "use db" command at above,I get a syntax error. use db select * from...

Is it possible to get MariaDB4J to work on an M1 Mac?

I'm trying to get MariaDB4J working on my new M1 MacBook Pro, and I'm not doing so great. I am running the Arm versions of both [email protected] and mariadb 10.6.4, both installed with Homebrew. First I...

.net Core 6 - Unable to resolve service for type while attempting to activate

In my ASP.NET Core application, I get the following error: InvalidOperationException: Unable to resolve service for type 'mvc_net6.Service.DB_Context' while attempting to...

Mariadb - Getting "Field 'xxx' doesn't have a default value" error even though there is no null values for the Field

When I run replace query then I get "Field 'xxx' doesn't have a default value" The replace query has select query. so I ran the select query to find which row has the null value.. but all rows in...

Relevant tags