Update MariaDB on Debian 9
Posted: Fri Jul 13, 2018 7:47 am
I want update my version MariaDB 10.1 to 10.3, how can do it?
I have Debian 9.
I have Debian 9.
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
Code: Select all
mysql
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;
CTRL + D
kill -9 $(pgrep mysql)
systemctl start mysql