OpenStack-install-2-Mariadb

### MariaDB安装

[root@controller ~]# yum install mariadb mariadb-server python2-PyMySQL -y

[root@controller ~]# vim /etc/my.cnf.d/openstack.cnf

[mysqld]

bind-address = 192.168.1.150

default-storage-engine = innodb

innodb_file_per_table = on

max_connections = 4096

collation-server = utf8_general_ci

character-set-server = utf8

[root@controller ~]# systemctl start mariadb.service

[root@controller ~]# netstat -tunpl | grep :3306

tcp        0      0 192.168.1.150:3306      0.0.0.0:*               LISTEN      76120/mysqld  

[root@controller ~]# mysql_secure_installation 

[root@controller ~]# mysql -u root -p

Enter password: redhat

MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

+--------------------+

3 rows in set (0.00 sec)

MariaDB [(none)]>