[DBExpress] Invalid username/password after some queries under XP

Hello

I'm using DBExpress under D6 to connect to a MySQL database. My
application works fine under windows 2000 but I receive a "DBX error:
invalid username/password" under windows XP after doing some queries.
Does anybody have any way to solve this issue ?

Thanks,
--
Nicolas FERRANDINI
R&D Manager
SiAutomation
Tel : +33 (0)4 67 03 37 00
Fax : +33 (0)4 67 03 37 20
Web site : http://www.siautomation.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

connecting phpmyadmin to a remote db

------=_NextPart_000_0039_01C5150C.E4FA0AB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have a dedicated DB box running mysql 4.0.21.

I'm installing php my admin on my web server to access the database on the
other machine but I keep getting an error. The error is as follows:



"phpMyAdmin tried to connect to the MySQL server, and the server rejected
the connection. You should check the host, username and password in
config.inc.php and make sure that they correspond to the information given
by the administrator of the MySQL server.



#1130 - Host 'WebServer01' is not allowed to connect to this MySQL server"



This is using phpMyAdmin Version 2.6.1



Any suggestions as to what I have done wrong? It seems like php my admin is
setup properly but the database isn't allowing the connection to occur.
What am I doing wrong here and what areas can I check to trace this down?



Thanks,

Dan


------=_NextPart_000_0039_01C5150C.E4FA0AB0--

Re: connecting phpmyadmin to a remote db

I think this is phpMyAdmin related issue. I have never
tried it myself but you can use SQLyog
(www.webyog.com)

I prefer to use it over other MySQL GUI tools. They
even have a FREE version :)

Karam
--- Danny Willis
wrote:

> I have a dedicated DB box running mysql 4.0.21.
>
> I'm installing php my admin on my web server to
> access the database on the
> other machine but I keep getting an error. The
> error is as follows:
>
>
>
> "phpMyAdmin tried to connect to the MySQL server,
> and the server rejected
> the connection. You should check the host, username
> and password in
> config.inc.php and make sure that they correspond to
> the information given
> by the administrator of the MySQL server.
>
>
>
> #1130 - Host 'WebServer01' is not allowed to connect
> to this MySQL server"
>
>
>
> This is using phpMyAdmin Version 2.6.1
>
>
>
> Any suggestions as to what I have done wrong? It
> seems like php my admin is
> setup properly but the database isn't allowing the
> connection to occur.
> What am I doing wrong here and what areas can I
> check to trace this down?
>
>
>
> Thanks,
>
> Dan
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: connecting phpmyadmin to a remote db

This error is probably related to the GRANT permissions of your MySQL
Server, it is rejecting the connection because the Host you're
connecting from is not allowed in the host table. You should configure
your server to allow this user to connect from this server, using any
admin, or using grant syntax, check the manual on how to use GRANT at
mysql console (/bin/mysql).

If you don't have access to the server, contact your admin and ask for
permissions.

Best regards,

PS: Grant works like this:
grant all privileges on .