服务器平台搭建

服务器端平台搭建

配置详情

操作系统：Red Hat 6.3
内存：2G
处理器：i5 处理器核心总数：4
硬盘：20G

RedHat下安装MYSQL

1. 将相关的mysql rpm包上传到redhat上，下载地址:https://dev.mysql.com/downloads/mysql/5.6.html#downloads
2. 解压安装包得到7个.rpm文件：
   MySQL-client-5.6.41-1.el6.x86_64.rpm
   MySQL-devel-5.6.41-1.el6.x86_64.rpm
   MySQL-embedded-5.6.41-1.el6.x86_64.rpm
   MySQL-server-5.6.41-1.el6.x86_64.rpm
   MySQL-shared-5.6.41-1.el6.x86_64.rpm
   MySQL-shared-compat-5.6.41-1.el6.x86_64.rpm
   MySQL-test-5.6.41-1.el6.x86_64.rpm
3. 安装之前查看已经安装的MYSQL
   rpm -qa | grep mysql
4. 卸载已经安装的MYSQL(注意需要进入root模式 su)
   rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps --allmatches
5. 将老版本中文件手动删除
   rm -f /etc/my.cnf
rm -rf /var/lib/mysql
rm -rf /var/share/mysql
rm -rf /usr/bin/mysql*
6. 安装MYSQL服务器端
   rpm -ivh MySQL-server-5.6.41-1.el6.x86_64.rpm

如果出现以下错误：

warning: MySQL-server-5.6.41-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by MySQL-server-5.6.41-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.41-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.41-1.el6.x86_64

说明代表缺少 numactl ，使用：yum install numactl 安装就可以了。

如果yum源无法使用：

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Setting up Install Process
No package numactl available.
Error: Nothing to do

解决办法：

1.1 清除原有RHEL的YUM及相关软件包
rpm -qa | grep yum | xargs rpm -e --nodeps
rpm -qa |grep python-urlgrabber|xargs rpm -e --nodeps

1.2 下载centos6的相关软件包

wget http://mirrors.163.com/centos/6/os/x86_64/Packages/yum-3.2.29-81.el6.centos.noarch.rpm
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/yum-metadata-parser-1.1.2-16.el6.x86_64.rpm
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.30-41.el6.noarch.rpm
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/python-iniparse-0.3.1-2.1.el6.noarch.rpm
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/python-urlgrabber-3.9.1-11.el6.noarch.rpm

请到http://mirrors.163.com/centos/6/os/x86_64/Packages/ 目录下，选择下载上述软件包。
1.3 安装软件包(转到安装包目录下)
rpm -ivh python-iniparse-0.3.1-2.1.el6.noarch.rpm
rpm -ivh python-urlgrabber-3.9.1-11.el6.noarch.rpm
rpm -ivh yum-metadata-parser-1.1.2-16.el6.x86_64.rpm
rpm -ivh yum-plugin-fastestmirror-1.1.30-41.el6.noarch.rpm yum-3.2.29-81.el6.centos.noarch.rpm

注释yum-plugin-fastestmirror和yum-3.2.29要一起安装
1.4 安装yum
rpm -ivh yum-*

1.5 更改yum源
cd /etc/yum.repos.d/

1.6 下载配置文件http://mirrors.163.com/.help/centos.html

wget http://mirrors.163.com/.help/CentOS6-Base-163.repo

将此配置文件替换/etc/yum.repos.d同名文件
sed -i "s;\$releasever;6;g" CentOS6-Base-163.repo
mv rhel-source.repo /etc/yum.repos.d

1.7 清理yum缓存 测试
yum clean all
yum repolist
如果显示出repo仓库列表，并显示软件包数量则OK.

1.8 使用yum安装软件包测试
yum -y install lrzs

如果不出现意外，lrzsz软件包安装成功。yum也就可以正常使用了。
7 继续步骤6
yum install numactl
rpm -ivh MySQL-server-5.6.41-1.el6.x86_64.rpm
8 安装MySQL客户端
rpm -ivh MySQL-client-5.6.41-1.el6.x86_64.rpm
9 安装MySQL库
rpm -ivh MySQL-devel-5.6.41-1.el6.x86_64.rpm
10 查看mysql的密码，第一次安装的时候的密码文件在/root/.mysql_secret中
cd /root
ls -ash
cat .mysql_secret

The random password set for the root user at Mon Aug 6 08:16:17 2018 (local time): PwxPOa0OJqEAoAwO

PwxPOa0OJqEAoAwO 即为初始密码。
11 修改密码
11.1 启动mysql
service mysql start
11.2 登录服务器
mysql -u root -p
11.3 修改密码
set password=password('123456');
12 重新登录MySQL，安装完成

参考：https://blog.csdn.net/qq_31382921/article/details/53696031
https://blog.csdn.net/wangzhjj/article/details/53980727