解决linux（centos7）重新安装mysql systemctl start mysqld.service时报错

重新安装mysql时，运行

systemctl status mysqld.service

报错。

[root@test-dcruxue ~]# systemctl start mysqld.service

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

查看mysql服务状态

[root@test-dcruxue ~]# systemctl status mysqld.service

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.serviceenabledvendor preset: disabled)

Active: failed (Result: exit-code) since Tue 2018-07-17 16:14:22 CST8min ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 17451 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)

Process: 17376 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 16428 (code=exited, status=1/FAILURE)

Jul 17 16:13:41 test-dcruxue systemd[1]: Starting MySQL Server...

Jul 17 16:14:20 test-dcruxue mysqld[17451]: Initialization of mysqld failed: 0

Jul 17 16:14:20 test-dcruxue systemd[1]: mysqld.service: control process exited, code=exited status=1

Jul 17 16:14:22 test-dcruxue systemd[1]: Failed to start MySQL Server.

Jul 17 16:14:22 test-dcruxue systemd[1]: Unit mysqld.service entered failed state.

Jul 17 16:14:22 test-dcruxue systemd[1]: mysqld.service failed.

无果；

遂想到查看日志：cat /var/log/mysqld.log

2018-07-17T08:23:01.745601Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

2018-07-17T08:23:01.745607Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

2018-07-17T08:23:01.745619Z 0 [ERROR] Aborting

发现3306端口被占用

[root@test-dcruxue ~]# ps aux|grep mysql

root 9861 0.0 0.0 113252 1600 ? S 14:52 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-table

mysql 10009 0.0 5.6 1585376 457120 ? Sl 14:52 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-table --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

root 17563 0.0 0.0 112648 956 pts/2 R+ 16:32 0:00 grep --color=auto mysql

然后杀掉进程

[root@test-dcruxue ~]# kill -9 10009

就ok了

注册表删老要重启，才能安装

另外尝试

在如下图这一步的时候把勾去掉：

然后找到MySQL安装目录下的bin文件夹下的“MySQLInstanceConfig.exe”程序，右击属性如下图设置：

双击MySQLInstanceConfig.exe”程序一步一步下来安装。

你之前装过了就会有一个MySQL的服务，现在你重新装它就提示你MySQL这个服务已经存在了，你可以取别的名字作为MysQL服务，也可以把之前的MysQL服务卸载掉。

怎么卸载？先停止服务：net stop mysql

c:\mysql\bin\mysqld.exe -remove

控制面板和安装目录中删除

重启，删除安装目录残余的信息

---