MySQL在线安装
(1)验证本机是否安装MySQL
命令:yum list installed | grep mysql
(2)删除MySQL(若安装过,未安装则略过此步)
命令:
①yum -y remove [MySQL软件名]
②yum erase [MySQL软件名]
命令解释:两个命令任选其一即可
(3)验证是否删除成功
命令: yum list installed | grep mysql
(4)在线安装MySQL
命令:
①su root
②yum install mysql
③yum install mysql-server
(5)开启mysql服务
命令:service mysqld start
(6)验证是否安装成功
命令:
①service mysqld status
②netstat -nat
命令解释:查看3306端口是否开启
(7)进入MySQL-shell查看
命令:mysql -u root -p
(8)退出MySQL
命令:quit;
(9)修改root用户密码
命令:mysqladmin -u root –p password “123456”
命令解释:回车后会提示输入密码,此时输入原来的密码
(10)进行授权
命令:
①mysql -u root
②GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘123456’;
③flush privileges;
命令解释:授权格式为grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";意义为授予其他权限登录root用户,密码为123456,%意为对所有用户都可以登录
(11)创建用户及数据库
命令:
①CREATE USER ‘zyd’ IDENTIFIED BY ‘123456’;
②CREATE DATABASE hive;
(12)MySQL授权
命令:GRANT ALL PRIVILEGES ON hive.* TO ‘zyd’@’%’ IDENTIFIED BY ‘123456’;
(13)配置元数据
命令:
①GRANT ALL PRIVILEGES ON *.* TO 'zyd'@'master' IDENTIFIED BY '123456';
②flush privileges;
(14)退出
命令:quit;
MySQL离线安装
(1)验证本机是否安装MySQL
命令:yum list installed | grep mysql
(2)删除MySQL(若安装过,未安装则略过此步)
命令:
①yum -y remove [MySQL软件名]
②yum erase [MySQL软件名]
命令解释:两个命令任选其一即可
(3)验证是否删除成功(未删除则略过此步)
命令: yum list installed | grep mysql
(4)解压mysql5.7.21
命令:tar -zxvf mysql5.7.21
命令解释:将压缩包解压至/usr/local目录下
(5)创建软链接
命令:ln -s mysql5.7.21 mysql
(6)创建mysql用户组
命令:①groupadd mysql
(7)在mysql用户组中添加新用户
命令:useradd -r -g mysql mysql
(8)修改目录拥有者及属组
命令:
①chown -R mysql .
②chgrp -R mysql .
命令解释:进入mysql所在目录执行上述命令
(9)创建数据库存放目录和相关文件并修改权限
命令:
①sudo mkdir -pv /data/mysqldb/3306/{logs,run,data}
②sudo touch /data/mysqldb/3306/run/mysqld.pid
③sudo touch /data/mysqldb/3306/logs/mysql-error.log
④sudo chown -R mysql.mysql /data/mysqldb/
⑤sudo chmod -R 777 /data/mysqldb
(10)修改配置文件
命令:sudo vim /usr/local/mysql/my.cnf
内容处置:修改或添加以下内容
[client]
port=3306
socket=/data/mysqldb/3306/mysql.sock
default_character_set=UTF-8
[mysqld]
user=mysql
port=3306
socket=/data/mysqldb/3306/mysql.sock
basedir=/usr/local/mysql
datadir=/data/mysqldb/3306/data
pid-file=/data/mysqldb/3306/run/mysqld.pid
log-error=/data/mysqldb/3306/logs/mysql-error.log
character_set_server=utf8
[mysql]
socket=/data/mysqldb/3306/mysql.sock
[mysqldump]
socket=/data/mysqldb/3306/mysql.sock
[mysqladmin]
socket=/data/mysqldb/3306/mysql.sock
(11)初始化MySQL安装
命令:
①sudo /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf
②sudo /usr/local/mysql/bin/mysqld --initialize-insecure
命令解释:以空密码初始化数据库
③sudo /usr/local/mysql/bin/mysqld --user=mysql
④sudo /usr/local/mysql/bin/mysqld --datadir=/data/mysqldb/3306/data
(12)配置环境变量
命令:sudo vim /etc/profile
内容处置:添加以下内容
MYSQL_HOME=/usr/local/mysql
PATH=$PATH:$MYSQL_HOME/bin
export $MYSQL_HOME PATH
(13)生效配置文件
命令:source /etc/profile
(14)修改root密码
命令:
①mysql -u root -p
命令解释:回车执行后,因为一开始没有设置密码,所以这里不需要输入密码,直接回车即可登录,执行成功后,控制台显示 mysql>,则表示进入mysql
②set password for 'root'@'localhost'=password('admin');
(15)退出mysql
命令:quit
(16)重新登录
命令:mysql -u root -p
命令解释:回车后输入密码admin即可
(17)创建hive所需的账户和数据库
命令:
①mysql -u root -p
②CREATE USER ‘zyd’ IDENTIFIED BY ‘123456’;
命令解释:创建用户
③CREATE DATABASE hive;
(18)MySQL授权
命令:
①GRANT ALL PRIVILEGES ON hive.* TO 'zyd'@'%' IDENTIFIED BY '123456';
②GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin';
③flush privileges;
(19)退出mysql-shell
命令:quit