二进制安装指定版本的MariaDBv10.11.6
一、官网下载mariadb安装包
Download MariaDB Server - MariaDB.org
找到对应的版本
下载安装包后上传到服务器这里不再赘述。
二、安装二进制包
1、解压安装包
2、查看安装包内的安装提示文档根据提示文档进行安装
# 解压安装包
tar xf mariadb-10.11.6-linux-systemd-x86_64
# 进入安装包
d Testing."
mariadb-10.11.6-linux-systemd-x86_64]# ls
bin CREDITS include lib mysql-test README-wsrep share support-files
COPYING docs INSTALL-BINARY man README.md scripts sql-bench THIRDPARTY
mariadb-10.11.6-linux-systemd-x86_64]# head -n 10 INSTALL-BINARY
MariaDB and MySQL have identical install methods. In this document we
describe how to install MariaDB.
The full documentation for installing MariaDB can be found at
https://mariadb.com/kb/en/library/binary-packages/
However most documentation at www.mysql.com also applies.
2.2. Installing MariaDB from Generic Binaries on Unix/Linux
This section covers the installation of MariaDB binary distributions3、复制目录到/usr/local下
4、创建MySQL用户，给目录授权MySQL权限
# 把安装目录复制到/usr/local下 这里可以任意目录
cp -r mariadb-10.11.6-linux-systemd-x86_64 /usr/local/mysql
# 创建MySQL用户 授予MySQL权限
useradd mysql
chown -R mysql:mysql /usr/local/mysql/
# 创建日志目录
mkdir -p /var/log/mariadb
cd /var/log/
chown mysql:mysql mariadb5、初始化数据库
mysql]# cd /usr/local/mysql/
mysql]# scripts/mysql_install_db --user=mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system
Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is mysql@localhost, it has no password either, but
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '.' ; ./bin/mariadb-safe --datadir='/var/lib/mysql'
You can test the MariaDB daemon with mysql-test-run.pl
cd './mysql-test' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/6、配置系统服务
# 启动数据库
bin/mysqld_safe --user=mysql &
# 把启动服务加到服务里
cd /usr/local/mysql/support-files
sudo cp mysql.server /etc/init.d/mariadb
sudo chmod +x /etc/init.d/mariadb
sudo systemctl enable mariadb
sudo systemctl start mariadb # 这里启动会一直卡着直接ctrl退出就好了致此安装完成
三、验证服务
配置账号密码及权限
bin]# cd /usr/local/mysql/bin
bin]# ./mariadb -uroot -p --socket=/var/lib/mysql/mysql.sock
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.11.6-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123qweASD';
Query OK, 0 rows affected (0.002 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)用另外一台mysql登录验证账号密码及权限
# 输入正确的密码
mysql]# mysql -uroot -p -h 10.50.11.120
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.11.6-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
# 输入错误的密码
mysql]# mysql -uroot -p -h 10.50.11.120
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'10.50.78.121' (using password: YES)