mariadb使用记录

发表于 | 更新于: | 分类于

MariaDB简介

  MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可 MariaDB的目的是完全兼容MySQL，包括API和命令行，使之能轻松成为MySQL的代替品。在存储引擎方面，使用XtraDB（英语：XtraDB）来代替MySQL的InnoDB。

安装与配置

  记录Mariadb的安装配置过程 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
yum -y install mariadb mariadb-server  #安装mariadb的客户端与服务端
systemctl start mariadb # 启动mariadb
mysql_secure_installation # 进行初始的设置
# NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
#       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

# In order to log into MariaDB to secure it, we'll need the current
# password for the root user.  If you've just installed MariaDB, and
# you haven't set the root password yet, the password will be blank,
# so you should just press enter here.

# Enter current password for root (enter for none):  #默认无密码登录
# OK, successfully used password, moving on...

# Setting the root password ensures that nobody can log into the MariaDB
# root user without the proper authorisation.

# Set root password? [Y/n] y # 是否设置新的root密码
# New password: 
# Re-enter new password: 
# Password updated successfully!
# Reloading privilege tables..
#  ... Success!


# By default, a MariaDB installation has an anonymous user, allowing anyone
# to log into MariaDB without having to have a user account created for
# them.  This is intended only for testing, and to make the installation
# go a bit smoother.  You should remove them before moving into a
# production environment.

# Remove anonymous users? [Y/n] Y # 是否删除匿名用户
#  ... Success!

# Normally, root should only be allowed to connect from 'localhost'.  This
# ensures that someone cannot guess at the root password from the network.

# Disallow root login remotely? [Y/n] n # 是否禁止root账户远程登录
#  ... skipping.

# By default, MariaDB comes with a database named 'test' that anyone can
# access.  This is also intended only for testing, and should be removed
# before moving into a production environment.

# Remove test database and access to it? [Y/n] n # 是否删除test数据库
#  ... skipping.

# Reloading the privilege tables will ensure that all changes made so far
# will take effect immediately.

# Reload privilege tables now? [Y/n] y # 是否重新加载权限表
#  ... Success!

# Cleaning up...

# All done!  If you've completed all of the above steps, your MariaDB
# installation should now be secure.

# Thanks for using MariaDB!

远程登录设置

1
mysql -uroot -p  #登录mysql
1
2
GRANT ALL ON database_name.table_name TO databaseuser@'ip_address' IDENTIFIED BY 'password';
flush privileges; #重新加载权限表
  • database_name 你要访问的数据库名称（*代表所有）
  • table_name 你要访问的表名（*代表所有）
  • databaseuser 新的数据库用户
  • password 设置新的密码（mysql将会对你的设置进行加密再到user表中）
  • ip_address 可访问的ip地址（使用%可以让所有的IP都可以访问）