Yeah, I wish it were that easy. I have attempted to do so, and here is a transcription of my recent events to catch you up to me: ...and by the way thanks, john
I was working in MySQL under user:john, which has direct privelages to all features of MySQL. ...Anyway thinking I was root, I called on "init.d" and told mysql to stop. [john@ns1 bin]$ /etc/rc.d/init.d/./mysql stop Killing mysqld with pid 25268 kill: (25268) - Not owner [john@ns1 bin]$ /etc/rc.d/init.d/./mysql start [john@ns1 bin]$ kill 25268: Operation not permitted Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended Then I attempted to start mysql and was notified I was not authorized. DOH, I am logged in as john. So, I su'd and told mysql to start, and mysql said no, aint gonna do it, not in those terms, but to be more specific: [john@ns1 bin]$ su Password: [root@ns1 bin]# /etc/rc.d/init.d/./mysql start [root@ns1 bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended .....looking around for some hint: went to dir mysql ls -la revealed the following: ns1.acculock.com.err and .ns1.acculock.com.err.swp mv'd the files to the test dir and attempted to restart, but mysql bombed again with the same message from start, and recreated the files. .....looking for answers: ps aux revealed the following: USER PID %CPU %MEM SIZE RSS TTY STAT START TIME COMMAND root 8374 0.0 0.0 1668 0 ? SW Oct 28 0:00 (safe_mysqld) [root@ns1 init.d]# kill 8374 (returns after nothing was done) ps aux revealed the same after attempt to kill process. Whew! someone, please? help? John >From: Todd Williamsen [mailto:[EMAIL PROTECTED]] >Wow John... Sounds like you are in deep chit... Just kidding... Linux 6 >doesn't say which distro it is, same with mysql 3, there are a bunch of >mysql version3s out there. >Your problem... >Log into as root then restart it. >>-----Original Message----- >>From: john [mailto:[EMAIL PROTECTED]] Please help with ignorance, I was in mysqld making some changes to a database. I run a Linux 6 box with MySQL 3 on it. I was logged in as user john, who has all access privelages to mysqld. John is not root, and I told mysql to stop. Well, mysql will not start again. What can I do? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
