Hi Kevin, There is a way to sop the server on OS level. However I am not sure if you want to do it this way. You can use the kill command, but be aware that it might damage a data file if the database is accessing it in just this moment.
Having said this warning, here is what you can do: 1) ps ax |grep mysqld to display the process ID. You will get something like 704 ? SW 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid 756 ? S 0:01 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 923 ? S 0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 2) kill -9 <processid) That WILL stop the mysqld demon. In case you see several processes (which is more likely), just start wit the first processid shown. 3) Check again with "ps ax |grep mysqld" that ALL processes stopped. 4) proceed as described in my previous e-mail. 5) After having setup the rights for the "root" user. you should make sure that all database files are intact (myisamchk etc) Best regards Nils Valentin Tokyo/Japan 2003年 7月 7日 月曜日 11:16、Kevin H. Phillips さんは書きました: > Hi, Nils > I can't get the mysql server to stop! If I try "service mysqld stop" I > get a "FAILED" error. If I try mysqladmin -u root -p shutdown, I get: > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' > [EMAIL PROTECTED] root]# > > If I try shutting down without using a password, I get a message saying > that access is denied; I need shutdown privileges for this operation. > > I have pinged the server and it *says* that it is "alive". > > Perplexing problem, no? > > Kevin > > Nils Valentin wrote: > > 2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました: > >>Hi Kevin, > >> > >>try this: > >> > >>1) stop the mysql server > >>2) mysqld_safe --skip-grant-tables > >>3) mysql -u root > >>4) mysql> SHOW GRANTS FOR root; > >>5) GRANT ALL ON *.* TO 'root'@'%'; > > > > GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; > > > > > > sorry for the mistake. > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > >>6) restart the server (without --skip-grant-table option) and try to > >> login > >> > >>Best regards > >> > >>Nils Valentin > >>Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
