java code to connect to database using mamp server

Java code to connect to database using mamp server install#

The connection to WAMP is fine but on MAMP Pro, I get the following error. I am trying to connect from java to a MySQL database from an external computer on a machine hosting WAMP and other hosting MAMP Pro. ('JavaMySQL at line 250: SQLException: ' + ex_try.getMessage()) Connecting to MySQL from Java to WAMP / MAMP Pro. showStatus('ID: ' + id + ' e-mail: ' + e_mail) // only with JDK 6 Values = 'ID: ' + id + ' e-mail: ' + e_mail

IDs = new int // increase the number of elements of array IDs by 1

String e_mail = rset.getString('e_mail') String values // declare an array of Strings String e_mails // declare an array of Strings Rset = stmt.executeQuery('SELECT * ' + 'FROM obj_user') JavaMySQL at line 250: SQLException: null, message from server: 'Host '192.168.0.1' is not allowed to connect to this MySQL server'Ĭlass.forName('').newInstance() Ĭonn = DriverManager.getConnection('jdbc:mysql://192.168.0.1:8889/objects_der?user=root&password=root') My Java Applet calling JavaMySQL.jar is giving me the following on Java console: I succeed to access to acces database 'object_user' and query my 'obj_user' table. You can use PDO (object oriented):

Java code to connect to database using mamp server install#

$link = mysql_connect('192.168.0.1:8889', 'root', 'root') We recommend MAMP for an easy way to install a current version of PHP that works. With the following php line I have no problem to connect to the MySQL server: MySQL server is MySQL 5.0.19 running on localhost as OS is MacOSX 10.4.8 and Java version is 1.5.0_07 I'm running Apache/2.0.59 (Unix) PHP/5.1.6 DAV/2 on port 8888 and mySQL on port 8889 with the predigested MAMP application.