kaloKu 于 2019-02-13 17:11:58 发布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: 直接回车 12345
卸载
[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 123456789101112
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 123456789
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 123
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 12
**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-sgmh12345678
