Dwight Tovey wrote:
Brent Anderson wrote:
Hello.
I'm developing a client application for several platforms that will
need to connect to a remote MySQL database. Unfortunately, MySQL
refuses connections from external IP's that aren't allowed and since
the clients using this will be on unknown IP
Brent Anderson wrote:
> Hello.
>
> I'm developing a client application for several platforms that will
> need to connect to a remote MySQL database. Unfortunately, MySQL
> refuses connections from external IP's that aren't allowed and since
> the clients using this will be on unknown IP addresses
GRANT (ALL|SELECT|INSERT|UPDATE|DELETE|etc) ON DATABASE.* TO
'user'@'%' IDENTIFIED BY 'password'
See http://dev.mysql.com/doc/refman/5.0/en/grant.html for details.
Note that localhost is considered as a special case, not included in
the wildcard %
HTH,
Dan
On 12/13/06, Brent Anderson <[EMAIL P
Hello.
I'm developing a client application for several platforms that will
need to connect to a remote MySQL database. Unfortunately, MySQL
refuses connections from external IP's that aren't allowed and since
the clients using this will be on unknown IP addresses (their home
computers), I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Deepak Vishwanathan wrote:
| Hi,
|
|
|
| I am writing a thread safe connection pool class. I want to connect to
| MySQL through jdbc driver. In the initialization method, I write a
| method that makes connections to the database and stores them in a
|
Hi,
I am writing a thread safe connection pool class. I want to connect to
MySQL through jdbc driver. In the initialization method, I write a
method that makes connections to the database and stores them in a
vector. When, I try making the 99th connection, MySQL throws an error
that says "java.
-->-Original Message-
-->From: Steven [mailto:[EMAIL PROTECTED]
-->RedHat Linux 7.3
-->MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as
well)
-->Apache 1.3.27
-->PHP 4.3.1
-->
-->(most (99%) of the MySQL connections are made through PHP scripts
-->running as an apache mod
Hi all,
I have been having a problem with MySQL lately on my machine - I
apologize for the long post. Specs are:
RedHat Linux 7.3
MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well)
Apache 1.3.27
PHP 4.3.1
(most (99%) of the MySQL connections are made through PHP scripts
runn
