User Tools

Site Tools


installing_mariadb_on_ubuntu_16_04_onwards

Installing MariDB on Ubuntu 16.04 onwards

This is madness, imo, but w/e

   sudo apt-get install mariadb-server mariadb-client

Once that's done, you must do this:

   sudo mysql_secure_installation

No password, make one, then mess about with the settings you want.

At this point, you can still only log onto mysql using “sudo”, so we need to fix that.

   sudo mysql -u root -p
   (enter your password and whack enter)

In the MySQL editor, we gotta do this:

   use mysql;
   update user set plugin='' where User='root';
   flush privileges;
   quit;

Once that's done, you can log into the database without using sudo (yeah, really, I spent a day figuring what the fuck was up with that).

installing_mariadb_on_ubuntu_16_04_onwards.txt · Last modified: 2017/03/22 23:19 (external edit)