Re: Server configuration denies access to data source

[Martin Gainty]

You need to create the user and grant permissions try (username=teva):
INSERT INTO user (Host,User,Password) VALUES ('%', 'teva',
PASSWORD('your_password'));
and finally add access to the database
INSERT INTO db (Host,Db,User)
VALUES('%','NameOfDatabase','teva');

Hope this helps,
- Original Message -
From: Rodolfo Ricci [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 6:32 PM
Subject: Server configuration denies access to data source


 I'm trying to use mysql with java, I create a short
 piece of code to make a conection but when the class
 run it sends an exception:
 Server configuration denies access to data source
 I can use the database using mysql client without
 problem.
 Could someone help me, or ask me where i find the
 listins from this mailing list? I guess this kind of
 error was reported before.

 thanks...
 Rodolfo Ricci

 ___
 Yahoo! Mail
 Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus,
proteção contra spam.
 http://br.mail.yahoo.com/

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Server configuration denies access to data source

[Simon Green]

It is the code that closes the connections (pconnect)
So it would be good to have a look at client first...

MySQL should have no problme with upto 1000 connetions...more if you are not
on Linx..

I hope this helps you or some one else...

Simon 


-Original Message-
From: Core Dumped [mailto:[EMAIL PROTECTED]]
Sent: 17 January 2002 15:42
To: [EMAIL PROTECTED]
Subject: Server configuration denies access to data source


Ok, i think i've found the cause of my problem and maybe your too !
In fact my MySQL doesn't close opens conections and he doesn't let me open 
an another one...and so throw me an exception. If i'm waiting few minutes 
before opening new connections, it's working, so just check your 
'connection timeout' value or find another way to close all those unclosed 
connections.
Good luck again !


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php