MARIADB
Sauter à la navigation
Sauter à la recherche
MariaDB[modifier]
Installation[modifier]
Version 6.x centOS
Ajouter un repo:
/etc/yum.repos.d/MariaDB.repo
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Installer les packages:
yum install MariaDB-server MariaDB-client
Modifier le chemin du dossier mysql
mv /var/lib/mysql /var/lib/mysql-old ln -s /mysql /var/lib/mysql cp -pr /var/lib/mysql-old/* /mysql
Attention au droit et user sur dossier mysql (user mysql:mysql)
Lancement du service MariaDB (daemon)
service mysql start
Gestion des users Modifier les droits users
mysql_secure_installation
mysql -u root -p
CREATE USER 'root'@'%';
grant all privileges on *.* to 'root'@'%' with grant option;
set PASSWORD FOR 'root'@'%' = PASSWORD('XXXXXX');
flush privileges;