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
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 PASSWORD