On Sun, 27 May 2001, David Loszewski wrote:
>
> when you first install mysql server does it assign a default password
> becuase it tells me to enter these in to make a password for my server,
> but I don't know what the heck to do with them, but when I try them it
> says access denied
>
> /usr/bin/mysqladmin -u root -p password 'new-password'
> /usr/bin/mysqladmin -u root -h Precious -p password 'new-password'
>
>
> Dave
Bonjour,
You can set a root-password starting the server with
safe_mysqld --skip-grant-tables &
then connect to mysql:mysql -u root
then: mysql> update user set password=password(the-password-I-want) where
user = 'root';
You use the password() function to set a new password.
--
jean-michel
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
