If you want to set the root password you can do the next thing
1. kill the mysqld
2. start mysqld with --skip-grant-tables option
3. set the new password with
mysqladmin -u root password 'RogerTheRabbit'
command
4. and finally - mysqladmin -h hostname flush-privileges
instead of 3 and 4 you can do this
3. Run mySQL client - mysql -u root
4. USE mysql;
UPDATE user SET password=PASSWORD("RogerTheRabbit") WHERE user =
"root";
FLUSH PRIVILEGES;
Ivan
----------------------------------------------
http://alas.matf.bg.ac.yu/~mr02014/
----------------------------------------------
One World, one Web, one Program
-- Microsoft promotional ad
Ein Volk, ein Reich, ein Fuhrer
-- Adolf Hitler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
