Try
# mysql -u root
which will work only if you have no password set for the mysql root user.
Then
mysql> SET PASSWORD FOR root=Password('xxxxx');
mysql> quit
Then your other commands should work as they are written.
Felix
> -----Original Message-----
> From: Richard Hayes
> To: [EMAIL PROTECTED]
> Sent: 01/08/2002 10:39
> Subject: [SLUG] MySQL userid / password problem
>
> Dear list,
>
> I am trying to install an accounting package that uses a MySQL database.
>
> The installation instructions say:
>
> "5a Setup MySQL database
>
> mysqladmin -u root -p create bw_accounting "
>
> So, when I try to do it I get an error eg
>
> [root@plaza /root]# mysqladmin -u root -p create bw_accounting
> Enter password:
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> [root@plaza /root]#
>
> I have never created a MySQL admin account therefore it does not have a
> password. How do I create a admin account?
>
> Am I totally off the mark?
>
> regard,
>
> Richard Hayes
>
> --
> SLUG - Sydney Linux User's Group - http://slug.org.au/
> More Info: http://lists.slug.org.au/listinfo/slug
>
>
> -------------------------------------------------------------------------
> This message may contain privileged and/or confidential information
subject
> to a confidentiality agreement or copyright material of Clarity
> International Ltd or third parties. You should only re-transmit,
distribute
> or commercialise the material if you are authorised to do so.
> If you are not an authorised recipient of this email, please contact
Clarity
> International Ltd immediately by return email or by telephone on
+61-2-9925
> 5000.
> In such case, you may not read, print, store, copy or deliver this message
> to anyone, and you should not act in reliance on this email or any
> attachment to it.
> Clarity provides no warranty that the material contained in this email or
> any attachment to it is free from any virus, defect or error. Opinions in
> this message are those of the sender and unless stated otherwise, are not
> endorsed by Clarity.
> --
> SLUG - Sydney Linux User's Group - http://slug.org.au/
> More Info: http://lists.slug.org.au/listinfo/slug
>
--
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug
