linux上安装mysql

linux上安装mysql

Mysql安装

• 下载
  https://www.mysql.com/
• 解压

tar -zvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
	tar是一种打包格式，gz是一种压缩方式
解压后的文件
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm

• 安装

安装之前需要卸载linux安装的musql，在centos7中mysql叫做mariadb
	rpm -qa | grep -i "mariadb"
	sudo rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
开始安装rpm包，注意包与包之间存在依赖关系，需要按照顺序安装
 1. sudp rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
 2. sudp rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
 3. sudp rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
 4. sudp rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
 5. sudp rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

• mysql的初始配置

1. 检查mysql数据存储位置 /var/lib/mysql 是否有内容，数据存储位置参考:/etc/my.cnf中的datadir配置
	如果有内容，就把它给删除
2. 初始化数据据
	sudo mysqld --initialize --user=mysql
3. 启动mysql的服务
	sudo systemctl start mysqld
	sudo systemctl status mysqld 查看状态
4. 查看mysql随机生成的密码
	sudo cat /var/log/mysqld.log | grep "password"
5. 连接mysql
	mysql -uroot -pQldbwiFc%8Ff
6. 修改密码
	set password=password('root');

通过windows去连接linux上的mysql

一般情况下，xindows无法直接去连接linux上的mysql，因为mysql对连接做了限制，只能本地的ip才能连接到，所以我们要修改一些配置
1、use mysql;
2、select host,user,authentication_string from user;
	主机地址 用户名 加密后的密码
3、update user set host='%' where user='root';
	% ：表示任意的主机都能连接到MySQL
4. 刷新
	flush privileges;