How To Install MySQL on CentOS

Failed to start server, this is erorr information

code

```Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[root@centos-512mb-sfo1-01 ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
 Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
 Active: failed (Result: start-limit) since Thu 2016-12-08 12:16:10 UTC; 13s ago
 Process: 17625 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
 Process: 17604 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: Failed to start MySQL Server.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: Unit mysqld.service entered failed state.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: mysqld.service failed.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: mysqld.service holdoff time over, scheduling ...rt.
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: start request repeated too quickly for mysqld...ice
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: Failed to start MySQL Server.
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: Unit mysqld.service entered failed state.
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: mysqld.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
[root@centos-512mb-sfo1-01 ~]# journalctl -xe
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: Unit mysqld.service entered failed state.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: mysqld.service failed.
Dec 08 12:16:09 centos-512mb-sfo1-01 systemd[1]: mysqld.service holdoff time over, scheduling restar
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: start request repeated too quickly for mysqld.servi
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: Unit mysqld.service entered failed state.
Dec 08 12:16:10 centos-512mb-sfo1-01 systemd[1]: mysqld.service failed.

```code```

Hi, Thanks for the very details steps. I was able to follow all the way to the sudo mysql_secure_installation under Step 3: Configuration. I got an erro saying “Error: Access denied for user ‘root’@‘localhost’ (using password: YES)”. I know I entered the correct temporary password I found from the log file. Also, I realized that I got the same error no matter what password I used. So this appears to be a problem with the user name itself.

Any help is appreciated.

i am getting the same error ,

Thanks for the very details steps. I was able to follow all the way to the sudo mysqlsecureinstallation under Step 3: Configuration. I got an erro saying “Error: Access denied for user ‘root’@‘localhost’ (using password: YES)”. I know I entered the correct temporary password I found from the log file. Also, I realized that I got the same error no matter what password I used. So this appears to be a problem with the user name itself.

Any help is appreciated.

i also tried the

If you skip Step 3 (for now) and try to connect with the first command in Step 4, mysqladmin -u root -p version you should also be prompted for the root password. If you enter the temporary password from the log file, are you able to connect?

no luck same error.

pz help

Hi,

After the step “mysql_secure_installation” i always get an “Estimated strength of the password: 0” What could it be the problem? can I disable this plugin?

Another brilliant article. Thanks for sharing!

Excellent article. Thanks for sharing!

If you have 1GB ram, and use some of it for some process, like tomcat, then service starting may fail because of insufficient memory. You can create swap memory to solve this problem.

here a solution: https://stackoverflow.com/a/13999800/167288

Hi,

I have followed the installation guide and it seems that it hangs when I start the sql server for the first time. Below is a record of the status. Please assist. Thanks.

[root@iZwz92280sqlsr3912i7atZ ~]# sudo systemctl status mysqld mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled) Active: activating (start) since Mon 2018-07-23 12:16:43 CST; 4h 54min ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 27963 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0 /SUCCESS) Main PID: 28033 (mysqld) CGroup: /system.slice/mysqld.service ââ28033 /usr/sbin/mysqld

Hello, when I go in step 3, you give me the following error, please can you help me solve it.

Error: Access denied for user ‘root’@‘localhost’ (using password: YES) [root@processagile ~]# mysqladmin -u root -p version Enter password: mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘root’@‘localhost’ (using password: YES)’

Thank you,

I have a problem with this tutorial, after i md5sum mysql80-community-release-el7-3.noarch.rpm command to verify the output is ‘4e07071a356ec12db0d09e1cdd739250 mysql80-community-release-el7-3.noarch.rpm’ that not equals with value on https://dev.mysql.com/downloads/repo/yum/ and then i cannot proceed to install mysql on my server, please help me.