Dear Marek, Phillip and all, Frist I would like to say thanks to Marek, Phillip and someone help me before ! Finially, the server is running ( need to use the command #mysql --host=192.10.0.113).
But I still have some question would like to ask, if you don't mind ! How I can set a different user to run MySQL (only root can run this program now) ? bash-2.03$ ./mysql --host=192.10.0.113 bash: ./mysql: Permission denied Thanks a lot, Kevin Chan > <Phillip B. Bruce Wrote> >Kevin, >If you have forgotten the root user password for MySQL, you can restore it with >the following procedure: > > 1.Take down the mysqld server by sending a kill (not kill -9) to the mysqld >server. The pid is stored in a .pid file, which is normally in the MySQL > database directory: > > kill `cat /mysql-data-directory/hostname.pid` > > You must be either the Unix root user or the same user the server runs as >to do this. > 2.Restart mysqld with the --skip-grant-tables option. > 3.Connect to the mysqld server with mysql -h hostname mysql and change the > password with a GRANT command. See section 4.3.1 GRANT and > REVOKE Syntax. You can also do this with mysqladmin -h hostname -u user > password 'new password' > 4.Load the privilege tables with: mysqladmin -h hostname flush-privileges or > with the SQL command FLUSH PRIVILEGES. > Note that after you started mysqld with --skip-grant-tables, any usage of GRANT > commands will give you an Unknown command error until you have > executed FLUSH PRIVILEGES. > <Marek Zaradzki Wrote> > mysql --host=192.10.0.113 > or > mysqladmin --host=192.10.0.113 status --------------------------------------------------------------------- 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
