Menu
I want to connect from java, to a database which i am currently managing from phpMyAdmin. I do not own the server which the database runs.
however, i want to find the connection string of that database, in order to be able to communicate with my database using java.
Does anyone knows how to find that connection string?
841
Right-click on your connection and select "Properties". You will get the Properties window for your connection. Find the "Connection String" property and select the "connection string". So now your connection string is in your hands; you can use it anywhere you want.
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;Database=myDataBase;User=myUsername;Password=myPassword; The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL.
If you have access to the phpMyAdmin PHP files, then you can look into the config.inc.php file, there is the config of the database connection.
151
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
