: Monday, June 07, 2010 5:58 PM
To: Qu, Gang
Cc: mysql@lists.mysql.com
Subject: Re: Connecting Remotely to MySQL Server
OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the
intranet box it works, but when I connect using it's IP it's still the same
situation :(
And
OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the
intranet box it works, but when I connect using it's IP it's still the same
situation :(
And now when I connect remotely (from my front end which is accessible via
WWW), it says "ERROR 1045 (28000): Access denied for user
'a
Make sure the port is open from the db server. you can test it using "telnet
server 3306(if that's what you use)". If not, have your network admin open the
port for you.
-Original Message-
From: listan...@gmail.com [mailto:listan...@gmail.com]
Sent: Monday, June 07, 2010 3:37 PM
To:
; From: Kay C. Tien [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 18, 2007 4:32 PM
> To: Chris White
> Cc: mysql@lists.mysql.com
> Subject: Re: Connecting from a remote computer
>
> I got it working perfectly on a Linux server, but my boss wants this
> on a Windows I
I got it working perfectly on a Linux server, but my boss wants this
on a Windows IIS server.
The remote connection seems to be working now but I have another
problem now... the page is not doing anything - doesn't seem to be
connecting to the database, but I got no error messages
whatsoeve
Just to toss something else in here. A lot of times you have a server
that you can connect to by ssh, but because of firewalls, can't access
mysql through. If you can, however, connect to the database through
ssh, you can do port forwarding. In *nix systems it should be something
like this:
Hi All,
This is a dump and simple question but I can't seem to get it to work.
How do I enable a user to be able to connect from a remost host using
MySQL Administrator? I added "%" but once signed in, I still can't
access the user panel in the administrator.
Thanks.
Kay
I don't know if I can
Ruth divulged the following in an email dated 8/30/2006 11:58 AM :
> All,
>
> I am having difficulties getting the Coldfusion Administrator to establish a
> database connection to a database called "accounting" that I created using
> the command line utility. Any help would be very appreciated!!
Ruth wrote:
All,
I am having difficulties getting the Coldfusion Administrator to establish a database
connection to a database called "accounting" that I created using the command
line utility. Any help would be very appreciated
This is the error that CF is throwing:
"Connection verific
Jim Winstead wrote:
> On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote:
>> Dear all,
>>
>> is it a desired feature that the embedded version of the client library
>> still tries to create a network connection when I pass a hostname into
>> connect?
>
> Yes, the embedded version also acts as
On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote:
> Dear all,
>
> is it a desired feature that the embedded version of the client library
> still tries to create a network connection when I pass a hostname into
> connect?
Yes, the embedded version also acts as a standard MySQL client.
> Is
Cheers Dan. Exactly what I needed :)
Iain
Dan Trainor wrote:
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The er
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support authent
Courtney,
>SELECT consumers.id FROM consumers
>WHERE date_of_birth = ? AND consumer.id =
>(SELECT consumer_id FROM cases WHERE last_name = ?
>AND full_first_name = ? )
>Is there a way to form the above statement in MYSQL?
Something like this would be faster ...
SELECT co.id
FROM c
SELECT consumers.id FROM consumers, cases
WHERE
consumers.id=cases.consumers_id
AND consumers.date_of_birth = ?
AND cases.last_name = ?
AND cases.first_name = ?
John A. McCaskey
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 10:
select consumers.id from consumers LEFT JOIN cases ON consumers.id =
cases.id WHERE consumers.date_of_birth = '?' AND cases.last_name = '?' AND
cases.full_first_name = '?'
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 1:31 PM
To: mys
Hello.
I'm not familiar with this subject, however, have you been at:
http://dev.mysql.com/doc/mysql/en/howto-cf.html
http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html
http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html
http://www.ma
Ideally you would want to encrypt the connection, if only to add
another layer of security. But regardless, there are other steps you
can and should take even before implementing a secure connection
between PHP and MySQL. It's actually a smart idea to separate your
database from the front end h
Hello.
Somebody with the sniffer on the transit
router could get enough information about MySQL credentials. Try
to use SSL connection.
Nikola Skoric <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm wondering whether there is a way to hack into my database if I'm=
> connecting with PHP
Nikola Skoric wrote:
Hello,
I'm wondering whether there is a way to hack into my database if I'm connecting with PHP
from remote web server to my MySQL server with unencrypted connection? I'm using phpBB
forums (residing on one server and using the database on other server) which do not suport
S
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jay Scherrer wrote:
> I am having areal time trying to get my Open Office to recognize my
> MySQL server. I am using the j-connector :
> "Generally Available (GA) 3.0.6"
> I have this installed in my path $HOME/java.
> I have notified the tools->Opti
Have you tried my MySQL C API Site ?
I have posted some C API examples here.
http://www.geocities.com/jahan.geo
Aftab Jahan Subear
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.DhakaStockExchangeGame.com
Tel: +880-2-7519050
/*
Get customized T-S
At 21:20 + 11/14/04, premal mishra wrote:
I'm using MySQL version 4.0.20a on win98.
Compiler is Bloodshed Dev-C++ version 4.
My program compiles and links but gives a page fault error on running.
I'm linking the '\mysql\lib\opt\mysqlclient.lib' file.
Linker gives the warning >> ignoring duplic
Did you insert into the permission tables or did you use a GRANT
statement? You may need to flush your permissions (FLUSH PRIVILEGES).
On Sat, 9 Oct 2004 20:57:29 +0200, roland <[EMAIL PROTECTED]> wrote:
> Hello again,
>
> refering to my previous question I forgot to mention that xxx.xxx.xxx.xxx
Does the user have permission to access the server remotely, from the IP
address of the client? You may have to add an entry in the user table
in the mysql database specifying the IP address from which you're trying
to log in.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
chueewowee wrote:
>[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with
>databases from /usr/local/mysql/data
>040612 23:32:05 mysqld ended
mysqld isn't starting. See what the error log says, it will likely be
in /usr/local/mysql/data
--Ware
--
MySQL General Mailing List
For l
Thomas Nyman wrote:
Hi all
I'm a mysql beginner. I have my database up and running and can query
it via php and apache.
I would like to set things up so that MSExcel and or MSWord can query
the database and extract info from it. For this reason I downloaded
the and installed MyODBC-standard-3
* Steijn, B.S.
> I would like to make a connection between 2 databases in
> MySQL that are on the same server.
If you by "connection" mean to join tables from the two databases on the
same server, you can do that.
> The purpose is that a
> class X in database A uses a class Y in database B by a
>
;
> Cc: MySql List <[EMAIL PROTECTED]>
> Subject: Re: Connecting to remote server
>
> Mike Tuller wrote:
>
>> I have a shell script that is supposed to connect to a remote server running
>> MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied fo
Mike Tuller wrote:
I have a shell script that is supposed to connect to a remote server running
MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES)"
The script looks like this:
/usr/local/mysql/bin/mysql --user=$username --passwo
See http://www.connectionstrings.com/
Regards,
Ulises
-Mensaje original-
De: Ratmil Torres [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles 6 de Agosto de 2003 07:11 AM
Para: [EMAIL PROTECTED]
Asunto: Connecting to MySQL from ASP
Hi. I am developing a web site using ASP. I need to connec
Depending on what driver of MySQL ODBC you are using.
The one below I use for v3.51:
strConnString = "drver={MySQL ODBC 3.51
Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4
The one below I used in the past for v2.50:
strConnString =
"driver=MySQL;server=SERVER_IP;uid=UID;p
:44 a.m.
Para: Jorge Cornejo; [EMAIL PROTECTED]
Asunto: RE: Connecting ASP
You can access MySQL databases from ASP by using MyODBC (now
Connector/ODBC) just like you would any other ODBC datasource. I would
suggest doing google searches on MyODBC and ASP in the same search, or
adapt some code from my
orge Cornejo; [EMAIL PROTECTED]
Asunto: RE: Connecting ASP
You can access MySQL databases from ASP by using MyODBC (now
Connector/ODBC) just like you would any other ODBC datasource. I would
suggest doing google searches on MyODBC and ASP in the same search, or
adapt some code from my site www.vbmysql.
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 20, 2003 10:43 AM
> Subject: RE: Connecting ASP
>
>
> You can access MySQL databases from ASP by using MyODBC (now
> Connector/ODBC) just like you would any other ODBC datasource. I would
> suggest doi
System Data Source Name using (at least when I did it) the Sybase
driver.
Best
E
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Jorge Cornejo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 10:43 AM
Subjec
You can access MySQL databases from ASP by using MyODBC (now
Connector/ODBC) just like you would any other ODBC datasource. I would
suggest doing google searches on MyODBC and ASP in the same search, or
adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ
for examples. Also subs
Hi!
Most probably the drivers will be fine placing the jar file under
c:\jdk_dir\jre\lib\ext
This way there should be no classpath problem
Adding JDK_HOME and JAVA_HOME variables to your environment should help also
As for the drivers, both should work, just fine =)
On Sunday 01 June 2003 19:15
On Wednesday 19 February 2003 11:24, kk wrote:
> I just installed mysql4.x into the home/username directory of a remote
> machine. It is running good and I created a new user tester with all
> privileges.
> But how can i connect to the remote server running on a home directory
> using a front en
Using the hostname or IP adders of the machine it is on.
(B
(BJerry
(B
(B- Original Message -
(BFrom: "kk" <[EMAIL PROTECTED]>
(BTo: "list mysql" <[EMAIL PROTECTED]>
(BSent: Wednesday, February 19, 2003 9:24 AM
(BSubject: Connecting to remote server
(B
(B
(B> Hello folks
(B> I
Hello all,
I suppose that there is a bug in the mysqlcc version 0.8.9-beta (Windows)
and previous versions 0.8.7 and 0.8.8.
The bug is repeatable in different constellations:
1.1) Connecting to a localhost server (version 3.23.39-max-nt) as user
'',
1.2) Trying to open e second connection to t
**
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2002 22:11
To: MySQL List
Subject: Re: Connecting M. Access Forms to insert data into mysql
I've installed about 12 client gui's and here's my conclusion.
DBQwikEdit
- has the best editor for Da
I've installed about 12 client gui's and here's my conclusion.
DBQwikEdit
- has the best editor for Data Entry
- nice form to add one record at a time
- similar to access forms (I want this)
- As far as I can tell, is the only product that has this feture
http://www.mysqlstudio.com/
- nice for ma
Your 'root' password was probably not set hence, you didn't need a password.
Bhavin.
- Original Message -
From: "Pikasz Gyorgy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 7:46 AM
Subject: Connecting to mysql
> I'm logged in to RedHat Linux as an user and
Thanks gerald, I totally forgot about the 'identified
by' part. Doh! I had to tell mysql to bind to
127.0.0.1 also, which I had tried before but without
assigning the password so combining the two steps
certainly worked better than one at a time. :)
I got in and am now seeing a different error b
In the last episode (Nov 26), twig les said:
> In this episode I figured out that the problem is not
> stunnel or the remote connection. I simply cant log
> in with the command:
>
> mysql -u root -h 127.0.0.1 -p
>
> I just get a connection refused message. There should
> be a trick here that I'
Jochen,
Saturday, November 02, 2002, 3:49:18 PM, you wrote:
JK> when I try to connect to a remote computer running mysql
JK> I always get the following error on the remote machine:
JK> Number of processes running now: 1
JK> mysqld process hanging, pid 7262 - killed
JK>
See this thread :
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
- Original Message -
From: "Michael Gargiullo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 9:26 AM
Subject: connecting to mysql server from other machines
> I have a huge proble
> > >If I type the following at the command prompt, in this
> example I'm using
> > >username for the user name, and 66.66.66.66 for the IP address
> > >(although I use real values)
> > >
> > >mysql -h 66.66.66.66 -u username -p
> > >
> > >it asks for my password then goes off and thinks for a whi
Thanks for this, I may well need additional privileges, but I can't see how I
can change these on the remote server without connecting first!
Julia
gerald_clark wrote:
> Check the section of the manual covering the privilege system,
> especially the "GRANT" command.
>
> Julia Maddocks wrote:
>
>
Check the section of the manual covering the privilege system,
especially the "GRANT" command.
Julia Maddocks wrote:
I would like to connect to MySQL database on a remote server using
either the command prompt or MySQLFront.
I have the IP address, username, password but I can't connect.
MySQLf
Well, after much fussing around with RPM's and searching this list, I have
resolved my problem.
The clue was the discussion on this list regarding the glibc bug. I upgraded
to the 4.0.x RPM's that I got from the MySQL site and after I got all of the
dependency problems fixed I was able to start up
> Thank you, but at this point I am pretty sure that my problem is not a
> matter of entries in the user table. When I attempt to telnet
> into port 3306
> the connection is immediately dropped. I don't really know if
> any connection
> is actually established at all, it may be established and imme
ebmin tip, I'll give it a try. Doesn't solve all of my
problem, but it may help.
Thanks,
--Will
> -Original Message-
> From: STIBS [mailto:stibs-pi@;gmx.de]
> Sent: Friday, October 18, 2002 1:35 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
&
Will,
|||)So I still need some more ideas.
I have to learn your problem each time again when I setup a new machine every half a
year.
I try each time the following hostnames:
localhost (didn't work 4u)
127.0.0.1 (IP for localhost)
hostname (e.g. databaseserver.mydomain.com- what you called the
Thank you to both of you who responded to my question. I have checked both
of these issues and found that neither solve my situation.
1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the
user table. Is there something else that has to be done to set up the host?
2) According
Hi,
It seems to me that you can't connect to MySQL from an other machine at
all. Did you start MySQL with the --skip-networking option? Try removing
that option from the start-up scripts.
\Olaf
Will Merrell wrote:
I cannot connect from my Windows machine to the MySQL database running on
the L
Will,
Do you have a user/host pair for the client in the user table within the
mysql database?? It's not good enough just to have a user, the host has
to be setup too.
> I cannot connect from my Windows machine to the MySQL database running
on
> the Linux server.
>
> I have tried several differ
ops, sorry jay,
i forgot this...
do you install mysql in your web server?
if you install it on your web server, so i think you should install the odbc
driver for mysql in your web server...
and after that u can use your asp script to make connection to your mysql
database
have a nice try :-
dear jay fields,
pls try this, hope this can help u...
dim objconn, objrs
set objconn = server.createobject("adodb.connection")
set objrs = server.createobject("adodb.recordset")
objconn.connectionstring="server=192.168.0.1;driver=MySQL;db=[database_name]
;uid=[user_name];pwd=[user_passwo
>>> AW> Have been trying to connect to a remote MySQL server from Matlab through
>>> an
>>> AW> ODBC connection, however the error is receive is
>>>
>>> AW> [TCX][MyODBC]Can't connect to MySQL server on
>>> AW> '' (10060)
>>>
>>> AW> I have searched the docs and archives and google... But can't
Adam,
Tuesday, September 24, 2002, 2:57:04 PM, you wrote:
>> Subject: re: Connecting to remote database using MyODBC
>> From: Egor Egorov
>> Date: Fri, 20 Sep 2002 16:33:01 +0300
>>
>> Adam,
>> Thursday, September 19, 2002, 8:33:17 PM, you wrote:
>>
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "Richard Fox" <[EMAIL PROTECTED]>
Date: Fri, 20 Sep 2002 11:19:37 -0400
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.
News-Group: list.mysql
IT is working as of yesterday.
The problem was that I was granting select, insert, update privileges to the
webuser and the change would not appear in the user table of the mysql
database.
Learn a new one yesterday. I try changing the privileges using the GRANT on
an existing user and they do
On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote:
> Hi,
>
> I am on the machine 192.168.0 230, and I am trying to connect to the
> server
> on 192.168.0.10.
>
>> mysql -h 192.168.0.10 -u username -p
>
> I get back
>
>> ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (11
Ha ha, I changed the remote permissions for the user to 'any host' and now
it works. Doh!
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Adam,
Thursday, September 19, 2002, 8:33:17 PM, you wrote:
AW> Have been trying to connect to a remote MySQL server from Matlab through an
AW> ODBC connection, however the error is receive is
AW> [TCX][MyODBC]Can't connect to MySQL server on
AW> '' (10060)
AW> I have searched the docs and archi
; From: Alexander Burbello [mailto:[EMAIL PROTECTED]]
> Sent: 29 August 2002 13:17
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Connecting to another machine with myCC
>
>
> Hi,
>
> Try another tool named "My Database Manager&quo
Hi,
Try another tool named "My Database Manager". You can download the site
br.geocities.com/burbello.
Greedings
Alexander
- Original Message -
From: "Fred Tsang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 7:38 AM
Subject: Connecting to another machine
Tell me what you do
ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL
ADODB -> MyOLEDB -> MySQL
or anything else?
first case: check "don't promt on connect"
Did you create a data source? (First thing you don't need to do...)
But whatever you do with VB, MS ADODB and MySQL - you will need
Hi,
Search if somebody has the OLEDB driver for MySQL, and
then you will be able to do it.
Bye and Good Luck!
--- "Darrell A. Sullivan, II"
<[EMAIL PROTECTED]> wrote:
> Can anyone tell me if it is possible to connect to a
> MySQL server running on
> Linux from a Windows Visual Basic application
You don't need samba you can do it from a command line...
...mysql -u user -h hostname or ip -p
Sorry for the ... Thast is not part of the command just outexpress like to
make things captial where they shouldn't be.
Chuck
on 3/23/02 10:02 AM, Paul Gilbert at [EMAIL PROTECTED] wrote:
> Hi Egor
Paul,
Friday, March 22, 2002, 9:51:51 PM, you wrote:
PG> I am running Apache on Linux and MySql database is running
PG> on a windows200 server.
PG> Is there a way to connect to that database using the IP address ?
Yes, when you connect to the remote MySQL server you should specify host
where mys
You have written the following:
Hi!
I am running Apache on Linux and MySql database is running
on a windows200 server.
Is there a way to connect to that database using the IP address ?
Thanks for your help!
Paul
-
Before pos
It won't let you since Windows ODBC only lets you create ONE DSN per
DATABASE
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:11 PM
To: MySql
Subject: connecting to all databases using one odbc connection..PLEASE
HELP
I asked yesterday
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
> I asked yesterday but got no responses...anyone have any ideas how I can
> use one odbc connection but have access to all databases on the MSSQL
> server???
I have not tried this but have you considered using the use command? Or even
per
- Original Message -
From: "Jeremy 'Circ' Charles" <[EMAIL PROTECTED]>
To: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 3:21 PM
Subject: Re: Connecting to mysql Server
> On Mon, 25 Feb 200
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote:
> Does anyone have an idea why I am getting an error "Fatal error: Call to
> undefined function: mysql_connect() in /var/www"
That's the error you get if you try to call mysql_connect() but don't have
the MySQL support compiled in to the PHP module.
Put double quotes around % so that foo@"%"
On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote:
>mysql> grant all privileges on *.* to foo@% identified by 'foobar' with
>grant option;
>ERROR 1064: You have an error in your SQL syntax near '% identified by
>'foobar' with grant option' a
> GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
Ah but that doesn't work this is what worries me because I have a book
on mysql that uses syntax like this and it generates an error on my system.
This is a Red Hat 7.2 system, stock with Red Hat distribute
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote:
>I cant connect to a MySql Database form a Windows PC, I get Host ... is
>not allowed to connect to this MySQL server and in the MySql manual I
>found the following solution but I dont know how to do it. I am an
>novice in MySql.
>If anyo
> It simply won't connect. It just says 'Can't connect to local MySQL
> server through socket '' (111)'
>
> I can connect via terminal so I know MySQL is (at least semi) correctly
> setup.
>
> Any ideas?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0
/ Carsten
--
Carsten H. Pedersen
keep
it wuld be nice if mysql supported sub queries
ie.
select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID
in (select B.MESSAGEID from MESSAGES as B where
B.SUBJECT='Invitation to join the hanky panky group')
_
Do You Yahoo!?
Get you
Good morning Kamal,
From: <[EMAIL PROTECTED]>
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
No. The service (mysqld) is strictly assigned to managing the local database(s) and to
serve access to those databas
[EMAIL PROTECTED] writes:
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
A client is a client and a server is a server. The point of separating
the two is that you can then run the client somewhere and and the
s
>I suspect that you need to add an entry at the MySQL host for the machine
that you are connecting from. This can be done with a GRANT statement:
>
>- Format:
>grant all privileges on databaseName.tableName
>to 'userName'@'hostName'
>identified by 'somePassword';
>
>
>- Example
From: <[EMAIL PROTECTED]>
> I have a similar problem...
Just to be sure, it's helpful if you could send us the message that your getting when
you see the connection problem, but this sounds like the same thing.
> Can this sovle my sleeplessness problem?
Probably. Anytime I can't sleep, I jus
At 03:23 PM 12/10/01 -0700, you wrote:
>From: Dan <[EMAIL PROTECTED]>
>
>> I can connect... on the same computer
>> ...different machine it won't work.
I have a similar problem but let explain better may be i don't get what Dan
was talking about. From my local computer i can use LOAD command to s
From: Dan <[EMAIL PROTECTED]>
> I can connect... on the same computer
> ...different machine it won't work.
I suspect that you need to add an entry at the MySQL host for the machine that you are
connecting from. This can be done with a GRANT statement:
- Format:
grant all privileges on
Make sure you have permissions to connect to the remote site from your
current server or host. Permissions need to be set for that user to connect
from your server host
- Original Message -
From: "Hamzat Kamal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 8:2
Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 1:10 PM
To: Jason Whitlow
Cc: '[EMAIL PROTECTED]'
Subject: Re: Connecting to a remote database.
Jason Whitlow wrote:
> Sorry for for the dumb question buuut.
>
> I have
Jason Whitlow wrote:
> Sorry for for the dumb question buuut.
>
> I have been connecting to a database on my localhost using perl's DBI.pm
>
> This is how I currently do it.
>
> use DBI;
> $data = "databasename";
> $driver = "DBI:mysql";
> my $dbh = DBI->connect("$driver:database=$data", "use
Hi!
On Aug 10, Carsten H. Pedersen wrote:
> > http://www.mysql.com/doc/U/s/User_names.html
> > says:
> > >>>
> > MySQL encrypts passwords using a different algorithm than the one used
> > during the Unix login process. See the descriptions of the PASSWORD() and
> > ENCRYPT() functions in s
> http://www.mysql.com/doc/U/s/User_names.html
> says:
> >>>
> MySQL encrypts passwords using a different algorithm than the one used
> during the Unix login process. See the descriptions of the PASSWORD() and
> ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note
> that even
> How is that possible? Even if you do know someone's scrambled password,
> when you connect to the MySQL server pretending to be that user, it will
> ask you for their non-scrambled password. After you type it in,
> the server will scramble it and check that the scrambled value matches
> the sc
>PC there communicates through Novell 4.11 server, some use
>Windows protocol. I've used the same installation, and more,
>one from Apache serverer PC can be connected alternatively to one
>or to second network. In the first, it works, as I've mentioned earlier,
>in the second the server sees him
Richard Gibbs wrote:
> sorry if this is the wrong list
>
> I am a beginner user of mysql, but a few pl I know are very active in
> scripting using mirc, especially gaming using tcp/ip connections to game
> servers to find out various details.
>
> I would like to know how/if I can connect to a m
James Gosnell wrote:
> If I connect to mysql:
> mysql -u username -p wherever.net
>
> is that encrypted at all?
No and never will be default behaviour to encrypt communication as this reduces
performance.
> and if I make a network program via the C API, would that be encrypted
> too? T
ehalf
> Of [EMAIL PROTECTED]
> Sent: 29 June 2001 10:41
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Connecting to MySQL w/VB
>
>
> Give MyODBC a try, its on the mysql.com site
> and its given my no problems at all in vb.
>
> Sean
>
> -Origin
Give MyODBC a try, its on the mysql.com site
and its given my no problems at all in vb.
Sean
-Original Message-
From: Robert Skinner [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:45 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL u
1 - 100 of 118 matches
Mail list logo