MYSQL安装

MYSQL安装

####mysql官网：传送门
####mysql下载地址：下载传送门
安装环境

系统	centos7
mysql	5.7或8.0

##安装

###新增yum源

enabled=1是开启，=0是关闭
如果是centos6,需要将yum源里面baseurl改为/el/6/

$ vim /etc/yum.repos.d/mysql-community.repo

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=0
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

开启 mysql57-community的yum源

$ yum-config-manager --enable mysql57-community

关闭 mysql57-community的yum源

$ yum-config-manager --disable mysql57-community

查看 开启的mysql源

$ yum repolist enabled | grep mysql
mysql80-community/x86_64            MySQL 8.0 Community Server              15

###安装MYSQL

$ yum install mysql-community-server -y

启动mysql

$ systemctl start mysqld.service

停止mysql

$ systemctl stop mysqld.service

查看mysql状态

$ systemctl status mysqld.service

获取登陆密码

$ grep 'temporary password' /var/log/mysqld.log

登陆

$  mysql -uroot -p
Enter password: 
......
mysql>

出现下面的界面代表登陆成功，首次登陆必须要修改密码密码要求必须要大些字母，小些字母，数字和特殊符号

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';	

默认登陆配置

$ mysql -h 127.0.0.1 -P 3306 -u root -p

默认数据库配置外部无法访问

外部登陆需要赋予权限,并刷新权限表

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

或者用
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;

如果还是无法访问通过，查看机器监听IP端口和防火墙配置

修改配置文件来改变数据库配置和优化数据库配置,详解

$ vim /etc/my.cnf

---

###问题
####问题一：
Requires: libsasl2.so.2()(64bit)

$ yum insatll cyrus-sasl-lib -y

####问题二:
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

gdgcheck=1的时候会去校验本地gpg key，但是本地没有
$ vim /etc/yum.repos.d/mysql-community.repo
gpgcheck=0

####问题三:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '' WITH GRANT OPTION' at line 1

mysql>update user set host = '%' where user = 'root';

####问题四:
mysql_install_db is deprecated. Please consider switching to mysqld --initialize

$ mysqld --initialize

####问题五:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

$ chown -R mysql:mysql /var/lib/mysql