Centos7安装Mysql

下载 mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

安装 mysql 软件源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

安装MySQL

yum install mysql-community-server

启动MySQL服务

systemctl start mysqld

设置开机启动

 systemctl enable mysqld
 systemctl daemon-reload

修改root默认密码

先找到默认密码  

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

之后登陆修改密码 

 mysql -uroot -p 

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

添加远程登录用户

GRANT ALL PRIVILEGES ON *.* TO 'zhetang'@'%' IDENTIFIED BY 'ZHEtang403---------' WITH GRANT OPTION;

 

Linux中将当前目录所有文件移动到上一级目录

mv * ../

安装mysql 报错

 

//导入sql有问题时：

#vi /etc/my.cnf

//在[mysqld]下增加

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

首先看文件是否存在

find / -name mysql.sock

重启mysql

service mysql  restart

service mysqld restart

如果重启失败，注意失败内容可能提示运行命令查看详情错误