LinuxQuestions.org - How to stop mysql server in Suse

- SUSE / openSUSE (https://www.linuxquestions.org/questions/suse-opensuse-60/)

- - How to stop mysql server in Suse (https://www.linuxquestions.org/questions/suse-opensuse-60/how-to-stop-mysql-server-in-suse-643227/)

How to stop mysql server in Suse

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

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