首页 > 代码库 > CentOS mariadb

CentOS mariadb

1. CentOS mariadb 是mysql的替代品 

2. 安装mariadb

    sudo yum install mariadb-server mariadb

3. 启动

  sudo systemctl start mariadb

参考

systemctl start mariadb  #启动MariaDB

systemctl stop mariadb  #停止MariaDB

systemctl restart mariadb  #重启MariaDB

systemctl enable mariadb  #设置开机启动

 

4. 连接

   mysql -uroot -p

 

5.更改表名大小写敏感

  /etc/my.cnf.d文件夹下找到server.cnf
  [mysqlld]
  lower_case_table_names=1

    默认是等于0的,即大小写敏感。改成1表示不敏感

 

CentOS mariadb