i just answered my own question:::
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement:
shell> mysql -u root mysql
mysql> SET PASSWO
Greetings.
I just installed mySQL( mysql-3.23.29a-gamma-sun-solaris2.8-sparc) on a
E150 using the script mySQL/configure..
One of the msg that was printed was to change the root password.
however to change the root password you need to know the original
password(s).
What are the default pas
