mariadb
Spring is losing connection to the DB and does not recover or reconnect
Per a senior member in the Spring forums, the Spring DataSource is not intended for production use: The above answers are only part of the solution. Indeed you need proper transaction managent AND you need a connection pool. The DriverManagerDataSource is NOT meant for production, it opens and closes a datebase connection each time it … Read more
mysql_config not found when installing mysqldb python interface for mariadb 10 Ubuntu 13.10
For Centos 7.0 install the following: yum install mariadb-devel For Fedora 23+: dnf install mariadb-devel
Database corruption with MariaDB : Table doesn’t exist in engine
Something has deleted your ibdata1 file where InnoDB keeps the dictionary. Definitely it’s not MySQL who does
What is the MariaDB dialect class name for Hibernate?
Very short answer The current dialects as of this writing are: org.hibernate.dialect.MariaDB102Dialect for MariaDB server 10.2 org.hibernate.dialect.MariaDB103Dialect for MariaDB server 10.3 and later, provides sequence support. org.hibernate.dialect.MariaDB10Dialect for MariaDB server 10.0 and 10.1 org.hibernate.dialect.MariaDB53Dialect for MariaDB server 5.3, and later 5.x versions. org.hibernate.dialect.MariaDBDialect for MariaDB server 5.1 and 5.2. Short answer When using a MariaDB … Read more
How to rename a column name in maria DB
Table names, column names, etc, may need quoting with backticks, but not with apostrophes (‘) or double quotes (“). ALTER TABLE subject CHANGE COLUMN `course_number` — old name; notice optional backticks course_id — new name varchar(255); — must include all the datatype info
Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?
On MySQL table you have a column called plugin: MariaDB [(none)]> SELECT host, user, password, plugin FROM mysql.user LIMIT 0,1; +———–+——+——————————————-+——–+ | host | user | password | plugin | +———–+——+——————————————-+——–+ | localhost | root | * | | +———–+——+——————————————-+——–+ 1 row in set (0.00 sec) If I remember correctly the default plugin for mariaDB … Read more