Access Denied - I cant login to MySQL!

[CheekyChino]

Just wondering why i am unable to login to MySQL. I've created my user and all. But it still wont allow me to connect. I am able to login as root. To create my user i did this:

grant all privileges
on *.*
to adixon@"%"
identified by 'password'
with grant option;

mysql -h 127.0.0.1 -u adixon -ppassword

ERROR 1045: Access denied for user: 'adixon@localhost' (Using password: YES)

Anyone got ideas on why this could be happening?

Also when i try to install MySQL as a service. It says "Failed to install service".

 

[likelylad]

try using the username root and leaving the password blank

 

[CheekyChino]

I just found out that i can use any username without a password and it will work. That being the user is in the users table. BUT it should work with a password:S

Any ideas?

 

[likelylad]

It might be easier to use a GUI package if you are relatively in-experienced in MYSQL

I use a program called 'MYSQL Front'
The program is longer being developed but you can still find it on the web somewhere.

Use the root username and no password to log into the MYSQL database.

Using MYSQL-Front you can set usernames and password and what database etc people can have access to

Hope this helps