Re: [cobalt-users] MySQL

["Michael D. Bathrick" <prez@xxxxxxxxxxxxx>]

Unfortunately I get a 

	"ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

when I try that - I never changed the password on installing MySQL last
week.  

Mike

On Thu, 4 May 2000, Rodney wrote:

> 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.
> 
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>