linux 安装mysql5.6版本 步骤
1.卸载老版本MySQL
find / -name mysql
rm -rf 上边查找到的路径,多个路径用空格隔开 #或者下边一条命令即可 find / -name mysql|xargs rm -rf
2.解压文件
可以这样先下载软件包
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
tar -zxvf mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz -C /usr/local
3.删除安装包,重命名解压后的文件
cd /usr/local
mv mysql-5.6.31-linux-glibc2.5-x86_64 mysql
4.添加mysql用户组和mysql用户
groupadd mysql
useradd -r -g mysql mysql
检车mysql组是否存在 groups mysql
5.安装
cd /usr/local/mysql/
mkdir ./data/mysql
chown -R mysql:mysql ./
注意:
确保/etc/init.d/mysqld的这个(mysqld)文件不存在,以及/etc/my.cnf这个(my.cnf)文件不存在
存在的话则删除:
rm /etc/init.d/mysqld
rm /etc/my.cnf
./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
出现如下结果:表示离成功很近了****
( ./bin/mysqladmin -u root password ‘new-password’)
(./bin/mysqladmin -u root -h hadoop000 password ‘new-password’)
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
cp support-files/my-default.cnf /etc/my.cnf
#修改启动脚本
vi /etc/init.d/mysqld
#修改项:
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/mysql
#启动服务
service mysqld start
可能出现的问题:解决办法
https://blog.csdn.net/xujiali5172923/article/details/51507589
#测试连接
./bin/mysql -u root -p
修改密码步骤:
https://www.cnblogs.com/mmx8861/p/9062363.html
此时安装的mysql会出现中文乱码(???),解决办法
https://blog.csdn.net/zl834205311/article/details/81703560
https://blog.csdn.net/hengrjgc/article/details/19249095
#加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile
#启动mysql
service mysqld start
#关闭mysql
service mysqld stop
#查看运行状态
service mysqld status
##给root账户开启远程登陆
GRANT ALL PRIVILEGES ON * . * TO ‘root’@’%’ IDENTIFIED BY ‘youpassword’ WITH GRANT OPTION;
https://blog.csdn.net/forever_insist/article/details/80871249
centOS6安装最新版MySQL8, 以及远程连接
https://blog.csdn.net/qq_32125629/article/details/80660737