Go Premium for a chance to win a PS4. Enter to Win


MySqld disabled in systemctl but MySqlClient works

Posted on 2014-01-03
Medium Priority
Last Modified: 2014-01-05
I am in the process of installing lampserver on Fedora 20 apache and php were  straightforward.

MySql is proving more problematic I used yum install mysql-server

Everything went fine and I ended up with Complete!

I then entered service mysqld start

I received a message to copy support-files/mysql.server to the right place for your system

When I tried to find these files I couldn't find them anywhere and I didn't know where to copy them to.

Typing systemctl there is no mention of mysqld at all, but systemctl list-unit-files lists mysqld.services as disabled (in red)

ps -ef grep mysqld gives this output

mysql     5740     1  0 18:48 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql     5922  5740  0 18:48 ?        00:00:08 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
root      6243  2218  0 20:30 pts/0    00:00:00 grep --color=auto mysqld

All of the references to mysqld are in red

However I can sign into MySql and when I show databases I get
| Database           |
| information_schema |
| mysql              |
| performance_schema |
| test               |
and I can select from tables as well

I would like to start the mysqld service have it running correctly and continue with my development tasks.

If anybody can help I would very much appreciate your effort

Thanks in anticipation of yoour support

Question by:johnecollins
  • 3
LVL 35

Accepted Solution

gr8gonzo earned 2000 total points
ID: 39754964
mysqld_safe is the proper, correct wrapper service. It looks like you're running it correctly.

Author Comment

ID: 39755303
Hi Great can I call you that? ;-)

Thank you very much for responding I am new to Linux and I find it hard to comprehend that it can run whilst the monitor says it is disabled.

I have contemplated uninstalling MySql and starting again but I wouldn;t know how to do that.

If you  have any other thoughts I would be pleased to hear you have to say



Author Comment

ID: 39755352
In the original post there is mention of a log file this is the contents of the log file:-

140103 12:45:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140103 12:45:48 InnoDB: The InnoDB memory heap is disabled
140103 12:45:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140103 12:45:48 InnoDB: Compressed tables use zlib 1.2.8
140103 12:45:48 InnoDB: Using Linux native AIO
140103 12:45:48 InnoDB: Initializing buffer pool, size = 128.0M
140103 12:45:48 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
140103 12:45:48  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140103 12:45:48  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
140103 12:45:49  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140103 12:45:50  InnoDB: Waiting for the background threads to start
140103 12:45:51 Percona XtraDB (http://www.percona.com) 5.5.34-MariaDB-31.1 started; log sequence number 0
140103 12:45:51 [Note] Plugin 'FEEDBACK' is disabled.
140103 12:45:51 [Note] Server socket created on IP: ''.
140103 12:45:51 [Note] Event Scheduler: Loaded 0 events
140103 12:45:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.34-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
140103 18:48:36 [Note] /usr/libexec/mysqld: Normal shutdown

140103 18:48:36 [Note] Event Scheduler: Purging the queue. 0 events
140103 18:48:36  InnoDB: Starting shutdown...
140103 18:48:37  InnoDB: Shutdown completed; log sequence number 1597945
140103 18:48:37 [Note] /usr/libexec/mysqld: Shutdown complete

140103 18:48:37 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
140103 18:48:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Author Closing Comment

ID: 39757653
I have got to the bottom of this after some considerable time, despite running yum install mysql-server,  I have ended up with a maria db.
I am concerned that I followed instructions to get something I know quite well, from use in Windows and got something different.
This is more than a little disconcerting, as I have spent time, trying to figure out what was going on when I do have something that appears to work.

Thanks Jon for your contribution I am grateful that you read it and your comments have helped me to decide what I need to do to achieve progress in my project


Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
I have written articles previously comparing SARDU and YUMI.  I also included a couple of lines about Easy2boot (easy2boot.com).  I have now been using, and enjoying easy2boot as my sole multiboot utility for some years and realize that it deserves …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Suggested Courses
Course of the Month10 days, 14 hours left to enroll

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question