mysql problem

chancho · 2007-03-08 08:35:14

i have set up an account "chancho" with host = "%" and password = "123".
when i type
>mysql
i can login without password, status show 'chancho@localhost', however
>mysql -u chancho -p
>password 123
then i got an error of Access deny for user 'chancho@localhost' (Using password : YES).
it also happen when i try to use phpmyadmin to login.

any idea ??

noriko · 2007-03-08 09:16:07

i may be wrong on this, but if you are able to login without a password, it seems to me that there really is no password for that account.
only thing i can advice is to create another account and see if it works. or delete that account and create it again.

chancho · 2007-03-08 09:24:22

i create one account "dummy" with password "dummy" and host "localhost"
this time
>mysql -u dummy -p
>password dummy
and i can login.
so, the problem seems to be related to "localhost".

chancho · 2007-03-09 01:31:26

i think i have found the problem.
when i only create one account with host=%, my login will only fit "chancho@localhost" which require not password.
therefore, i create another account with same name and host="localhost" with password. this time my login ok.

solution :
create a pair of accounts with same login name, different host (%, localhost) and same password.

chancho · 2007-03-10 02:54:52

i found that mysql is not auto enable in the php package

solution :
uncomment the follow line in /etc/php.ini
extension=mysql.so

Arch Linux

#1 2007-03-08 08:35:14

mysql problem

#2 2007-03-08 09:16:07

Re: mysql problem

#3 2007-03-08 09:24:22

Re: mysql problem

#4 2007-03-09 01:31:26

Re: mysql problem

#5 2007-03-10 02:54:52

Re: mysql problem

Board footer