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: 'root@localhost' (Using password: YES)'
> [root@mail 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: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
