MariaDB 安装

MariaDB 安装

• 添加 MariaDB yum 仓库

  1. vim /etc/yum.repos.d/MariaDB.repo
  [mariadb]
  name = MariaDB
  baseurl = http://yum.mariadb.org/10.1/centos7-amd64
  gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
  gpgcheck=1
  

• 在 CentOS 7 中安装 MariaDB

  1. yum install mariadb-server mariadb-client -y
  2. mariadb数据库的相关命令是：
      systemctl start mariadb  #启动MariaDB
  
      systemctl stop mariadb  #停止MariaDB
  
      systemctl restart mariadb  #重启MariaDB
  
      systemctl enable mariadb  #设置开机启动
  

• 初始化mysql

  # 1. 启动 数据库 
  	systemctl start mariadb
  # 2. 初始化数据库 , 按照下面内容执行 
  	mysql_secure_installation
  

  

• 修改数据库密码

  # 1. 进入数据库 
  	mysql -uroot -p
  # 2. 设置密码 
  	set password = PASSWORD('test123');
  	set password = PASSWORD('123456');
  

• 建立用户

  # 1. 创建用户
  	create user server@'127.0.0.1' identified by '123456';
  # 2. 切换db	
  	use mysql;
  # 3. 查看新建用户
  	select host,user,password from user where user='server';
  # 4. 给新建用户赋予权限
  	 grant all privileges on *.* to server@127.0.0.1;
  # 5. 查看权限
  	show grants for server@127.0.0.1;
  

• 修改数据库配置

  # 1. 编辑配置
  	cd ~
  	vim /etc/my.cnf
  # 2. %d 清空
  # 3. 粘贴以下内容
      [mysqld]
      character-set-server=utf8mb4
      collation-server=utf8mb4_general_ci
      log-error=/var/log/mysqld.log
      [client]
      default-character-set=utf8mb4
      [mysql]
      default-character-set=utf8mb4
  # 4. 重启服务
  	systemctl restart mariadb
  

• 远程登录

  ### 进入数据库
  use mysql   
  select host,user,password from user where user='tjuser';
  GRANT ALL PRIVILEGES ON *.* TO 'tjuser'@'%' IDENTIFIED BY '1qaz!QAZ' WITH GRANT OPTION;
  flush privileges;