Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using
To: mysql@lists.mysql.com
Subject: mysql odbc connection problem
Hi All
We are experiencing some problems when trying to connect to a mysql database
using ODBC.
The settings have been configured and it seems to be getting to the DB but
we getting the following error:
[S1T00][unixODBC][MySQL][ODBC
I installed a preconfigured package called MAMP on my MacBook Pro and have just
about everything working except my database connections. I can use phpMyAdmin
to manipulate databases and tables, but I can't connect to those databases from
Dreamweaver.
I read somewhere that you have to use a
Hello,
I'm running MySQL 5.0.22 x86_64 on CentOS 4.3 on one server and web
apps on another server. Occasionally these web apps (PHP) will return
error 1130,
Host 'x' is not allowed to connect to this MySQL server.
From my understanding of the documentation, this is an access denied
Michael Lai wrote:
David Logan wrote:
Michael Lai wrote:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11.
I can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone
first tries to access the
David Logan wrote:
Michael Lai wrote:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11.
I can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone
first tries to access the database, I would get
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the socket exists.
I'd bet that one of those three will find your problem. Please let
us know if this
Hi,
Use this :
ps awux | grep mysqld -i
On 2/4/06, Casey Rhodes [EMAIL PROTECTED] wrote:
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the socket exists.
I'd bet that one of those three will find your problem. Please let
us know if this
When testing my connection via Dreamweave MX, I get the following error message:
2002 Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
(2)
It was suggested to me that the server may not be running, though when I go to
my System Preferences Panel (MacOSX), I have
:
To: mysql@lists.mysql.com
From: Rhodes, Casey [EMAIL PROTECTED]
Subject: MySQL Connection Problem
When testing my connection via Dreamweave MX, I get the
following error message:
2002 Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2
Michael Lai wrote:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I
can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone
first tries to access the database, I would get the following error:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I
can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone first
tries to access the database, I would get the following error:
Communications
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established,
however, queries seem to
Tripp Bishop wrote:
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established,
Michael, you hit the nail on the head. We added
--skip-name-resolve and changed our connnection string
to use the IP instead of FQDN and now things are
working fine. It must have been something with our
DNS/ISP since we changed nothing and that stuff is out
of our control.
The other thing was
I am having inconsistent behavior maintaining a remote connection with MySql
Administrator/Browser. Brand new installations of clients on Windows XP and
MySql server on Windows 2003 server. It worked fine at first then suddenly I
could no longer connect (Error #1045. Access denied for user
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP and MySql server on Windows 2003 server. It worked
fine at first then suddenly
Thanks Shawn. It seems to be just that.
[EMAIL PROTECTED] 08/08/05 03:02PM
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15
PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP
Hi list,
I am getting slow connections between php4 and MySQL 4.1.9.
There are some connections that are very fast, but others can take from 5 to
20 second or more (usually it takes less than 0.1 second to create a new
connection). I tried to identify if there is a pattern but it seems that
On 6/10/05, Andre Matos [EMAIL PROTECTED] wrote:
I am getting slow connections between php4 and MySQL 4.1.9.
There are some connections that are very fast, but others can take from 5 to
20 second or more (usually it takes less than 0.1 second to create a new
connection). I tried to
Hello Everyone,
I am working on an architecture on which i am using common database
mysql4 for two web servers(Tomcat 5.x).
After moving to 150 number of connections using a java application,
mysql gives an error (exception): Server Connection Failure during
transaction.Attempt reconnect 3
razat gupta wrote:
But it gives an exception on the reach of 150 connections.It should
allow us to create almost 500 connection.
Use netstat on the server to find out how many connections are actually
in use. You may find that your program is not properly closing down
connnections, for
Hello.
After checking that MySQL server listens on the interface to which you
are connecting, solve network problems. If you're able to connect
from one host to another it doesn't mean that the opposite is true.
Andy McHargue [EMAIL PROTECTED] wrote:
Here's some more data on this,
Hello.
Your server listens only on a single interface. Options could be given
in different ways, not only from configuration file. If you want
MySQL server to listen on every interface you should find where the
bind option is given and remove it. See:
I'm having trouble connecting remotely from Server A (local) to Server B
(remote). Both Linux.
From Server A, I'm issuing this command
mysql -h [domain.com] -u [user] -p
And I get
ERROR 2003: Can't connect to MySQL server on 'domain.com' (110)
I assume this is a time out.
1. The user on Server
Here's some more data on this, if anyone can help.
--I can connect the other way around ... i.e. I can connect from B to
A. So there's no general connectivity problem.
--did an nmap on B,
$ nmap -sT -T Polite -p3306 xx.com
Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ )
Interesting
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error Number 2003 Can't connect to MySQL server on
'IP' (10060) .
I use mysql odbc 3.51
Is necesary the file my.cnf in c:\my.cnf
Regards
Gerardo Campos
:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 4:43 PM
To: mysql@lists.mysql.com
Subject: remote connection problem
I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql
localy, but when i try remote connection the error is:
Error Number 2003 Can't connect to MySQL server
, are
you sure that your remote connection can see the NT server? This may be a
bigger problem, i.e. DNS or IP routing/access lists.
You may also want to check the hostname.err logs on the MySQL server to
see if there is a connection problem there.
J.R.
-Original Message-
From: gerardo
One other thing to check, make sure --skip-networking isn't specified in
your configuration.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
+-+---+
1 row in set (0.00
Not necessary to change my.cnf, unless --skip-networking was specified.
Also assuming that you are using port 3306.
mysql show variables like 'port';
+---+---+
| Variable_name | Value |
+---+---+
| port | 3306 |
+---+---+
1 row in set
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server
(PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does
My intention of setting the reply-to was not to offend, or claim you
were wrong - merely to move the discussion to the list I felt (and still
feel - as I've done it again) is most appropriate for the question.
anyway, back to the task at hand
( first: I'm assuming you restarted apache after
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does anyone have any ideas
Denis Gerasimov wrote:
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does
P.V.Anthony wrote:
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail to check mail. Using
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail to check mail. Using
problem with 4.1.7
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail
this was because I was trying to connect to MySQL 4.1.x with
a 4.0.x client. I don't know if that's your case as well.
http://dev.mysql.com/doc/mysql/en/Old_client.html
Wes
On Jul 28, 2004, at 6:21 PM, Keith Thompson wrote:
I have a mysql connection problem that I'm trying to understand
I have a mysql connection problem that I'm trying to understand.
The three servers and the version of mysql they are running (all under
Solaris9) are:
db1 - 4.0.16
db2 - 4.0.17
db3 - 4.1.3
All three systems have the same mysql user and passwords setup. I'll
use the mythical user xx
/Old_client.html
Wes
On Jul 28, 2004, at 6:21 PM, Keith Thompson wrote:
I have a mysql connection problem that I'm trying to understand.
The three servers and the version of mysql they are running (all under
Solaris9) are:
db1 - 4.0.16
db2 - 4.0.17
db3 - 4.1.3
All three systems have the same
happyjuddi.jsp gives me the following error: (full text of the page enclosed at end of
message)
jUDDI DataSource Check
+ Got a JNDI Context!+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)- DB
connection was not aquired. (Cannot create PoolableConnectionFactory)- SELECT COUNT(*)
FROM
Thanks to those that responded. The problem is solved there was a password
mismatch between MySQL (what I had set up) and jUDDI. I changed the password in MySQL
and it now works fine. BTW, to the person that asked, Axis worked fine all along.
VC Ramesh [EMAIL PROTECTED] wrote:
Hi there:
I need URGENT help about this ..
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under
If you manually updated the tables, use flush privileges to inform the
DB server of your changes.
Cheers
/rudy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:23
To: [EMAIL PROTECTED]
Subject: Re: Connection problem!!! Windows to Linux
Aric
connect to MySQL through ODBC.
-Rob
-Original Message-
From: Aric Cheah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:36 AM
To: [EMAIL PROTECTED]
Subject: Connection problem!!! Windows to Linux
Hi there:
I need URGENT help about this ..
I wrote a program application
John,
- Original Message -
From: John A. Sullivan III [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, June 08, 2003 7:58 AM
Subject: Maximum statements per connection problem
I am having a nightmare of a time getting a single transaction across
multiple tables
I am having a nightmare of a time getting a single transaction across
multiple tables to work in Borland's Kylix3 with MySQL. It appears that
the Borland driver is saying that the MySQL database only supports a
single active statement per connection.
When I issue an explicit begin
On Thursday 27 March 2003 07:48, rajup at hydbad dot tcs dot co dot in wrote:
I really don't know whether it is a bug in mysql 4.0.12.
I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with
SPack2). I've changed the bind-address to localhost in my.ini and
re-started mysql.
Hi,
I really don't know whether it is a bug in mysql 4.0.12.
I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with
SPack2). I've changed the bind-address to localhost in my.ini and
re-started mysql.
mysql -h localhost is working fine.
mysql -h (ip of my machine) or mysql -h
Hanston Building
Emerald Avenue, Ortigas Center
Pasig City 1605 Philippines
Phone: 6345140 Local 1024
Web: http://www.tridel.net
Email: [EMAIL PROTECTED]
sql, query
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:48 PM
Subject: MySQL connection
hi guys i am still haveing the same problem has anyone experienced this
before ?
030305 08:33:36 mysqld started
030305 8:33:37 InnoDB: Started
/usr/local/etc/mysqlslave/libexec/mysqld: ready for connections.
Version: '4.0.11a-gamma' socket: '/usr/local/etc/mysqlslave/tmp/mysql.sock'
port:
Hello.
I get this message when trying to connect via TCP/IP. Both locally and remotely
ERROR 2013: Lost connection to MySQL server during query
What does it mean. I can't find any relevant documentation.
Installation i a standard RH8 with MySQL rpm's
Sorry for the disturbing you with this
Hello.
I get this message when trying to connect via TCP/IP. Both locally and remotely
ERROR 2013: Lost connection to MySQL server during query
What does it mean. I can't find any relevant documentation.
Installation i a standard RH8 with MySQL rpm's
Sorry for the disturbing you with this
Hello.
I'm running version 3.23 of MySql server for Windows on a Win2K machine.
I'm using the standard C API in my client software. A single client
connects succesfully, but when I run a number of concurrent clients on the
same machine (more than apr. 32), the connection (mysql_real_connect()
Hi everyone,
On my local machine I had mysql installed, and I was able to log in and
doing a test on it.
but today as I am trying to login using mysql or mysql -u root -p, I
got the error message saying; ERROR 2002: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (2), I
Sounds like mysql service hasn't started yet.
-Original Message-
From: David Wu [mailto:dwu;stepup.ca]
Sent: Monday, November 04, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: (beginner) mysql connection problem!
Hi everyone,
On my local machine I had mysql installed, and I
-Original Message-
From: David Wu [mailto:dwu;stepup.ca]
Sent: Monday, November 04, 2002 11:59 AM
To: [EMAIL PROTECTED]
Subject: (beginner) mysql connection problem!
Hi everyone,
On my local machine I had mysql installed, and I was able to log in and
doing a test on it.
but today as I am trying
Message-
From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com]
Sent: Monday, November 04, 2002 1:21 PM
To: 'David Wu'
Cc: Mysql (E-mail)
Subject: RE: (beginner) mysql connection problem!
You might also need to add hostname.
It depends on what GRANT sql statement was
used to add
Hello,
I'm having a problem connecting to a remote MySQL database and was
hoping someone could give me a pointer on where to look. Both machines
are running Red Hat Linux 7.2 and MySQL version 3.23.52. I have it
compiled and running succesfully on each machine as long as I log in to
the database
Hi
I have MySQL (version 3.23.38) installed on Win 98 running locally as
mysqld-opt which I am calling from a Java app using the mm.mysql-2.0.4 JDBC
driver. I've also tried the new Connector/J but the same problem exists.
When I try to have more than 30 or so open connections at a time from
Greets Folks,
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate
Will,
In your $dbh connection handler, you need to change the host=localhost and
database= to just localhost and the database name.
$dbh = DBI-connect (DBI:mysql:localhost;database_name,
**, ***, {PrintError = 0, RaiseError = 1});
On Fri, 24 May 2002 16:43:50
) 634-5139
- Original Message -
From: b g [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 11:38 PM
Subject: mySQL connection problem!!!
Hello,
I m ina great problem..
I am not able to conenct to mySQL server..
the problem is like.. when I m
On Wed, 2002-03-13 at 08:08, b g wrote:
when I m in root or mysql USER login.. then I can
login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
With which user are you trying to connect ?
Did you grant permissions to that user ?
Be
?
-Original Message-
From: b g [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 2:35 AM
To: Sherwin T. Ang
Cc: [EMAIL PROTECTED]
Subject: Re: mySQL connection problem!!!
Hello Sherwin,
Thanks for ur prompt reply.
Yes, I have gone thru the mySQL manual chapter that
you have
you select a
database first before adding a user?
-Original Message-
From: b g [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 2:35 AM
To: Sherwin T. Ang
Cc: [EMAIL PROTECTED]
Subject: Re: mySQL connection problem!!!
Hello Sherwin,
Thanks for ur prompt reply
Hello,
I m ina great problem..
I am not able to conenct to mySQL server..
the problem is like.. when I m in root or mysql USER
login.. then I can login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
thats why I am not able to run any
Hello,
I m in a great problem..
I am not able to conenct to mySQL server..
the problem is like..
when I m in root or mysql USER login.. then I can
login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
thats why I am not able to run
Hi All,
To Update current version on my new Redhat LINUX server I uninstalled MySQL
3.23.26 rpm and installed all MySQL3.23.47 rpms.
When I tried to connect through
shell mysql -u root mysql
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2).
Please let me
sreedhar,
Thursday, February 07, 2002, 3:03:35 PM, you wrote:
s Hi All,
s To Update current version on my new Redhat LINUX server I uninstalled MySQL
s 3.23.26 rpm and installed all MySQL3.23.47 rpms.
s When I tried to connect through
s shell mysql -u root mysql
s Can't connect to local
Hi all,
I solved my problem. Problem because another old mysql service running on
the same port.
regards,
sreedhar
- Original Message -
From: sreedhar [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 6:33 PM
Subject: INSTALLATION and CONNECTION problem
Hi All,
To Update current version on my new Redhat LINUX server I uninstalled MySQL
3.23.26 rpm and installed all MySQL3.23.47 rpms.
When I tried to connect through
shell mysql -u root mysql
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2).
Please let me
sreedhar,
Thursday, February 07, 2002, 3:03:35 PM, you wrote:
s Hi All,
s To Update current version on my new Redhat LINUX server I uninstalled MySQL
s 3.23.26 rpm and installed all MySQL3.23.47 rpms.
s When I tried to connect through
s shell mysql -u root mysql
s Can't connect to local
: Mysql connection problem
Hi Simon,
Thanks for your reply. Can you tell me how to do it? I tried, but it shows
me the error:
mysql not found. How can I find mysql server?
Cindy
Simon Green [EMAIL PROTECTED] 01/07 10:05 AM
No but you can start MySQL with out grant tables.
See on line manual
]
Subject: Re: RE: Mysql connection problem
Hi Simon,
Thanks for your reply. Can you tell me how to do it? I tried, but it shows
me the error:
mysql not found. How can I find mysql server?
Cindy
Simon Green [EMAIL PROTECTED] 01/07 10:05 AM
No but you can start MySQL with out grant tables
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 12:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Mysql connection problem
Hi Simon,
I appreicate
with mysqladmin and flush-privileges.
Hope this helps
Simon
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 18:17
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: Mysql connection problem
Hi Simon
, January 08, 2002 12:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Mysql connection problem
Hi Simon,
I appreicate your help.
Our server is a Solaris 5.6 server. After I cd to the mysql bin directory
bindir=/usr/local/bin
Hello,
I have a question for you. I have a Solaris 5.6 server running Mysql. It is our
company' website. I just know the server's root password and I don't know mysql
database user name and password. Is it possible to login to Mysql database by using
the server root and its password? How
connection problem
Hello,
I have a question for you. I have a Solaris 5.6 server running Mysql. It is
our company' website. I just know the server's root password and I don't
know mysql database user name and password. Is it possible to login to Mysql
database by using the server root and its
.
Or ./mysql --help
Simon
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 17:48
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Mysql connection problem
Hello,
I have a question for you. I have a Solaris 5.6 server running
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of
Hi,
-Original Message-
From: Devore, Jacob [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 10:01 AM
To: '[EMAIL PROTECTED]'
Subject: odbc connection problem
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of
I recently wrote in that I've tried everything in the book to connect to
MySQL but I'm still getting the infamous socket (111) error. I've had a
few good suggestions and I think we are almost there.
Here's where I am.
With MySQLGUI trying to connect, I changed the host from localhost to
Dr. Randy Frid writes:
I recently wrote in that I've tried everything in the book to connect to
MySQL but I'm still getting the infamous socket (111) error. I've had a
few good suggestions and I think we are almost there.
Here's where I am.
With MySQLGUI trying to connect, I changed the
hi,
I am new to PHP/mySQL.
When i connect to phpMyAdmin to work with my database I do not have any
problem of connection, but when I try to connect to my mySQL DB using this
script (http://www.utpala.net/query1.php), then I get the following error
message,
Does anyone see something wrong in
Hi,
I've got a *BIG* problem here...
I have a mysql database with some big tables (50,000 - 80,000 records and
above)
running on a netbsd machine.
Users run queries from their windoze machines through a delphi program via
myodbc. I didn't write that application so I can only guess the queries
Hi!
When i type: mysql -u franck -p then my password, it's ok.
My machine's name is r-lx-collineau
When i type mysql - h r-lx-collineau -u franck -p then my password, i have
this message:
ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
server
Can anybody help me ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
check mysql.user, you probably have permission for franck@localhost, which
succeeds when you omit the -h, but no permission for
[EMAIL PROTECTED], so you fail when you specify that is where you
are coming from.
John Barton
[EMAIL PROTECTED]
MYSQL
Hi!
When i type: mysql -u franck -p then my password, it's ok.
My machine's name is r-lx-collineau
When i type mysql - h r-lx-collineau -u franck -p then my password, i have
this message:
ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
server
I think the
I am a new one in database area. Hopefully someone can help me or give me
clue to solve the problem.
I have already run mySql in c:\winnt\System32\cmd.exe, and create a database
(table test1)
in c:\mysql\data\test directory. The classpath I setup in control system
environment, C:\jdk1.3.0_02;
Hi,
I am a newbie and hope someone can she light on why I can't get the
DBD::mysql connection working in my perl script. The script is a test one
and very simple.
I have the mysql daemon running and mysqladmin works, and DBI is installed
too. I went through the installation process for DBD
Download and install
http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz
Hi,
I am a newbie and hope someone can she light on why I can't get the
DBD::mysql connection working in my perl script. The script is a test one
and very simple.
I have the mysql daemon
I cannot seem to connect to a remote mySQL server located at my ISP.
I basically downloaded mysqlgui-win32-static-1.7.4-2.zip and installed. filled in the
server information. database name and username then tried to connect.
WHen I try to connect it tells me Access denied for user:
I have MySQL server on NT 4.0 SP6a
I connect to the db through this asp script :
strConnection = "driver={MySQL};server=xxx.xxx.xxx.xxx;uid=" + UID +
";database=" + DBName + ";password=" + Passwd + ";port=;";
adoDataConn = Server.CreateObject("ADODB.Connection");
1 - 100 of 101 matches
Mail list logo