MySQL部署

MySQL的tar包部署

1.rz上传下载好的MySQL包

[root@hadoop001 ~]# rz
rz waiting to receive.
Starting zmodem transfer.  Press Ctrl+C to cancel.
Transferring mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz...
mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz was skipped

将下载好的tar包移动到/usr/local/目录下

[root@hadoop001 ~]# mv mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz /usr/local/
[root@hadoop001 ~]# cd /usr/local/
[root@hadoop001 local]# ll
total 304512
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 bin
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 lib
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 libexec
drwxr-xr-x. 17 mysqladmin dba       4096 Jun 12 03:33 mysql
-rwxrwxrwx.  1 root       root 311771412 May 17 10:03 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 sbin
drwxr-xr-x.  5 root       root      4096 May 19 01:03 share
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 src

2.Check isnot install

[root@hadoop001 local]# ps -ef|grep mysqld   查看有没有残留的/后台运行的进程
root      61384  61253  0 10:53 pts/3    00:00:00 grep mysqld
[root@hadoop001 local]# rpm -qa | grep -i mysql

3.解压

[root@hadoop001 local]# tar -xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz  解压
[root@hadoop001 local]# ln -s mysql-5.6.23-linux-glibc2.5-x86_64 mysql  软连接

4.创建组和用户

[root@hadoop001 local]# groupadd -g 101 dba

不同的组件服务是由他专属的用户来运行的，即MySQL数据库用mysqladmin来运行，不会用root、不会用jepson等。
101：dba的groupid是101

[root@hadoop001 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin

514：用户的uid
-g dba：主组是dba
-G root：属于root组
-d /usr/local/mysql：指家目录为/usr/local/mysql。如果没有-d，默认家目录为home目录下的mysqladmin
mysqladmin：要创建的用户名称

[root@hadoop001 local]# id mysqladmin
uid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root)

ps：此时没有设置mysql密码，因为工作中不可能通过xshell配置ip、密码登陆，进来的用户肯定能切到mysqladmin用户

if user mysqladmin is existing,please execute the following command of usermod.
如果mysqladmin用户已经存在，请执行以下usermod命令：

[root@hadoop001 local]#  usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin 

copy 环境变量配置文件至mysqladmin用户的home目录中,为了以下步骤配置个人环境变量

[root@hadoop001 local]# su - mysqladmin
-bash-4.1$ 
-bash-4.1$ cp /etc/skel/.* ./   将隐藏目录拷贝到当前文件夹
cp: omitting directory `/etc/skel/.'
cp: omitting directory `/etc/skel/..'
cp: cannot create regular file `./.bash_logout': Permission denied
cp: cannot create regular file `./.bash_profile': Permission denied
cp: cannot create regular file `./.bashrc': Permission denied
cp: omitting directory `/etc/skel/.gnome2'
cp: omitting directory `/etc/skel/.mozilla'

此时权限受限，应切到权限最大的去做

-bash-4.1$ exit
logout
[root@hadoop001 local]# cp /etc/skel/.* /usr/local/mysql/
cp: omitting directory `/etc/skel/.'
cp: omitting directory `/etc/skel/..'
cp: omitting directory `/etc/skel/.gnome2'
cp: omitting directory `/etc/skel/.mozilla'
[root@hadoop001 local]# su - mysqladmin
[mysqladmin@hadoop001 ~]$ 

5.创建配置文件（640） Create /etc/my.cnf(640) rw-r-----
mysql的配置文件默认从/etc/my.cnf 文件去读。未来在工作中，很多Linux系统中默认都有这个文件，这个文件默认都有内容。
defualt