Update MariaDB on Debian 9

[snakom23]

I want update my version MariaDB 10.1 to 10.3, how can do it?

I have Debian 9.

[binboum]

Hi,

You can do like that

Code: Select all

apt-get install software-properties-common dirmngr
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.igh.cnrs.fr/pub/mariadb/repo/10.3/debian 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

mysql

If you see this error

Code: Select all

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

Else

Code: Select all

systemctl stop mysql

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

CTRL + D

kill -9 $(pgrep mysql)

systemctl start mysql