Server

Config Root MariaDB vs MySQL

Posted on by admin

MariaDB

apt-get install mariadb-server mariadb-client
mysql_secure_installation
y
y
y
y
mysql -u root -p mysql
update user set plugin='' where user='root';
flush privileges;

MySQL

apt-get install mysql-server mysql-client
mysql_secure_installation
y
y
y
y
mysql -u root -p 
use mysql;
update user set plugin='mysql_native_password' where user='root';
flush privileges;
mysqladmin -u root password inipw