SAE's System Administrator writes:
> Hello all,
>
> I just installed a Suse 7.2 Linux, with MySql..
> MySQL runs, but when i try to access it, i get the following message:
>
> cleopatra:/usr/bin # mysql -h localhost -u root -p
> Enter password:
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
> cleopatra:/usr/bin # mysql -h localhost -u root -p
> Enter password:
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> is there any way to change/reset the password if any or am i doing
> something wrong ?
>
>
>
>
>
> --
> Best regards,
> SAE's System Administrator
> [EMAIL PROTECTED]
> World Council of Hellenes Abroad
> 2 Komotinis str.
> 54655 - Thessaloniki
> GREECE
HI!
There is a chapter in our manual on what to do when you have
forgotten root password.
It resolves to starting mysqld with --skip-grant-tables option,
UPDATEing root password with PASSWORD() function and restarting MySQL
server.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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