current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

-3
votes
1answer
15 views

user accounts while working in databases with php [on hold]

When writing php scripts how many users should you have for your database. I'm sure your not logging into the database as root from your script like most of the examples show. What is the correct way ...
0
votes
1answer
9 views

Latest MySQL driver found in the remote repository

I installed mySQL database 5.6 and I want to include the dependence of the driver but I could not find the repository of this dependence (the latest version is 5.1). If I download the driver (jar) ...
1
vote
0answers
12 views

HOST is not blocked in MYSQL, even after getting too many connection errors

I have 2 Server , Server 1 -- 192.168.1.157 and Server 2 -- 192.168.1.158. Server 2 can access Server 1 MySQL. I'm trying to connect to Server 1 MySQL with wrong credentials and getting this error: ...
0
votes
3answers
25 views

Error : null value being entered in table through jsp code

My code snippets are as below : ShopRegister2.jsp : <% session = request.getSession(); session.setAttribute("s_id", s_id); out.println("Your id is : "+s_id); %> ...
0
votes
0answers
28 views

How to use JdbcInterceptor to retry queries

I want to retry MySql queries in cases of deadlock which will be removed if I can simply retry. I use apache tomcat jdbc pool library for mysql connection pooling and it has concept of ...
0
votes
4answers
30 views

Unknown column error in where clause, using MySQL and Java

Following is my code line : ResultSet rs3 = stmt6.executeQuery("SELECT * FROM ShopSystem.Order where s_id="+s_id+" AND status="+Pending); I am getting the following error : Unknown column ...
0
votes
2answers
32 views

How do I use Ruby to connect to a MySql database outside of Rails as a scripting language

Hi Im using Ruby as a scripting language. Not for web development, but to connect to a local database on my computer and manipulate it. Id like to know how I can connect. Do I need to download/import ...
-1
votes
0answers
34 views

android studio display mysql values

I am tryinf to display a list of mysql values in my android app. I have searched through google about the way how to do it but no success. I have: lista.php //load and connect to MySQL database ...
0
votes
1answer
15 views

android studio doesn't connect with mysql db when configured with usb device

I am trying to connect my android app with mysql db. If I do it through emulator it is connected successfully, but when try with usb device (tablet) it doesn't. It shows this error: 07-29 ...
0
votes
1answer
40 views

Android studio application connection with mysql

I am trying to connect my android studio app with mysql database but I am having some troubles during this. I have made a simple login and also php files wich connect with db. public class ...
-6
votes
1answer
45 views

Best server side technology for mobile apps [closed]

I have to develop a mobile app (Android & iOS) that connects to a database hosted in a server. I would like to know: Best server-side technology, java, php, asp, ruby... Is a good option to ...
-2
votes
1answer
17 views

Changing a global MySQL db file to MySQLi db file from PHP 4 to PHP 5.4

I have always used the following for MySQL database connection for procedural coding not OO running on PHP 4 and now I am moving some old websites to PHP 5.4: <?php global $db_user; global ...
0
votes
0answers
30 views

Send data from one Database on my server to another?

I'm sorry if this a common knowledge, and I don't think I know the right terms to be searching for. When an order is placed on my website I want to send the information to the database of my web app ...
0
votes
0answers
20 views

Is it necessary to close a mySQL connection [e.g. with mysqli_close()], if so WHEN and WHY? [duplicate]

I've seen some posts that about debugging errors associated with mysqli_close(), more then once ive users have responded saying that it is not really necessary to close a connection? If its not ...
0
votes
1answer
17 views

MySQL connection works for Workbench but not Tomcat Application using same credentials

I am working on a remote Redhat system over SSH. Tomcat 7 and MySQL 5.5 server are both installed and appear to be running correctly. I can connect to MySQL from a local install of Workbench over SSH ...
1
vote
0answers
47 views

2003: Can't connect to MySQL server on '127.0.0.1:3306' (99 Cannot assign requested address)

I am running a python2.7 application that performs "inserts" into a single mysql/mariadb instance on a multi-core 64 bit CentOS(or ubuntu) machine. as soon as the parallel processes/cores exceed 4 or ...
0
votes
3answers
17 views

Connection Closed even when the connection is closed below the code

I have a basic code snippet below but it is not working.What may be the problem with it. public List<String> getStores() throws SQLException{ List<String> store_id=new ...
0
votes
1answer
22 views

php mysql connect fails even though shell client succeeds

I have a weird problem. I'm trying to connect from a linux host to a remote MySQL server on a Windows host. If I try to connect from shell using the mysql client it works perfectly. #mysql -h ...
-2
votes
4answers
35 views

Parse error: syntax error, unexpected '<'

I'm new to this PHP and MySQL world. I've been given an assignment about simple system. But i got this error and i don't know how to fix it. Hope you guys can help me. <?php include ...
0
votes
0answers
41 views

Visual Studio 2013 connection to local MySQL Database

Getting right to the point, I'm learning Visual Basic, and I want to connect Visual Studio 2013 Express to a local MySQL database that I have running on the default 3306 port. For now I would be ...
0
votes
0answers
24 views

cannot connect to mysql database with hostgator asp.net

I have created a asp.net (c#) website & used MySql as the database. I choose hostgator as my hosting provider. In hostgator i created the mysql database using myphpadmin. The website is running ...
0
votes
1answer
18 views

creating connection class to use over code base

I have 2 files. Connect.php and AddUser.php. I am trying to use the mysqli connection established in connect to insert data to my database from within AddUser. I feel like I have all the pieces in ...
1
vote
1answer
27 views

Mysql connection with Visual C++

I have spent already 4 days trying to understand how to connect from VS 2012. My program is written on C++, it connects to Mysql and insert in it records from text file. Problem: 1) I cant ...
-1
votes
2answers
54 views

Form validation and mysql database connection

I'm working on a project (PHP/MySQL) , but i have a problem in the validation of a from data. when i submit the information , i did not find it in my database ( PHPmyadmin ).i think it's a connection ...
1
vote
0answers
43 views

MySql.Data.MySqlClient.MySqlConnection.Open() taking a long time

I have a mvc .net4 website, connecting to mysql, on page load i run a query (which cannot be avoided) for which MySql.Data.MySqlClient.MySqlConnection.Open() is very slow in worst case taking 15 ...
0
votes
1answer
27 views

Connection to MySQL server fails

I'm trying to access a database from the default Linux MySQL client, but all I get is a timeout. It's actually the database used by a WordPress website, and in the configuration file I can see that ...
0
votes
1answer
29 views

MySQL Connection Close is not Closing the connection .NET

Hi and thanks for reading. My English is poor, so i hope that you understand me. I have an MySQL Connection, that open and close the connection, that let me read, write, delete and all the SQL ...
3
votes
2answers
118 views

c3p0 maxIdleTime is same as wait_timeout of mysql?

I am having an Spring MVC + Mysql (JDBC 4) + c3p0 0.9.2 project. In c3p0 maxIdleTime value is 240 (i.e 4 mins.) and wait_timeout in my.ini of Mysql to 30 seconds. According to c3p0 maxIdleTime: ...
0
votes
1answer
26 views

Possible MySQL sudden error

Hello friends from SO! Alright, this time I have a little bit more complex problem. We have a web crawler running and functioning normally during most of the day and time. However, from time to ...
0
votes
0answers
42 views

Lost connection to MySQL server during query For Huge DB Table

I have a mysql database which have huge amount of entries in two tables(one with around 5 milions, another with >25 milions). Interesting thing, after importing all the data, I started facing this ...
1
vote
1answer
38 views

Can I use database IP address instead of hostname in JDBC connector?

Currently none of my hostnames are resolving to my server which uses no-ip DDNS related to this issue. Is it possible to use the server IP address instead of the DDNS domain name in the JDBC ...
1
vote
1answer
74 views

How to connect Liferay Portal with mysql database using eclipse?

I have Liferay 6.2 and i want to connect with mysql database using eclipse IDE.How to connect them and what i have to use. Please give me any example for startup.
0
votes
0answers
33 views

Unable to connect password protected MySQL Database using PHP

I have a website hosted at godaddy (say "abc.co.in"). After having logged into cpanel through my cpanel id and password (say "siteid" and "sitepw" respectively), i went ahead and created a MySQL ...
0
votes
0answers
39 views

mysqli::query(): MySQL server has gone away - php and mysql

Fatal error: Uncaught exception 'ErrorException' with message 'mysqli::query(): MySQL server has gone away in functions.php on line 2108' ErrorException: mysqli::query(): MySQL server has gone away ...
0
votes
0answers
32 views

MySQL remote SSH Connection using .NET C#

Below is a screenshot from MySQL workbench. The parameters are not real, but the structure shown here is exactly as per my real connection which is working nicely. I am trying to connect to this ...
0
votes
2answers
43 views

Connection string read from textbox

I'm trying to make my mysql connection string read from textbox instaid of direct string what i was trying to do is this string myConnection = "datasource='" + this.label12 + "';username='" + ...
1
vote
0answers
30 views

ASP - MYSQL connection error randomly appears

I have built a website using asp classic on my own hosted win2k server using iis5 for my asp file and MySQL 5.6.11 which is hosted on a separate win7 home premium machine. When accessing the website ...
0
votes
1answer
40 views

PHP: connect with external mysql database

I want to connect with external database using PHP. But, it gives this error Warning: mysql_connect(): Can't connect to MySQL server on 'SERVER_IP_ADDRESS' (110) in ...
-1
votes
4answers
29 views

Connection to database in NetBeans unsuccessful (error ora-00933)

For school project I'm doing Music player using a simple database (for name, artist, length, album...) and I've done it 1/2 already but now when I'm trying to connect to school database it gives me an ...
0
votes
2answers
40 views

Python: Dealing with MySQL connect hanging

I am starting a large number of python jobs simultaneously on a cloud computing provider (about 320 jobs). Each of the python jobs makes a few connections to a MySQL server when they start. The ...
0
votes
0answers
107 views

Connection between visual studio & mysql in wamp server

I am using Visual studio . And i want to connect c# to MySql in wamp server. How to make connection ? Can any one tell me about this with screens shots. Thanks in advance.
0
votes
1answer
24 views

Error S1000 trying to execute more MySql queries in a Java Application

I have a problem trying to execute more than one query into my Java Application code. I have a procedure that is called in main and is in the class "Fant": public void XXX(){ Connectivity ...
0
votes
1answer
43 views

Trouble with using globally defined variables: 'Use of undefined constant'

I have this code: <?php $db_initiallized = false; $db_connection = NULL; function db_init() { global $db_initiallized, $db_connection; if(!$db_initiallized) //error occurs on this line ...
0
votes
2answers
18 views

difference between creating data base in microsoft access using netbeans and creating database in mysql

what is the difference between creating data base in microsoft access using netbeans and creating database in mysql. is it the same ? Please help me.. i dun understand.
0
votes
2answers
24 views

Array Out Of Bounds exception in java net beans IDE 8.0 while connecting jTable with MySQL database

I have a table with 7 columns and I'm trying to connect my database with it so as to receive data from the database and show it in the table. The code works fine when you press the button the first ...
1
vote
0answers
13 views

Cannot convert new database connection to older one

I need to convert this new database connectivity and retrive information from database to older fashion for my project. I have done the connection according to older fashion way PHP 4.0 but i need to ...
0
votes
1answer
44 views

I can open a mySql connection, but not a particular db

I am able to open a MySQL server connection like this: $con = mysqli_connect("localhost", "$username", "$password") which confirms that the user and password are correct. However, this doesn't ...
0
votes
2answers
61 views

MySql ConnectionString without Database name to create a database in c#

I have got a situation where i do need to create a database into MYSQL by using the connection string needed to get into mysql server.Till Now i have used connectionstring with database names .So in ...
0
votes
2answers
55 views

Java database applicaion Freezing when loading lots of records

I need some advice from you more experienced coders with an issue I am having. I created a Java SE application which deals with data stored locally on a MySQL server. It works fine where there are ...
0
votes
2answers
35 views

Warning: mysql_select_db(): Access denied for user

the below error i m getting: Warning: mysql_select_db(): Access denied for user 'nativepl'@'localhost' (using password: NO) in /home/nativepl/public_html/testing/search.php on line 177 Warning: ...

1 2 3 4 5 … 14