LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-05-2014, 02:55 PM   #1
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Rep: Reputation: Disabled
mysql: unrecognized service


Hello ,

I have centos 6 32-bit

when i try to run this command
service mysql start


it give me : mysql: unrecognized service
what shall i do?
 
Old 05-05-2014, 03:48 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 21,198

Rep: Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966
Welcome to LinuxQuestions.

Is mysql installled? The correct syntax is mysqld

Are you logged as root or used su - from a terminal window.
 
Old 05-05-2014, 03:49 PM   #3
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
note : the mysqld give me
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

my log
Code:
140505 16:42:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-05-05 16:42:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-05 16:42:00 5657 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
2014-05-05 16:42:00 5657 [Note] Plugin 'FEDERATED' is disabled.
2014-05-05 16:42:00 5657 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-05 16:42:00 5657 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-05 16:42:00 5657 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-05 16:42:00 5657 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-05 16:42:00 5657 [Note] InnoDB: Using Linux native AIO
2014-05-05 16:42:00 5657 [Note] InnoDB: Not using CPU crc32 instructions
2014-05-05 16:42:00 5657 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-05 16:42:00 5657 [Note] InnoDB: Completed initialization of buffer pool
2014-05-05 16:42:00 5657 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-05 16:42:01 5657 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-05 16:42:04 5657 [Note] InnoDB: Waiting for purge to start
2014-05-05 16:42:04 5657 [Note] InnoDB: 5.6.17 started; log sequence number 6274671
2014-05-05 16:42:04 5657 [ERROR] Aborting

2014-05-05 16:42:04 5657 [Note] Binlog end
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'partition'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'ARCHIVE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_METRICS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_TRX'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'InnoDB'
2014-05-05 16:42:04 5657 [Note] InnoDB: FTS optimize thread exiting.
2014-05-05 16:42:04 5657 [Note] InnoDB: Starting shutdown...
2014-05-05 16:42:07 5657 [Note] InnoDB: Shutdown completed; log sequence number 6274681
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'BLACKHOLE'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MRG_MYISAM'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'CSV'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MEMORY'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MyISAM'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'sha256_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'mysql_old_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'mysql_native_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'binlog'
2014-05-05 16:42:07 5657 [Note] 
140505 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
 
Old 05-05-2014, 03:51 PM   #4
michaelk
Moderator
 
Registered: Aug 2002
Posts: 21,198

Rep: Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966
This bug could be the reason
http://bugs.mysql.com/bug.php?id=71086
 
Old 05-05-2014, 03:54 PM   #5
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
Is mysql installled? yes it is
The correct syntax is mysqld see my log

Are you logged as root or used su - from a terminal window.
root
 
Old 05-05-2014, 04:15 PM   #6
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by michaelk View Post
This bug could be the reason
http://bugs.mysql.com/bug.php?id=71086
Thank you but i don't understand how to use the patch at
https://bugzilla.redhat.com/show_bug.cgi?id=1037650#c6


comment 6
 
Old 05-05-2014, 06:22 PM   #7
michaelk
Moderator
 
Registered: Aug 2002
Posts: 21,198

Rep: Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966
My fault for not fully examining your log messages.
http://bugs.mysql.com/bug.php?id=69677
 
Old 05-06-2014, 06:33 AM   #8
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
[CENTER]
Quote:
Originally Posted by michaelk View Post
My fault for not fully examining your log messages.
http://bugs.mysql.com/bug.php?id=69677
thanx i tired to do following
./scripts/mysql_install_db --defaults-file=my.cnf

bash: ./scripts/mysql_install_db: No such file or directory


this my my cnf


etc/my.cnf
i dont see basedir and lc-messages-dir = /usr/share/mysql
Code:
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
no luck

Last edited by Yazeed98; 05-06-2014 at 09:56 AM.
 
Old 05-06-2014, 10:45 AM   #9
michaelk
Moderator
 
Registered: Aug 2002
Posts: 21,198

Rep: Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966Reputation: 3966
Check the output of the dmesg command. See of SELinux is denying permission to the file.
 
Old 05-06-2014, 11:18 AM   #10
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by michaelk View Post
Check the output of the dmesg command. See of SELinux is denying permission to the file.
Thank you i fix itby uninstall the re install but now i have problem that mysql taking 45% of ram(1gb)
how i can make it light ?
 
Old 05-06-2014, 04:30 PM   #11
VANK1989
LQ Newbie
 
Registered: May 2013
Location: India
Posts: 6

Rep: Reputation: Disabled
Hi Yazeed,

Please replace your my.cnf configuration with bellow.

============
[mysqld]
max_connections = 400
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M


[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

local-infile=0
==========

Once updated your my.cnf file. try to restart mysqld service.

Let me know if you seeing any errors on this.

Regards,
VANK.
 
Old 05-08-2014, 09:58 AM   #12
Yazeed98
LQ Newbie
 
Registered: May 2014
Posts: 29

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by VANK1989 View Post
Hi Yazeed,

Please replace your my.cnf configuration with bellow.

============
[mysqld]
max_connections = 400
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M


[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

local-infile=0
==========

Once updated your my.cnf file. try to restart mysqld service.

Let me know if you seeing any errors on this.

Regards,
VANK.
Thank but after put the code mysqld didn't started it tells me it failed mysql the latest 5.6

Last edited by Yazeed98; 05-08-2014 at 10:02 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
[SOLVED] mysqld: unrecognized service OtagoHarbour Linux - Software 3 02-19-2014 05:04 PM
samba: unrecognized service... help thetotzky04 Linux - Newbie 1 07-25-2009 09:35 AM
dovecot: unrecognized service onik Linux - Software 1 06-26-2008 01:46 AM
xinetd: unrecognized service ??? Why?? stewchcken Linux - Networking 8 07-14-2005 08:23 AM
httpd: unrecognized service ????? dhammika Linux - Software 0 04-28-2004 09:24 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:42 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