centos7.3二进制安装mariadb

蒦嗳伱

官网二进制mariadb很多配置使写死的。所以配置文件的位置请留意不要出错哦。如/usr/loacl/mysql等。


1.确认没有maraiadb*包

rpm -qa mariadb*查看无包即可，若有，用yum remove 包名卸载即可。
mariadb软件包官网下载即可。


2.创建系统用户。很多服务都会用到对应的服务帐户。由于我们是手动安装，这个帐户只好自己创建了。
useradd -d /app/mysqldb -r -m -s /sbin/nologin mysql
getent passwd mysql
建议放在逻辑卷上，数据库会不断变大，不能扩展的分区后期处理起来就麻烦多了。


3.解压
tar xf mariadb-VERSION-linux-x86_64.tar.gz -C /usr/local
cd /usr/local
ln -sv mariadb-10.2.8-linux-x86_64 mysql v显示过程


4.准备配置文件
mkdir /etc/mysql

cp /usr/local/mysqlsupport-files/my-huge.cnf /etc/mysql/my.cnf
vim /etc/mysql/my.cnf
下面意为[mysqld]行下加入如下三行。
[mysqld]
datadir = /app/mysqldb 必须加
innodb_file_per_table = on 每表为一独立文件
skip_name_resolve = on 性能优化，禁止主机名解析


5../scripts/mysql_install_db --user=mysql --datadir=/app/mysqldb 运行脚本，创建系统数据库
ls /app/mysqldb 有东西了
(可能有报错，根据报错提醒，逐一排错)
因为是二进制编译，有些配置文件的位置是设定好的，这点需注意。
[root@centos7 mysql]# ./scripts/mysql_install_db --datadir=/app/mysqldb --user=mysql
Installing MariaDB/MySQL system tables in '/app/mysqldb' ...
2017-10-11 20:08:53 140592457275200 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-10-11 20:08:55 140592457275200 [ERROR] ./bin/mysqld: unknown variable 'datedir=/app/mysqldb'
2017-10-11 20:08:55 140592457275200 [ERROR] Aborting

6.准备服务脚本，并启动服务
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig --list mysqld
chkconfig --add mysqld
service mysqld start
下面是服务不能启动的情况
[root@centos7 mysql]# service mysqld start
Starting mysqld (via systemctl):  Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
                                                           [FAILED]
[root@centos7 mysql]# systemctl status mysqld.service -l
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2017-10-11 20:20:27 CST; 3min 32s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 10519 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)
Oct 11 20:20:26 centos7.magedu.com systemd[1]: Starting LSB: start and stop MySQL...
Oct 11 20:20:26 centos7.magedu.com mysqld[10519]: Starting MySQL.171011 20:20:26 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Oct 11 20:20:26 centos7.magedu.com mysqld[10519]: 171011 20:20:26 mysqld_safe Starting mysqld daemon with databases from /app/mysqldb
Oct 11 20:20:26 centos7.magedu.com mysqld[10519]: [133B blob data]
Oct 11 20:20:27 centos7.magedu.com mysqld[10519]: ERROR!
Oct 11 20:20:27 centos7.magedu.com systemd[1]: mysqld.service: control process exited, code=exited status=1
Oct 11 20:20:27 centos7.magedu.com systemd[1]: Failed to start LSB: start and stop MySQL.
Oct 11 20:20:27 centos7.magedu.com systemd[1]: Unit mysqld.service entered failed state.
Oct 11 20:20:27 centos7.magedu.com systemd[1]: mysqld.service failed.可以看到缺少了日志文件，日志文件对于mysql数据库还是很重要的。有时出现任务进行一半意外中断的情况，日志可以快速排错。接下来我们创建日志文件。注意权限。权限不对会导致服务无法启动。

touch /var/log/mariadb/mariadb.log
chown mysql /var/log/mariadb/mariadb.log
chown mysql /var/log/mariadb
service mysqld start


7.安全初始化环境配置
主要包括PATH环境变量及安全环境。
[root@centos7 mysql]# vim /etc/profile.d/mysql.sh
PATH=/usr/local/mysql/bin/:$PATH
可以同时开一个终端测试.
A:
[root@centos7 bin]# cd /usr/local/mysql/bin
[root@centos7 bin]# ./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):　　
B:查看当前登录用户

[root@centos7 ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.2.8-MariaDB-log MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)A:

[root@centos7 bin]# ./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
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]B:

[root@centos7 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)设置完成后再以root身份登录就要执行mysql -uroot -p命令了。