linux mysql 安装启动失败_【已解决】linux服务器下 mysql 安装好后启动失败

安装mysql

# sudo wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

# 查看  rpm -qpl mysql-community-release-el7-5.noarch.rpm

# 安装  sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

sudo rpm -ivh http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

sudo rpm -ivh http://repo.mysql.com/mysql-community-release-el7-X.noarch.rpm #安装最新的rpm 然后去repo里修改5.6 enable=1

sudo yum install -y mysql mysql-server

# sudo yum install -y mysql-community-client.x86_64 mysql-community-server.x86_64

[root@localhost ~]# systemctl start mysql

[root@localhost ~]# systemctl enable mysql

配置Mysql SLOW QUERY LOG #超时设置

存放位置：/var/log/mysql

#建立目录    [yangzm@v-ndj ~]$ sudo chown mysql:mysql /var/log/mysql -R

systemctl stop mysqld

编辑my.cnf    #3s比较合适；

[root@localhost etc]# sudo vi my.cnf

#添加

slow_query_log = 1

long_query_time = 3

slow_query_log_file = /var/log/mysql/mysqld_slow.log

[yangzm@v-lnmp var]$ sudo mkdir -p /var/log/mysql

[yangzm@v-lnmp var]$ sudo chown mysql:mysql /var/log/mysql -R

[yangzm@v-lnmp var]$ sudo systemctl restart mysqld

# ------------------------------------------------------

systemctl start mysql