MySQL部署及相关问题

MySQL部署及相关问题

1.关于mysql：
RPM: 学习 测试 快速部署
tar: 定制化 企业级
https://github.com/Hackeruncle/MySQL/blob/master/MySQL 5.6.23 Install.txt
RPM安装:

yum install -y mysql-server.x86_64
yum install -y mysql.x86_64
service mysqld start
[root@hadoop001 ~]# mysql -uroot -p
Enter password: 直接回车

卸载

[root@hadoop001 ~]# rpm -qa | grep mysql
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
[root@hadoop001 ~]# rpm -e mysql-5.1.73-8.el6_8.x86_64
error: Failed dependencies:
        mysql = 5.1.73-8.el6_8 is needed by (installed) mysql-server-5.1.73-8.el6_8.x86_64
[root@hadoop001 ~]# rpm -e  mysql-server-5.1.73-8.el6_8.x86_64
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
[root@hadoop001 ~]# 
[root@hadoop001 ~]# 
[root@hadoop001 ~]# rpm -e mysql-5.1.73-8.el6_8.x86_64

2.下载与MD5校验

[root@sht-sgmhadoopnn-01 ~]# cd /usr/local
[root@sht-sgmhadoopnn-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
[root@sht-sgmhadoopnn-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5
mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
选择rz上传
[root@sht-sgmhadoopnn-01 local]# cat mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5
61affe944eff55fcf51b31e67f25dc10  mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
[root@sht-sgmhadoopnn-01 local]# md5sum mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
61affe944eff55fcf51b31e67f25dc10  mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz

3.检测是否已下载

[root@sht-sgmhadoopnn-01 local]# ps -ef|grep mysqld
root      2493  2423  0 19:48 pts/3    00:00:00 grep mysqld
[root@sht-sgmhadoopnn-01 local]# rpm -qa |grep -i mysql

4.解压并移动

[root@sht-sgmhadoopnn-01 local]# tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
[root@sht-sgmhadoopnn-01 local]# mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql

**5.创建用户和组 **

[root@sht-sgmhadoopnn-01 local]# groupadd -g 101 dba
[root@sht-sgmhadoopnn-01 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin

useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
[root@hadoop001 local]# 


[root@sht-sgmh