Re: Can't login mysql with root account!

[Victor Medina]

Hi!
[EMAIL PROTECTED] wrote:


I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian
Packages Site) into my Debian v3.0r2 box! After finished installing, i had
followed the instruction here to change root's password but right after
------8<

Try to do a login without using passwords:

mysql -u root  <--- do not provide a password

REASON: by default the "root" user is allowed to login without password 
from "localhost", even though you provide password.

this action, i can't login to mysql any more! I had also try to change
ownership of /var/lib/mysql and all files and subfolders within this
directory to mysql but still login fail!
---------8<

Providing a error message would be a nice thing to have when trying to 
figure out what's wrong

Best Regards!

--

 |...........................................................|
 |____  _____ ____   _    |Victor Medina M                   |
 |\ \ \| ____|  _ \ / \   |Linux - Java - MySQL              |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]                  |
 |/_/_/|_____|_| /_/   \_\|Tel: +58-241-8507325 - ext. 325   |
 |                        |Cel: +58-412-8859934              |
 |                        |geek by nature - linux by choice  |
 |...........................................................|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]