Manasi Save wrote:
Hi All,
I am really not sure whether this question should be asked here or not
but I am hoping that someone must have faced this problem.
My Servers are losing connections with database because of inactivity
and on next activity I am getting following error :-
"The las
Hi All,
I am really not sure whether this question should be asked here or not but I am
hoping that someone must have faced this problem.
My Servers are losing connections with database because of inactivity and on
next activity I am getting following error :-
"The last packet successfully r
or die(mysql_error());
I also tried it with host also designated 127.0.0.1...
$link = mysql_connect ("127.0.0.1" , "127.0.0.1" , "") or die(mysql_error());
mysql_select_db ("WebServer", $link) or die(mysql_error());
Access denied for user ''@'
ditions-computer.local
global
ALL PRIVILEGES
Yes
Yet I can't write a database connection using "chestnut" as the
usernameexcept for the table "test." This is what its privileges look like:
Use
lter_routine_priv='Y',
Create_user_priv='Y',
ssl_type='',
ssl_cipher='',
x509_issuer='',
x509_subject='';
flush privileges;
Adjust all privileges accordingly.
- Original Message ---
#x27;,
ssl_cipher='',
x509_issuer='',
x509_subject='';
flush privileges;
Adjust all privileges accordingly.
Is you MySQL properly installed ???
Can you login to mysql client as root from your localhost ???
- Original Message -
How would you write a database connection for a database on which you haven't
yet established a username or password? None of the following work:
$link = mysql_connect ("localhost" , "root" , "") or die(mysql_error());
mysql_select_db ("test&
Hassan Schroeder wrote:
Gobi wrote:
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here is what I have done:
and I created the following servlet, TestSQL:
It's possible the
Xiaobo Chen wrote:
I am not sure if you're trying to connect from outside of your office
newwork. If you try 'telnet' using 3306 (forgot the syntax, check the
Mysql site)outside your office network and if you couldn't get
through,(otherwise you will get some garbage characters) then you can't
co
I am not sure if you're trying to connect from outside of your office
newwork. If you try 'telnet' using 3306 (forgot the syntax, check the
Mysql site)outside your office network and if you couldn't get
through,(otherwise you will get some garbage characters) then you can't
connect to the database
Xiaobo Chen wrote:
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Yes, I am trying to connect in localhost. I did 'nmap localhost' and
port 3306 is open and I can connect to mysqld with mysql client. I will
try putting 3306 after the host when I get
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
> Not sure if this is the place to ask but hopefully someone can help me
> here. I am setting an application system and have successfully setup
> MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
Not sure if this is the place to ask but hopefully someone can help me
here. I am setting an application system and have successfully setup
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here i
nks in Advance.
>
> Regards,
> Narasimha
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 04, 2004 11:00 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Database Connection using DSN
>
> Hi.
> Se
8:00 PM
> To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
> Cc: [EMAIL PROTECTED]
> Subject: Re: Database Connection using DSN
>
> Isn't that a question only for the general list. Cross posting is
> not the nicest possible behaviour.
>
> Andrey
>
> [EMAIL PRO
lto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 11:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Connection using DSN
Hi.
See:
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
When you call mysql_real_connect you use mysqlclient library,
which connects to server directly (you don'
Hi.
See:
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
When you call mysql_real_connect you use mysqlclient library,
which connects to server directly (you don't need to configure ODBC).
To connect using DSN, you should use ODBC API. ODBC and MySQL
are completly different things. M
Hi,
I would like to know how to connect to the mysql database using a
DSN in mysql API's. I am using myodbc 3.51 driver.
Used the following API code for the connection
MYSQL *link = mysql_init(NULL);
MYSQL *connectHandle =
mysql_real_connect(link,"localhost","root","","test",0,N
remotely, but it looks like I'm
going to have to put two dozen copies of it online!
Thanks.
>
> > -Original Message-
> > From: David Blomstrom
> [mailto:[EMAIL PROTECTED]
> > Sent: 27 June 2004 20:49
> > To: [EMAIL PROTECTED]
> > Subject: Da
m a Windows machine to Linux remember to watch for
case sensitivity problems.
HTH
Peter
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: 27 June 2004 20:49
> To: [EMAIL PROTECTED]
> Subject: Database Connection Questions
>
>
> I&
I'm previewing local pages with a database connection
that looks something like this:
@mysql_connect ("localhost" , "USERNAME" ,
"PASSWORD");
@mysql_select_db ("DATABASE");
I modified it for an online site and published it
online. But when I
Hi all,
I am using MyODBC-3.51.06 and mysql-4.1.1-alpha. I connect to the database using a COM
C++ Object and query through ADO recordsets.
But the database connection changes inconsistently. I checked the MySQL logs and
discovered that "Init DB mysql" call is made which c
ED]><[EMAIL PROTECTED]>[EMAIL PROTECTED] wrote:
To: "Gerald R. Jensen"
Cc:
Sent: Wednesday, December 25, 2002 12:36 PM
Subject: Re: Unable to establish database connection via PHP3
It is Personal Web Server -- but I am not sure whether any special
configuration is necessary
Don't know anything about PWS ...
- Original Message -
From: "Mohammed Fouwaaz" <[EMAIL PROTECTED]>
To: "Gerald R. Jensen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 25, 2002 12:36 PM
Subject: Re: Unable to establish da
This is a PHP issue.
I don't recall the version when MySQL support became standard, but
PHP3 is too old to be of much use. Especially with the new
features for security introduced in PHP 4.2.0.
Your best bet is to upgrade to a current release of PHP. That way
you'll have MySQL support built-in
PHP?
- Original Message -
From: "Mohammed Fouwaaz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 25, 2002 11:59 AM
Subject: Unable to establish database connection via PHP3
Hello mysql gurus
I am fairly new to mysql and php3.
mysql server is running ok
Did you configure your web server (Apache?) for MySQL and PHP?
- Original Message -
From: "Mohammed Fouwaaz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 25, 2002 11:59 AM
Subject: Unable to establish database connection via PHP3
Hello my
Hello mysql gurus
I am fairly new to mysql and php3.
mysql server is running ok and I created a table and inserted a few records.
php3 is also working ok and I am able to run a regular 'Hello World' script.
BUT when I include a phpinfo() and call that -- I don't see an entry
with the extension
On Tuesday 24 December 2002 17:47, Lalit Chandwani wrote:
> multiple database connection
> on windows 98 , mysqld running with pws
>
> here is some confusion with the multiple database
> connection variables
> i am executing the same code in three different ways
> it gives me
multiple database connection
on windows 98 , mysqld running with pws
here is some confusion with the multiple database
connection variables
i am executing the same code in three different ways
it gives me diffrent output
all the database and table are exsists
method 1
-
From: install [mailto:install]On Behalf Of Riyaz Husain
Sent: Wednesday, September 12, 2001 5:04 AM
To: mysql
Subject: Database connection error
Hi,
Can someone help out there?
I have installed MySql 3.23.41 on Solaris. Created a database
and executed the test script - run-all-tests which
Hi,
Can someone help out there?
I have installed MySql 3.23.41 on Solaris. Created a database
and executed the test script - run-all-tests which tested my
installation/configuration. No error was reported.
When I connect to the database from the installation server
through command line - ./m
Hi,
Mysql is giving me "connection to database" errors. My
database is created. Mysql server is getting started. The problem is
with
the connection to Mysql server. On command line, it shows connection
with
localhost. When I try to connect with server host name, it return backs
with error -
My application is to give database connection to oracle which is in sun solaris
machine and to mysql which is in windowsNT machine. How to write a java program to
establish connection. please help me.
I created a database with MySql (version 3.23.39-nt) that has a table named
Report. How can I open the database and insert values in this table from a
servlet?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
-
http://mmmysql.sourceforge.net/mm.doc.tar.gz
-Original Message-
From: Greg Cardoza [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 3:10 PM
To: [EMAIL PROTECTED]
Subject: Database Connection
Hello:
Is there anyone who can supply me with the syntax for
connecting to a database
Hello:
Is there anyone who can supply me with the syntax for
connecting to a database using JAVA and mm.mysql...
I've been to sourceforge.net and couldn't find exactly
what I was looking for. All I'm asking for is the
detailed lines of code in the try block statement to
connect to a database.
37 matches
Mail list logo
