LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-02-2018, 08:35 PM   #1
DennyY
Member
 
Registered: May 2018
Location: San Francisco, CA
Distribution: CentOS 7
Posts: 85

Rep: Reputation: 1
Question can't start mysqld


Hi All,

So I installed mysql-server, and this is what I get:


[root@localhost /]# systemctl status -l mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Sat 2018-06-02 18:28:35 PDT; 59s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1488 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 1462 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 1488 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Error: 2 (No such file or directory)

Jun 02 18:28:34 localhost.Uriah systemd[1]: Starting MySQL Server...
Jun 02 18:28:35 localhost.Uriah systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Jun 02 18:28:35 localhost.Uriah systemd[1]: Failed to start MySQL Server.
Jun 02 18:28:35 localhost.Uriah systemd[1]: Unit mysqld.service entered failed state.
Jun 02 18:28:35 localhost.Uriah systemd[1]: mysqld.service failed.

###my.cnf###
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Did I miss anything?

Thank you,
Denny

Last edited by DennyY; 06-02-2018 at 09:46 PM. Reason: adding more information
 
Old 06-02-2018, 11:11 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,323
Blog Entries: 28

Rep: Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141Reputation: 6141
This thread at another forum looks like it might be helpful: https://www.digitalocean.com/communi...n-t-be-restart

Could you tell us more about your machine? What are the specs, especially the RAM.

Also, take a look at /var/log/mysqld.log; see whether it provides any hints.
 
Old 06-02-2018, 11:39 PM   #3
DennyY
Member
 
Registered: May 2018
Location: San Francisco, CA
Distribution: CentOS 7
Posts: 85

Original Poster
Rep: Reputation: 1
Question mysql logs

Hi,

Here are the last few logs.

It doesn't seem like it's the RAM issue.

Thanks again,
Denny




2018-06-03T04:09:15.677197Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 3906
2018-06-03T04:09:15.749434Z 1 [ERROR] [MY-013090] [InnoDB] InnoDB: Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2018-06-03T04:09:15.749480Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.
2018-06-03T04:09:16.350285Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2018-06-03T04:09:16.350639Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-06-03T04:09:16.350828Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-06-03T04:09:16.351849Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.




Quote:
Originally Posted by frankbell View Post
This thread at another forum looks like it might be helpful: https://www.digitalocean.com/communi...n-t-be-restart

Could you tell us more about your machine? What are the specs, especially the RAM.

Also, take a look at /var/log/mysqld.log; see whether it provides any hints.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
sudo cp -rp ./mysqld ./mysqld.bak cp: cannot stat './mysqld': No such file or directory 5huvoo Linux - Server 5 03-06-2018 02:10 PM
/etc/init.d/mysqld start I could not start the MySQL service on a server Atang2 Linux - Server 2 03-11-2017 11:08 AM
mysqld and selinux? cant start mysqld willc86 Linux - Software 1 04-11-2015 09:19 AM
[SOLVED] MySQL Start Problem::::socket '/var/run/mysqld/mysqld.sock' (2) arun-linux Linux - Software 6 11-29-2012 06:56 AM
mysqld cannot start raixun Linux - Server 4 09-16-2008 06:54 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:11 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration