Page 1 of 1

Update MariaDB on Debian 9

Posted: Fri Jul 13, 2018 7:47 am
by snakom23
I want update my version MariaDB 10.1 to 10.3, how can do it?

I have Debian 9.

Re: Update MariaDB on Debian 9

Posted: Thu Aug 09, 2018 12:30 pm
by binboum

You can do like that

Code: Select all

apt-get install software-properties-common dirmngr
apt-key adv --recv-keys --keyserver 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64,i386,ppc64el] stretch main'
apt-get install mariadb-server-10.3 mariadb-client-10.3
You leave empty when you ask for a password

After u can enter mysql command :

Code: Select all

If you see this error

Code: Select all

“ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded”

Code: Select all

systemctl stop mysql

mysqld_safe --skip-grant-tables &
mysql -uroot
use mysql;
update user set plugin="mysql_native_password";
flush privileges;


kill -9 $(pgrep mysql)

systemctl start mysql