Linux系统安装MySQL基于5.5.6版本RPM安装方式

官方地址: https://dev.mysql.com/downloads/mysql/

百度网盘: https://pan.baidu.com/s/1wztiLM3rK20KiEk1HpJnsQ 提取码:9999

后缀 tar.gz 安装方式: https://www.jianshu.com/p/276d59cbc529

宝塔安装(推荐,省事)

# 安装mysql rmp
# 检查当前系统是否安装过mysql
	rpm -qa | grep -i mysql

# 安装mysqlserver
	rpm -ivh MySQL-server-5.5.48-1.linux2.6.i386.rpm
	如果报错,结果方案 https://blog.csdn.net/qq_45632660/article/details/108023041

# 安装mysqlclient
	rpm -ivh MySQL-client-5.5.48-1.linux2.6.i386.rpm
	
# 查看mysql进程
	ps -ef | grep mysql

# 查看mysql是否安装成功
	mysqladmin --version 查看mysql版本号
	
#  启动mysql服务
	service mysql start
	
#  关闭mysql服务
	service mysql stop

#  修改配置文件位置
	cd /usr/share/mysql/ 进入文件
	cp my-huge.cnf /etc/my.cnf 将my-huge.cnf拷贝到etc里面,用my.cnf代替
	
# 修改mysql密码
	通过登录mysql系统
		1 mysql -uroot -p
        2 Enter password: 【输入原来的密码】
        3 mysql>use mysql;
        4 mysql> update user set password=passworD("密码") where user='root';
        5 mysql> exit; 

#  修改字符集和数据存储路径
	1、1 进入mysql,查看字符集
		show variables like '%char%';
	
	+--------------------------+----------------------------+
	| Variable_name            | Value                      |
	+--------------------------+----------------------------+
	| character_set_client     | utf8                       |
	| character_set_connection | utf8                       |
	| character_set_database   | latin1                     |
	| character_set_filesystem | binary                     |
	| character_set_results    | utf8                       |
	| character_set_server     | latin1                     |
	| character_set_system     | utf8                       |
	| character_sets_dir       | /usr/share/mysql/charsets/ |
	+--------------------------+----------------------------+
	默认的客户端和服务器都用了latin1,所有会乱码
	
	1、2 进入我们刚刚拷贝的配置文件my.cnf里面,修改字符集配置
	default-character-set=utf8
	character_set_server=utf8
	character_set_client=utf8
	collation-server=utf8_general_ci
	default-character-set=utf8
	
# MySQL配置文件路径
	/etc/my.cnf

路径	解释
/var/lib/mysql/	mysql数据库文件的存放路径
/usr/share/mysql	配置文件目录
/usr/bin	相关命令目录
/etc/init.d/mysql stop	启停相关脚本