mariadb ubuntu 16.4
官方
https://mariadb.com/kb/en/mariadb/installing-mariadb-deb-files/
- New Key
- Add MariaDB to your sources.list
sudo apt-get install software-properties-common
sudo apt-key adv –recv-keys –keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository ‘deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu trusty main’
sudo apt-get update
sudo apt-get install mariadb-server
．begin install maybe have question about other mariadb toolkit install
If Y -> have one question for root password
If N -> use mysql_secure_installtion for secure
Finish install mariadb.
modify my.cnf /etc/mysql ( find / -name my.cnf )
[mysqld]
1、port maybe change 3306 -> 6033
2、listen maybe 127.0.0.1 -> 0.0.0.0
login mysql
1、root login anywhere %, full rights
GRANT ALL PRIVILEGES ON *.* TO ‘root’@'%' IDENTIFIED BY ‘put password’ with grant option;
2、create other account login anywhere %, full rights
GRANT ALL PRIVILEGES ON *.* TO ‘otheraccount’@'%' IDENTIFIED BY ‘put password’ with grant option;
3、remove Revoke (權限)
REVOKE ALL PRIVILEGES, GRANT OPTION FROM ‘root’@'%';
4、Remove/Delete the user
DROP USER ‘root’@'%';
5、show user and grant 顯示
SELECT User,Host FROM mysql.user;
SHOW GRANTS FOR ‘root’@‘localhost’;
SHOW GRANTS FOR ‘root’@'%';
