mysql (mariadb)

1. installation

curl -s http://d01cid.ddns.net/sharel/bin/inst-mariadb-server | sh

2. what did i do?

yum -y install mariadb-server

systemctl enable mariadb.service
systemctl start mariadb.service

2.1. configuration

mysqladmin -u "root" password "Passw0rd"

mysql -u"root" -p"Passw0rd" -e "grant all privileges on *.* to 'root'@'%' identified by 'Passw0rd';"
mysql -u"root" -p"Passw0rd" -e "grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'Passw0rd';"
mysql -u"root" -p"Passw0rd" -e "grant all privileges on *.* to 'root'@'localhost' identified by 'Passw0rd';"
mysql -u"root" -p"Passw0rd" -e "grant all privileges on *.* to 'root'@'$(hostname -f)' identified by 'Passw0rd';"
mysql -u"root" -p"Passw0rd" -e "flush privileges;"
mysql -u"root" -p"Passw0rd" -e "drop database test;"

mysql -u"root" -p"Passw0rd" -e "create database cid;"

3. mycli

yum install python-pip
pip install --upgrade pip
pip install mycli