10 posts
Sometimes you can't install MariaDB with apt/yum, or you want every node in a database cluster running exactly the same MariaDB version. My motivation this time was building a MariaDB cluster with identical versions across nodes for easier management.
Newer DBeaver versions no longer support ODBC connections, probably because the JDBC-ODBC bridge was removed from Java 8. So the old tutorials telling you to use ODBC no longer work. Here's the correct way to connect DBeaver to DaMeng.
MariaDB/MySQL is case-sensitive on Linux, so any mismatch in capitalization between your table or column names and your SQL throws errors. That's why we usually turn case sensitivity off first.
In SQL, the LIKE operator searches for a specified pattern in a column inside a WHERE clause. It's a very common way to query in practice, and most people only use the % wildcard — but several other patterns are supported too.
After upgrading to a newer Druid, the logs kept throwing errors: discard long time none received connection., jdbcUrl: blah blah. The program ran fine, but staring at a wall of errors is unbearable, so I went into their source to see what was actually going on.
Navicat Premium merges all Navicat versions into one ultimate version, able to connect to MySQL, Oracle, and PostgreSQL. Navicat Premium lets users drag tables and data from Oracle to MySQL, Postgre...
Dash is an API documentation browser and code snippet manager. Dash helps you store snippets of code, and instantly search and browse docs for almost any API you might use.
Navicat Premium merges all Navicat versions into one ultimate version that can connect to MySQL, Oracle, and PostgreSQL. Navicat Premium lets users drag and drop tables and data from Oracle to MySQL, from PostgreSQL to MySQL, and from Oracle to PostgreSQL within a single client, and vice versa. In addition, batch jobs for different databases (such as printing reports in MySQL, backing up data in Oracle, and syncing data in PostgreSQL) can be scheduled and run automatically at specific times.
Navicat Premium merges all Navicat versions into one ultimate version that can connect to MySQL, Oracle, and PostgreSQL. Navicat Premium lets users drag and drop tables and data from Oracle to MySQL, from PostgreSQL to MySQL, and from Oracle to PostgreSQL within a single client, and vice versa. In addition, batch jobs for different databases (such as printing reports in MySQL, backing up data in Oracle, and syncing data in PostgreSQL) can be scheduled and run automatically at specific times.
I ran into this problem while deploying a project at a client's environment. The project's MySQL connection string was localhost, but it errored out saying the database couldn't be connected, and the connection string had been replaced with 127.0.0.1. At first I thought it was a network connectivity issue, so I ran mysql -u root -p and found I could connect fine; ping localhost also resolved to 127.0.0.1. I suspected a mismatched MySQL JDBC driver and swapped countless driver jars, but I was sure it wasn't my program, so I started Googling and found many people with the same situation. I'm summarizing it here for reference. The type of problem I hit was a permissions issue.
