生产环境部署: mariadb-10.1.17-linux-x86_64.tar.gz
CentOS7用yum安装、配置MariaDB 10
下载地址:https://downloads.mariadb.org/mariadb/
# 使用root进行安装
# 创建用户mysql并加入到mysql组,不允许mysql用户直接登录系统
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
#安装路径: /usr/local/
cd /usr/local/
tar -xvf /mnt/hgfs/share_files/mariadb-10.1.17-linux-x86_64.tar.gz
mv mariadb-10.1.17-linux-x86_64 mysql
cd mysql
mkdir log-bin
#增加环境变量(如果不能重启,则修改root的 .bashrc 目录)
#增加 /usr/local/mysql/bin 路径到 /etc/profile 中
vi /etc/profile
export PATH=$PATH:$JAVA_HOME/bin:/usr/local/mysql/bin
source /etc/profile
#配置my.cnf
cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
#默认不需要配置,但根据默认需要做些修改(如:日志)
chown -R mysql:mysql /usr/local/mysql #我们生成MariaDB系统数据库是用mysql 账号
#生成MariaDB系统数据库
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
#设置后台启动
cp support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
启动数据库如下:
#mysqld --user=mysql &
service mysql start
//log位置
#/etc/my.cnf //默认注释了,地址:/usr/local/mysql/data/xxx.err
#登陆
mysql -u root -p #无密码,回车即可,//访问远程mysql: mysql -uroot -p123456 -h192.168.0.221
MariaDB [(none)]> show databases;
MariaDB [(none)]> use mysql;
#修改root密码
update user set authentication_string=PASSWORD('root') where User='root';
flush privileges;
#建库
use mysql;
create database zabbix character set utf8; //如果是用于hive的元数据,那么编码要设置成“latin1”,否则drop table时会卡住
grant all privileges on *.* to zabbix@'%' identified by 'zabbix';
grant all privileges on *.* to zabbix@'localhost' identified by 'zabbix';
grant all privileges on *.* to zabbix@'hadoop01' identified by 'zabbix';
flush privileges;
CentOS7用yum安装、配置MariaDB 10
下载地址:https://downloads.mariadb.org/mariadb/
# 使用root进行安装
# 创建用户mysql并加入到mysql组,不允许mysql用户直接登录系统
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
#安装路径: /usr/local/
cd /usr/local/
tar -xvf /mnt/hgfs/share_files/mariadb-10.1.17-linux-x86_64.tar.gz
mv mariadb-10.1.17-linux-x86_64 mysql
cd mysql
mkdir log-bin
#增加环境变量(如果不能重启,则修改root的 .bashrc 目录)
#增加 /usr/local/mysql/bin 路径到 /etc/profile 中
vi /etc/profile
export PATH=$PATH:$JAVA_HOME/bin:/usr/local/mysql/bin
source /etc/profile
#配置my.cnf
cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
#默认不需要配置,但根据默认需要做些修改(如:日志)
chown -R mysql:mysql /usr/local/mysql #我们生成MariaDB系统数据库是用mysql 账号
#生成MariaDB系统数据库
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
#设置后台启动
cp support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
启动数据库如下:
#mysqld --user=mysql &
service mysql start
//log位置
#/etc/my.cnf //默认注释了,地址:/usr/local/mysql/data/xxx.err
#登陆
mysql -u root -p #无密码,回车即可,//访问远程mysql: mysql -uroot -p123456 -h192.168.0.221
MariaDB [(none)]> show databases;
MariaDB [(none)]> use mysql;
#修改root密码
update user set authentication_string=PASSWORD('root') where User='root';
flush privileges;
#建库
use mysql;
create database zabbix character set utf8; //如果是用于hive的元数据,那么编码要设置成“latin1”,否则drop table时会卡住
grant all privileges on *.* to zabbix@'%' identified by 'zabbix';
grant all privileges on *.* to zabbix@'localhost' identified by 'zabbix';
grant all privileges on *.* to zabbix@'hadoop01' identified by 'zabbix';
flush privileges;