I now have two mysqld processes running on my server (Freebsd / apache), and no mysql (according to a ps command).
What is the safe way to kill these two, and restart mysql? Ian ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 8:56 PM Subject: Re: New Setup > Ian, > Wednesday, April 24, 2002, 5:04:15 AM, you wrote: > > IP> Using the commands you have offered... > > Egor>> Your 'root' user doesn't have GRANT privilege ... > Egor>> > Egor>> You should change Grant_priv to 'Y' > Egor>> You can do this using UPDATE statement: > Egor>> UPDATE user SET Grant_priv='Y' WHERE user='root'; > > IP> I get this response...... > > IP> ERROR 1017: Can't find file: 'user.frm' (errno: 2) > > The user, that MySQL is running as, doesn't have permissions > on the MySQL data dir ... > > IP> ----------------------------------------------- > IP> Endeavouring to run mysqld as per....... > > Egor>> or you run mysqld with "--skip-grant-tables" option and set Grant_priv > Egor>> using GRANT statement: > Egor>> GRANT ALL ON *.* to 'root'@'localhost' identified by > Egor>> 'password_obscured' WITH GRANT OPTION; > > IP> myslqd tells me it's it is ready for input..... > IP> But I'm not sure what to input? > > 1. Connect to the MySQL server. > 2. Execute FLUSH PRIVILEGES. > 3. GRANT ALL ON *.* to 'root'@'localhost' identified by > 'password_obscured' WITH GRANT OPTION; > 4. Disconnect from the MySQL server. > 5. Shut down MySQL server and start it again in the normal mode > (without the "--skip-grant-tables" option). > > IP> Ian > > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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