Problem setting up connection to MySQL



Category : 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

View Replies

Related to : Problem setting up connection to MySQL


Setting connection timeouts for mysql / oracle
Category : Programming Languages

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

View Replies


cPanel/WHM setting up remote mysql connection
Category : Web Hosting
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

View Replies


setting up the mySQL ODBC Source Connection
Category : 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

View Replies


Does the setting time_out in mysql affect JDBC connection pool?
Category : Databases

It's usually set to 60 seconds.


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


View Replies


Database Connection to MySQL times out even after setting c3p0.testConnectionOnCheckout=true
Category : Programming Languages

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


View Replies


com.mysql.jdbc.Driver problem - setting up mysql
Category : Programming Languages

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,

View Replies


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?
Category : Programming Languages

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:



View Replies


Problem setting SQL connection in ASP.Net
Category : Programming Languages
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

View Replies


php-mysql connection problem mysql-pconnect..
Category : Linux
Hi i have redhat -el3 . php-4.3.2. mysql - 5.0.18 standard. php was already pre-installed while installing redhat . recently, i installed mysql . now, when i am accessing a php web page in a project , the message Fatal error: Call to undefined function: mysql_pconnect() is displayed in the browser.

View Replies


Help! MySQL Connection Problem (mysql.sock)
Category : Web Hosting
I can manage MySQL thru phpMyAdmin, but can not connect to MySQL using the function on my php file:
mysql_connect ("localhost", $myid, $mypd);
The error message is :

Quote

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .