mysql-mariadb安装

安装：

1、下载安装包；https://mariadb.org/download/     mariadb 10.2 对应 mysql 5.7

2、查看官网二进制安装教程：https://mariadb.com/kb/en/installing-mariadb-binary-tarballs/  注意提前配置好/etc/my.cnf

  1 #
  2 # This group is read both by the client and the server
  3 # use it for options that affect everything
  4 #
  5 [client-server]
  6
  7 #
  8 # include *.cnf from the config directory
  9 #
 10 !includedir /etc/my.cnf.d

　　/etc/my.cnf.d 文件 mysql-clients.cnf

  1 #
  2 # These groups are read by MariaDB command-line tools
  3 # Use it for options that affect only one utility
  4 #
  5
  6 [mysql]
  7
  8 [mysql_upgrade]
  9
 10 [mysqladmin]
 11
 12 [mysqlbinlog]
 13
 14 [mysqlcheck]
 15
 16 [mysqldump]
 17
 18 [mysqlimport]
 19
 20 [mysqlshow]
 21
 22 [mysqlslap]
 23

　　/etc/my.cnf.d 文件 server.cnf

  1 #
  2 # These groups are read by MariaDB server.
  3 # Use it for options that only the server (but not clients) should see
  4 #
  5 # See the examples of server my.cnf files in /usr/share/mysql/
  6 #
  7
  8 # this is read by the standalone daemon and embedded servers
  9 [server]
 10
 11 # this is only for the mysqld standalone daemon
 12 [mysqld]
 13 innodb_file_per_table = ON
 14 skip_name_resolve = ON
 15 character_set_server = utf8
 16 basedir = /usr/local/mysql
 17 datadir = /Data/mysqlData
 18 default_storage_engine = innodb
 19
 20 #
 21 # * Galera-related settings
 22 #
 23 [galera]
 24 # Mandatory settings
 25 #wsrep_on=ON
 26 #wsrep_provider=
 27 #wsrep_cluster_address=
 28 #binlog_format=row
 29 #default_storage_engine=InnoDB
 30 #innodb_autoinc_lock_mode=2
 31 #
 32 # Allow server to accept connections on all interfaces.
 33 #
 34 #bind-address=0.0.0.0
 35 #
 36 # Optional setting
 37 #wsrep_slave_threads=1
 38 #innodb_flush_log_at_trx_commit=0
 39
 40 # this is only for embedded server
 41 [embedded]
 42
 43 # This group is only read by MariaDB servers, not by MySQL.
 44 # If you use the same .cnf file for MySQL and MariaDB,
 45 # you can put MariaDB-only options here
 46 [mariadb]
 47
 48 # This group is only read by MariaDB-10.2 servers.
 49 # If you use the same .cnf file for MariaDB of different versions,
 50 # use this group for options that older servers don't understand
 51 [mariadb-10.2]

　　　　

3、运行安装脚本：mysql]# ./scripts/mysql_install_db --ldata=/Data/mysql --skip-name-resolve --user=mysql

4、配置service文件，启动服务；

5、运行安全脚本：mysql_secure_installation

6、设置密码登录，安装完成之后，本机不需要输入密码即可登录，即使已经运行了安全脚本设置了root账户的密码；

MariaDB [mysql]> SELECT PASSWORD('root');
+-------------------------------------------+
| PASSWORD('root')                          |
+-------------------------------------------+
| *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-------------------------------------------+
1 row in set (0.00 sec)

MariaDB [mysql]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B';
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

　　

安装完成

mariadb配置文件：https://mariadb.com/kb/en/configuring-mariadb-with-option-files/