• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

starting mysql service

hello there,
my centos v5.6 server came already with mysql service installed but it was installed by rpm and its version 5.1.58.
I have downloaded the latest source code which is 5.5.16 and installed this version located in /opt
now I have stopped mysql and started the new version like this
/opt/mysql5516/etc/mysql.server start

but if I stop and start the service like this (service mysql start) then the old one starts

how can I update this information and also this one.

[(05:22 PM)][(root@alpha)] [(/opt)] $ chkconfig --list mysql
mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off    

so the right mysql start after reboot..
  • 3
  • 2
1 Solution
Randy DownsOWNERCommented:
If you aren't going to use the old version, uninstall it.
yum erase mysql-server

Open in new window

rpm -e mysql-server

Open in new window

Then if you want your version of mysql to be managed by chkconfig, check out the manpage for what is required (start/kill for each runlevel for example) and write a script to start your new version.  You should be able to accomplish that by referencing start up scripts that are currently managed by chkconfig.
XK8ERAuthor Commented:
any way I can setup the new service like
"service mysqld start" for the new mysql and
"service mysql start" for the old one?
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

That's basically the same thing.

service(8)                                                          service(8)

       service - run a System V init script


       service --status-all

       service --help | -h | --version

       service  runs  a  System V init script in as predictable environment as possible, removing most environment vari-
       ables and with current working directory set to /.

       The SCRIPT parameter specifies a System V init script, located in /etc/init.d/SCRIPT.  The  supported  values  of
       COMMAND  depend  on the invoked script, service passes COMMAND and OPTIONS it to the init script unmodified.  All
       scripts should support at least the start and stop commands.  As a special case, if  COMMAND  is  --full-restart,
       the script is run twice, first with the stop command, then with the start command.

       service --status-all runs all init scripts, in alphabetical order, with the status command.

              The directory containing System V init scripts.
XK8ERAuthor Commented:
okay, this is what I did.. is this right?

-(01:45 58 PM)-(root@alpha)-(/etc/init.d) $ service mysql stop
Shutting down MySQL....  

cp /opt/mysql5516/etc/mysql.server /etc/init.d/mysqld

-(01:46 20 PM)-(root@alpha)-(/etc/init.d) $ service mysqld start
Starting MySQL...  

-(01:48 32 PM)-(root@alpha)-(/etc/init.d) $ chkconfig mysql off
-(01:48 02 PM)-(root@alpha)-(/etc/init.d) $ chkconfig --list mysqld
service mysqld supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysqld')
-(01:48 03 PM)-(root@alpha)-(/etc/init.d) $ chkconfig --add mysqld
-(01:48 19 PM)-(root@alpha)-(/etc/init.d) $ chkconfig mysqld on
-(01:48 36 PM)-(root@alpha)-(/etc/init.d) $ chkconfig --list mysqld
mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off
Without knowing the contents of your new init script, I can't tell for sure, but all the commands look correct.

When you run 'service mysqld start' does it start the proper version now?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now