Solved

MySqld disabled in systemctl but MySqlClient works

Posted on 2014-01-03
4
408 Views
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

John
0
Comment
Question by:johnecollins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 35

Accepted Solution

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

Author Comment

by:johnecollins
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

Thanks

John
0
 

Author Comment

by:johnecollins
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: '0.0.0.0'.
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
0
 

Author Closing Comment

by:johnecollins
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

John
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
remote mysql 8 53
can i read my emails on lamp ftp 4 70
postfix start error! 9 86
Checking what device is using certificate to access internal site? 4 57
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Creating and Managing Databases with phpMyAdmin in cPanel.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

751 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