Re: [cobalt-users] MySQL

[Rodney <rodney@xxxxxxxxxxxx>]

Greetings,
From
http://www.gina.net/mysql/Manual_chapter/manual_Privilege_system.html#Default_privileges

    " The MySQL root user is created as a superuser who can do anything.
Connections must be made from the local host. Note: The initial root
password is empty, so anyone can connect as root without a password and be
granted all privileges.
     An anonymous user is created that can do anything with databases that
have a name of 'test' or starting with 'test_'. Connections must be made
from the local host. This means any local user can connect without a
password and be treated as the anonymous user.
     Other privileges are denied. For example, normal users can't use
mysqladmin shutdown or mysqladmin processlist. "

If on a telnet session you type mysql -u root and can connect, you need to
set the root password...
mysql>SET PASSWORD FOR root=PASSWORD('new_password');

Me thinks,
--Rodney


"Michael D. Bathrick" wrote:

> I'm trying to set up the mysql password, but I need to know the default
> password to do so.