Problem setting up connection to MySQL


Triumph
HOME ยป Databases

Hey guys and gals,
I am a noobie to programming and these boards so first greetings to everyone. I started learning html/css/php/mysql a couple of weeks ago and think I am progressing nicely but as I got into databases I started having some set up problems. A couple of stats:
Mac OSX Mountain Lion
XAMPP 1.8.3-3
PHP 5.5.9.
I am learning from TheNewBoston tutorials and all the code from their videos there worked fine - untill I tried connecting to a database with mysql_connect function. Sometimes it worked, sometimes it didnt but after a while I learned about the deprecated functions and the new mysqli class. This is what I am trying to do - I have a

Related to : Problem setting up connection to MySQL
Problem setting up connection to MySQL
by Triumph in Databases
Hey guys and gals,
I am a noobie to programming and these boards so first greetings to everyone. I started learning html/css/php/mysql a couple of weeks ago and think I am progressing nicely but as I got into databases I started having some set up problems. A couple of stats:
Mac OSX Moun
setting up the mySQL ODBC Source Connection
by matt.s in Databases
I just recenty installed phpdev ... it includes the php server and mysql
The php server runs great and is executing scripts when I go to http://localhost
but I cant seem to get the mySQL database working properply
I installed MyODBC-standard-3.51
but when I go to ODBC Data Source
Setting connection timeouts for mysql / oracle
by Colin Henry in Databases

Hi,
I was wondering how you go about setting the connection timeout for both a mysql and oracle DB connection in php?

cPanel/WHM setting up remote mysql connection
by Rob Wright in Databases
cPanel/WHM setting up remote mysql connection
 
I get this error:

Quote:




ERROR 1064 (42000) at line 1: You have an error in your SQL synta
Does the setting time_out in mysql affect JDBC connection pool?
by cautionsign in Databases

It's usually set to 60 seconds.


But I think con pool will hold the connection, so is there any conflict? Thank you.


Database Connection to MySQL times out even after setting c3p0.testConnectionOnCheckout=true
by Alpha0mega in Databases

I have an app that uses hibernate (v3.6.4) , with connection pooling provided by C3P0 (v0.9.1.2) .


The problem is I get a JDBC communications link failure if I make a DB query , if the app process ( and hence the C3P0 pool ) has been running for more time than the MySQL wait_timeout


com.mysql.jdbc.Driver problem - setting up mysql
by walkur in Databases

I cannot get mysql working with Tomcat 4.1.30. I put the jar file
mysql-connector-java-3.0.11-stable-bin.jar
in my server/lib folder and set the lib folder at my classpath. I used
Class.forName("com.mysql.jdbc.Driver");
in my jsp file, but upon execution,
I have a page that uses a mysql connection. How can i make 1 mysql request using a new connection without messing up the current connection?
by alphamars in Databases

I currently have a page that is something like this


<?php
mysql_connect(...);
mysql_query('the pages queries');
### here ###
mysql_query('the pages queries');
?>

but where it says ### here ###, i basically want to do this:


TAGS: have page that uses mysql connection
Problem setting SQL connection in ASP.Net
by ussballantyne in Databases
hello,
I am using following code to open a sql connection (SQL server 7.0)
constr = "data source=itekserver01;Database=Prototype;uid=sa;pwd=;integrated security=SSPI"
If con.State = ConnectionState.Closed Then
con.ConnectionString = constr
con.Open()
End
SetConnectionPreferenceOverride problem setting connection
by BofRA in Databases
hi
i'm trying to use CCommDbOverrideSettings class
for setting/overwrite the Connection preferences.
but i'm missing something on the start connection process .
as the parameter pass to the start function of the RConnection class is of type TConnPref
but the parameter o
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .