NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
MySQL DB Client Problem


Joined: 08 Jan 2007
Posts: 1
Reply with quote
Hello,

I have recently purchased PhpED and I am having problems with a MySQL Database.

The thing is, it is working perfectly with the DB-Form Wizard - it connects and builds a PHP form file perfectly.

However, when I try to browse the database using the DB-Client pane I get:

"Could not connect using Mylogin@Mydomain
1045 access denied for user 'myUsername'@'myip'
(using password: YES)"

As stated before, my login IS correct, my user is set to all privileges, and the DB server is set to accept all remote connections.

Thanks in advance for any help.
View user's profileFind all posts by WazzoSend private messageMSN Messenger
Site Admin

Joined: 13 Jul 2003
Posts: 7881
Reply with quote
Quote:
As stated before, my login IS correct

Dear Wazzo,
I think that your login is not correct, yet.
MySQL recognizes your client IP and when you connect from another location it means that you use another login even though the username is the same.
For example if you try to login from the same machine using localhost and supply a _WRONG_ password, you'll see "myUsername@localhost" instead of "myUsername@myip".
To make mySQL wrorking properly you have to _CREATE_ new login with 'myUsername'@'myip' or update existing login in the usertable with % in place of hostname so it will look like this "myUsername@%"

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website
MySQL DB Client Problem
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic