Arch Linux

Ramses de Norre

Member

From: Leuven - Belgium

Registered: 2007-03-27

Posts: 1,289

MySQL wont let me in

I'm having a strange issue. I'm trying to set-up mysql to test a database front-end on my laptop, I installed mysql and set the root password with

mysqladmin -u root password PASS

Now I can login with

mysql -u root -pPASS

but this does not work:

 mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

How come I can't just enter the password in the prompt? I don't like typing it in the terminal where it is visible...

The daemon is running fine because I can log in when given the passwd directly at the prompt. anyone an idea what could be going on here?

Sin.citadel

Member

Registered: 2008-01-22

Posts: 267

Re: MySQL wont let me in

it could be a problem with the mysql client, try downgrading if possible, otherwise, use a gui client or phpmyadmin if all else fails.