MariaDB Database Connector

CentOS 7 and up currently utilizes MariaDB instead of MySQL. This is also true for almost all newer Linux distros. MariaDB was basically a fork of MySQL when Oracle bought out Sun Microsystems and thus inherited MySQL.

Despite Oracle continuing the open source direction with MySQL, the demand for MariaDB soared.

While the old MySQL connectorJ JDBC connector may work, theres a better one to use instead thats designed for MariaDB.

Mariadb connector J

Simply added to tyour class path in your webapp for it to work. However, be sure to remove any other connectors to avoid conflicting libraries.

change Driver from com.mysql.jdbc.Driver to org.mariadb.jdbc.Driver
and connection string jdbc:mysql to jdbc:mariadb

Tips:

  • Do not use 'root' as a username in your database.
  • Connection string db name and username needs to include the prefix_. When you create your db and user, siteworx will display prefix for you to use.
  • Db hostname or IP is almost always localhost. 
  • If all else fails - shoot us a ticket and we'll help. 
  • 20 Users Found This Useful
Was this answer helpful?

Related Articles

PostgreSQL

What Is PostgreSQL? PostgreSQL is pronounced Post-Gres-Q-L, also called just Postgres....

How to Use MySQL

Overview MySQL is a very fast, multi-threaded, multi-user, and robust SQL (Structured Query...

Spring Framework

Need to develop Plain Old JAVA Objects? Want to have fun developing your application? Then we...

Subdomain Handling Tutorial

This tutorial explains how you can host subdomains with JavaPipe's Tomcat hosting. This is...

Pointer Domain Handling Tutorial

This tutorial explains how you can host pointer domains with a Java web hosting package from...