How to stop mysql server in Suse

vitalstrike82 · 05-19-2008, 07:58 AM

Greetings,
currently i'm starting the database server using this command
/usr/local/mysql/bin/mysqld_safe --user=mysql &

However i want to stop the database, what commands do i need to enter?

These are the files inside the /usr/local/mysql/bin

Code:

LinuxCM:/usr/local/mysql/bin # ls
comp_err           mysql_config                mysqlshow
innochecksum       mysql_convert_table_format  mysql_tableinfo
msql2mysql         mysqld_multi                mysqltest
myisamchk          mysqld_safe                 mysqltestmanagerc
myisam_ftdump      mysqldump                   mysqltestmanager-pwgen
myisamlog          mysqldumpslow               mysql_tzinfo_to_sql
myisampack         mysql_explain_log           mysql_upgrade
my_print_defaults  mysql_find_rows             mysql_upgrade_shell
mysql              mysql_fix_extensions        mysql_waitpid
mysqlaccess        mysql_fix_privilege_tables  mysql_zap
mysqladmin         mysqlhotcopy                perror
mysqlbinlog        mysqlimport                 replace
mysqlbug           mysql_install_db            resolveip
mysqlcheck         mysql_secure_installation   resolve_stack_dump
mysql_client_test  mysql_setpermission

Thanks in advance

reddazz · 05-19-2008, 08:46 AM

One solution to your problem is to setup mysql as a service. In the mysql installation tarball, there should be a script called mysql-server (or something similar). Copy that to /etc/init.d and name it "mysql" (you may need to edit it, so that the mysql user is the same as the one you setup on your system and that the path to mysql is the same as the one on your system). After that do

Code:

#chkconfig --add mysql
#chkconfig mysql on

You can then manage mysql using the "service" command e.g.

Code:

service mysql start
service mysql stop
service mysql status