Search My Techie Guy

Friday, September 22, 2017

Error Response - mysqld: unrecognized service on Oracle Linux Server release 6.9

Summary: 

Am installing Cacti on Oracle Linux Server release 6.9 and MySQLD is among the many dependencies required.
I used "yum install cacti" but it installs all other dependencies apart from MySQLD (MySQL Server)!
so i was trying to run "service mysqld start" after the cacti + dependencies installation and got the error below.

Problem or Goal: 

[root@~]# service mysqld start
mysqld: unrecognized service

Cause: 

Turns our "yum install cacti" doesn't automatically install MySQL server.

[root@~]# rpm -qa | grep mysql
mysql-libs-5.1.73-8.0.1.el6_8.x86_64
nagios-plugins-mysql-2.2.1-4git.el6.x86_64
mysql-5.1.73-8.0.1.el6_8.x86_64
php-mysql-5.3.3-49.el6.x86_64


Solution: 

Install MySQL server again using "yum install mysql mysql-server" and try again.

[root@]# yum install mysql mysql-server
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Package mysql-5.1.73-8.0.1.el6_8.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.x86_64 0:5.1.73-8.0.1.el6_8 will be installed
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.73-8.0.1.el6_8.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================================================
 Package                                        Arch                                   Version                                              Repository                                    Size
===============================================================================================================================================================================================
Installing:
 mysql-server                                   x86_64                                 5.1.73-8.0.1.el6_8                                   ol6_latest                                   8.6 M
Installing for dependencies:
 perl-DBD-MySQL                                 x86_64                                 4.013-3.el6                                          local_oel6.5                                 133 k

Transaction Summary
===============================================================================================================================================================================================
Install       2 Package(s)

Total download size: 8.7 M
Installed size: 25 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql-server-5.1.73-8.0.1.el6_8.x86_64.rpm                                                                                                                       | 8.6 MB     00:08     
(2/2): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm                                                                                                                            | 133 kB     00:00     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                          877 kB/s | 8.7 MB     00:10     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                                                                           1/2 
  Installing : mysql-server-5.1.73-8.0.1.el6_8.x86_64                                                                                                                                      2/2 
  Verifying  : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                                                                           1/2 
  Verifying  : mysql-server-5.1.73-8.0.1.el6_8.x86_64                                                                                                                                      2/2 

Installed:
  mysql-server.x86_64 0:5.1.73-8.0.1.el6_8                                                                                                                                                     

Dependency Installed:
  perl-DBD-MySQL.x86_64 0:4.013-3.el6   

Complete!                   

Problem Solved?

[root@]# service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mtnsspebu password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

                                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

[root@]# service mysqld status
mysqld (pid  1113) is running...


No comments: