can connect to server even if the username and pwd is wrong!!

[spookie]

Hi,

I am connecting to MySQL server thru my PHP script.
The thing is whatever i supply as parameter for username and password for mysql_connect(), it gets connected to the server.
What i want is to create a new user (well i have already created that) and using that userid connect to mysql server.

Any suggestions why this is happeneing?

TIA





--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[sleipnir214]

Does the anonymous user exist on your system?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[spookie]

No.I am only having root as a user.
Meanwhile i tried to connect with the new user created and even if the pwd is same, it gives me error "permission denied to username..."
At this time no matter whtever username and pwd i use, it connects to the server.
I will just try and play with the system next week.

Any help is most welcome!!

TIA


--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[tshot]

it is not clear. u say u cannot coonect with a new user and next line u say u can connect.

for anonymous user check user table in mysql database. the user tuple would be blank




----------------
ur feedback is a very welcome desire