Forgot MariaDB Password – Fix: sudo mariadb -u root

Forgot your MariaDB password? Luckily, you don’t need password for administrative access. $ sudo mariadb -u root

Posted in Uncategorized | Tagged , , , , | Comments Off on Forgot MariaDB Password – Fix: sudo mariadb -u root

Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

MySQL/MariaDB is probably the most popular multi-user database in the world. Since Ubuntu 18.04, you should install mariadb-* packages to use this database.

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

Initial Testing and Tries on MySQL Socket Authentication

MySQL has some initial support for passwordless socket authentication, but based on by very brief and initial testing, it does not seem to be ready for prime time yet. If you want socket authentication, PostgreSQL does socket authentication out of … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | Comments Off on Initial Testing and Tries on MySQL Socket Authentication

Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

Create a new database item, then open it for editing: LAST_INSERT_ID(). Undo is better than “are you sure”. Mark items deleted, then empty trash when sure. Read the basics first: MySQL Install and One Table Database – SQL CRUD tutorial … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

MySQL is the most popular multi-user database. In this tutorial, you’ll learn to Install MySQL Server and Client on Ubuntu Automate MySQL login Create, read, update and delete data (CRUD)

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

Preseed MySQL Server Password with Salt Stack

MySQL is the most popular multi-user database in the world. When you install MySQL Server automatically, you must set database root password without asking user to type it. On Debian and Ubuntu, you can use Preseed to answer installer (apt-get) … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , | Comments Off on Preseed MySQL Server Password with Salt Stack

Monty Widenius Speaks in Pasila

Monty Widenius speaks in Haaga-Helia. He created MySQL database. Database Transaction Summit on w36 Wed 2013-09-04. Free registration until w35 Fri 2013-08-30.

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Monty Widenius Speaks in Pasila