搭建Mysql

登录root账号

su root

#上传 mysql-advanced-5.7.17-linux-glibc2.5-x86_64.tar.gz

#创建mysql的用户组/用户, data目录及其用户目录

groupadd mysql
useradd -g mysql -d /home/mysql mysql
mv mysql-advanced-5.7.17-linux-glibc2.5-x86_64 mysql
mkdir /home/mysql/data

#解压安装包并将解压包里的内容拷贝到mysql的安装目录/home/mysql

cd /home/hadoop/software
tar -xzvf mysql-advanced-5.7.17-linux-glibc2.5-x86_64.tar.gz
cd mysql-advanced-5.7.17-linux-glibc2.5-x86_64 
mv ./* /home/mysql

#初始化mysql数据库，并记录临时密码：vu)WA/,/!56+

cd /home/mysql
./bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize

#修改默认安装目录

vi support-files/mysql.server
basedir=/home/mysql
datadir=/home/mysql/data

#创建软链接

ln -s /home/mysql/bin/mysql /usr/bin/mysql
ln -s /home/mysql/ /usr/local/mysql

#创建配置文件 将默认生成的my.cnf备份

mv /etc/my.cnf /etc/my.cnf.bak

#进入mysql的安装目录支持文件目录

cd /home/mysql/support-files

# 拷贝配置文件模板为新的mysql配置文件,

cp my-default.cnf /etc/my.cnf

#可按需修改新的配置文件选项， 不修改配置选项， mysql则按默认配置参数运行. 
#如下是我修改配置文件
/etc/my.cnf， 设置编码为utf8以防乱码

vi /home/mysql/support-files/mysql.server

[mysqld]
basedir = /home/mysql
datadir = /home/mysql/data

vi /etc/my.cnf

[mysqld]
basedir = /home/mysql
datadir = /home/mysql/data

character_set_server=utf8
init_connect='SET NAMES utf8'

[client]
default-character-set=utf8

#配置mysql服务开机自动启动
#拷贝启动文件到/etc/init.d/下并重命令为mysqld

cp /home/mysql/support-files/mysql.server /etc/init.d/mysqld

#增加执行权限

chmod 755 /etc/init.d/mysqld

#检查自启动项列表中没有mysqld这个，如果没有就添加mysqld：

chkconfig --list mysqld
chkconfig --add mysqld

# 设置MySQL在345等级自动启动 

chkconfig --level 345 mysqld on

# 或用这个命令设置开机启动：

chkconfig mysqld on

chown -R mysql.mysql /home/mysql/data
chown -R mysql.mysql /home/mysql/*

9. mysql服务的启动/重启/停止
# 启动mysql服务

service mysqld start

#查看日志

ll /usr/local/mysql/var/

# 重启mysql服务

service mysqld restart

# 停止mysql服务

service mysqld stop

#  初始化mysql用户root的密码 先将mysql服务停止

service mysqld stop

#进入mysql安装目录， 安全模式 执行： 

/home/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking&

#mysql命令终端

mysql -u root

#查找root密码 GojufG=l#8-L

cat /var/log/mysqld.log
mysql -u root -p

#修改密码

alter user 'root'@'localhost' identified by '111';
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY '111' WITH GRANT OPTION;

flush privileges;

 

use mysql

#数据库编码

show variables like '%char%';

#重启mysql
quit
#编辑

vi /etc/my.cnf 
character_set_server=utf8
init_connect=’SET NAMES utf8’

systemctl restart mysqld

#启动mysql

systemctl start mysqld

#检查mysql状态

service mysqld status

# 检测下是否能启动mysql服务

cd /home/mysql
./support-files/mysql.server start

授权
#创建sqoop用户

mysql -u root -p 
1111
select host,user from user
CREATE USER tdmsdev IDENTIFIED BY "1111";

#创建数据库

create database tdm;

#授权

show grants
revoke all on *.* from tdmsdev@'%'; 
GRANT ALL PRIVILEGES ON tdm.* TO tdmsdev@'%' IDENTIFIED BY '1111' WITH GRANT OPTION;
flush privileges;

#查看数据库

show databases;
use tdm;

#查看表

show tables;
CREATE TABLE mytable(name VARCHAR(20), sex CHAR(1));
insert into mytable values ("hyq","M");
select * from mytable;

mysql -h localhost -u sqoop -p
mysql -h Master.Hadoop -u sqoop -p

rpm -ql mysql
tail -fn 15 /var/log/mysqld.log

#RROR 2013 (HY000): Lost connection to MySQL server during query
SHOW STATUS LIKE 'aborted%'
set global connect_timeout=60