[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] Mysql root
- Subject: Re: [cobalt-users] Mysql root
- From: "Steve Werby" <steve-lists@xxxxxxxxxxxx>
- Date: Wed Nov 27 05:17:02 2002
- Organization: Befriend Internet Services LLC
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
"Ivo Depoorter" <i.depoorter@xxxxxxxxxxxxxx> wrote:
> I messed up with mysql, by accident i revoked the rights for the root
> user on the main mysql database. Is there a way i can restore mysql to
> its original state on my raq 550? Data is not important, we are only
> trying somethings in combination with php. Or can i reïnstall mysql from
> een fresh rpm?
Stop MySQL. Probably /etc/rc.d/init.d/mysql stop
Find mysqld binary. whereis mysqld or locate mysqld. It's probably
/usr/sbin/mysqld.
su - mysql
/usr/sbin/mysqld -Sg ( /usr/sbin/mysqld --help to see what this does, also
see MySQL manual at mysql.com).
Update the password for user root. Then issue a FLUSH PRIVILEGES statement.
Exit.
Kill MySQL. killall mysqld
Restart MySQL. Probably /etc/rc.d/init.d/mysql start.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/