Re: Remote Access to MySQL

2015-03-09 Thread patrick
Check your border router access list. Patrick Sherrill patr...@coconet.com Coconet Corporation SW Florida's First ISP (239) 540-2626 Office (239) 770-6661 Cell Confidentiality Notice. This email message, including any attachments, is for the sole use of the intended recipient(s) and may cont

Re: Remote Access to MySQL

2015-03-09 Thread Johan De Meersman
- Original Message - > From: "Rafael Ribeiro" > Subject: Remote Access to MySQL > > After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost > the ability to connect to mysql remotely, from external IPs. "It doesn't work" is not a helpful comment :-) What error mess

Re: Remote Access to MySQL

2015-03-09 Thread Pothanaboyina Trimurthy
and also make sure tcp port of your DB instance has been added to firewall expeption. check the iptables for this to verify. On Mon, Mar 9, 2015 at 2:13 PM, Florian Schaal wrote: > Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro: > >> Hello List, >> >> >> I'm not an expertise on MySQL and we are

Re: Remote Access to MySQL

2015-03-09 Thread Florian Schaal
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro: Hello List, I'm not an expertise on MySQL and we are facing a strange issue: We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1). After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost the ability to co

Re: Remote Access to MySQL

2015-03-07 Thread Thufir
On Sat, 07 Mar 2015 21:49:10 -0300, Rafael Ribeiro wrote: > I read a lot of tutorials and tips without success. > > What I need to do, to come back to working configuration like oldest > machine, allowing remote connections? By no means am I an expert, but, while not specific to your question:

Re: Remote mysql too slow

2012-04-09 Thread Noel Butler
On Mon, 2012-04-09 at 06:14 -0500, Johnny Withers wrote: > right speed and duplex. It seems that every new server I get now has > to have the speed and duplex explicitly set instead of auto negotiate. > Many of the cisco switches are notorious for this. signature.asc Description: This is a

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 13:17:55 +0200 Reindl Harald wrote: > > > Am 09.04.2012 13:05, schrieb J. Bakshi: > > I have reset these two now > > > > ` ` ` ` > > key_buffer_size=200M > > innodb_buffer_pool_size=4G > > [!!] InnoDB data size / buffer pool: 3.6G/8.0M > > there did go something terrible

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 13:05, schrieb J. Bakshi: > I have reset these two now > > ` ` ` ` > key_buffer_size=200M > innodb_buffer_pool_size=4G [!!] InnoDB data size / buffer pool: 3.6G/8.0M there did go something terrible wrong what is the mysqld log saying at startup? waht about post your complete my.

Re: Remote mysql too slow

2012-04-09 Thread Johnny Withers
You may want to ensure the nic is connected to the network at the right speed and duplex. It seems that every new server I get now has to have the speed and duplex explicitly set instead of auto negotiate. Sent from my iPad On Apr 9, 2012, at 4:00 AM, "J. Bakshi" wrote: > > Hello, > > I have be

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 12:06:42 +0200 Reindl Harald wrote: > > > Am 09.04.2012 11:56, schrieb J. Bakshi: > > On Mon, 09 Apr 2012 11:47:01 +0200 > > Reindl Harald wrote: > > > >> > >> > >> Am 09.04.2012 10:57, schrieb J. Bakshi: > >>> > >>> Hello, > >>> > >>> I have been provided a muscular l

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 11:56, schrieb J. Bakshi: > On Mon, 09 Apr 2012 11:47:01 +0200 > Reindl Harald wrote: > >> >> >> Am 09.04.2012 10:57, schrieb J. Bakshi: >>> >>> Hello, >>> >>> I have been provided a muscular linux server to use as a Mysql server >>> in our organization. The server is located

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 11:47:01 +0200 Reindl Harald wrote: > > > Am 09.04.2012 10:57, schrieb J. Bakshi: > > > > Hello, > > > > I have been provided a muscular linux server to use as a Mysql server > > in our organization. The server is located just beside the web server > > and within the

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 10:57, schrieb J. Bakshi: > > Hello, > > I have been provided a muscular linux server to use as a Mysql server > in our organization. The server is located just beside the web server > and within the same network. This dedicated server has 8GB RAM, i5 processors > and runnin

Re: Remote access of MySQL

2011-06-04 Thread Reindl Harald
http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html Am 04.06.2011 22:30, schrieb Abdul Vali: > Dear All > > I have installed MySQL 5 on Ubuntu 10.04 Server. It is working fine but > when I try to access MySQL through any other client using ODBC connector, it > says access is denied for

Re: remote mysqldump to csv (--tab)

2010-05-04 Thread walter harms
you can circumvent the problem by using stdout. just drop the "INTO OUTFILE '/tmp/result.txt'". the result should look something like that: mysql -BAN -e "select ..." >filename you can also pipe truh gzip to compress the file and save a lot of space. re, wh note: i found ";" is not a good se

Re: remote mysqldump to csv (--tab)

2010-05-04 Thread Marijn Vandevoorde
Thank you for replying Carlos, but I'm under the impression that this will also put the file on the server. Acutally, mysqldump --tab uses INTO OUTFILE to generate the dump if i'm not mistaken Carlos Eduardo Caldi wrote: Hi You can use on shell, connect at the client mysq -h (host or IP) -p(

RE: remote mysqldump to csv (--tab)

2010-04-28 Thread Carlos Eduardo Caldi
Hi You can use on shell, connect at the client mysq -h (host or IP) -p(password) and run the query: SELECT a, b, c INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test_table more info see the link http://dev.mysql.com/doc/r

RES: [SPAM] RE: Remote connection

2009-08-05 Thread Hugo Leonardo Ferrer Rebello
It´s working. The problem was related to grant permission. Thank you. Cheers, Hugo -Mensagem original- De: Gavin Towey [mailto:gto...@ffn.com] Enviada em: terça-feira, 4 de agosto de 2009 19:46 Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com Assunto: [SPAM] RE: Remote

RE: Remote connection

2009-08-04 Thread Gavin Towey
1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect If you cont

Re: Remote connection

2009-08-04 Thread Carlos Proal
Are you sure that root has granted access to connect remotely ?? Carlos On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote: Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf fi

RE: Remote connection

2009-08-04 Thread Pablo A. Otero
May not have root access to remotely! Try to reconfigure the parameters of the engine. although it is not good idea to allow remote access to the root user!. Greetings, Pablo -Mensaje original- De: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Enviado el: Martes, 0

Re: Remote data

2009-03-18 Thread Ananda Kumar
you can do this also (source) (desti) mysqldump -uroot -p -habc.com --databases yyy --table tab1 | mysql -uroot -p -hzzz.com -Dxxx On 3/18/09, Krishna Chandra Prajapati wrote: > > Hi all, > > I am looking for a solution. > > While being on one db server how to get the data from other server

Re: remote connection

2006-10-14 Thread Dan Buettner
Chris, it's somewhat common for hosting companies to restrict outbound connections like what you describe. They may have a firewall preventing what you are trying to do. From your hosting account, can you telnet to your machine on port 3306 ? I get something like this: $ telnet 192.168.2.4 33

Re: remote monitoring of mySQL

2006-07-07 Thread Vittorio Zuccalà
Andy Ford ha scritto: > Can I do it with DBD::Perl > DBD::Mysql is a good module and you can control mysql status... You can do a lot of select and you can send them functions as createdb, shutdown or reload. I use this module in my mysql databases (i've only one server not many as you have...)

RE: remote monitoring of mySQL

2006-07-06 Thread Addison, Mark
From: Andy Ford Sent: 06 July 2006 17:06 > > What would be the best approach to remote monitoring of numerous mySQL > databases remotely i.e. number of threads. number of open > tables etc etc > > Can I do it with DBD::Perl You could, run queries such as SHOW STATUS; SHOW TABLE STATUS; again

Re: Remote access denial

2005-09-03 Thread Gleb Paharenko
Hello. > I've also discovered that its generating log entries (I've got a > 3 Gbyte log file) even though I havent asked for them. You may want to disable the general log where errors are written. See: http://dev.mysql.com/doc/mysql/en/query-log.html http://dev.mysql.com/doc/mysq

Re: Remote access denial

2005-09-02 Thread Gleb Paharenko
Hello. Have you run mysql_fix_privilege_tables script after the upgrade? "T. Horsnell" <[EMAIL PROTECTED]> wrote: > After replacing a 3.23.28 server with 4.1.14 server binaries on an Alpha > running Tru64 5.1B, I get things like: > > ERROR 1045 (28000): Access denied for user 'tsh'@'10

Re: Remote access denial

2005-09-02 Thread T. Horsnell
>Hi, >It is skip-name-resolve - I just wrote it by memory and was wrong. There is >also a nice piece on "Access denied" errors at > >http://dev.mysql.com/doc/mysql/en/access-denied.html Thanks - I'd already read that. I've also discovered that its generating log entries (I've got a 3 Gbyte log fi

Re: Remote access denial

2005-09-02 Thread Dobromir Velev
Hi, Does the 10.4.0.101 reverse resolve to a specific hostname? If it does you are probably running MySQL with the skip_hostname_resolve option and if it doesn't there is no way the MySQL server could tell from which host the request is comming. My opinion is that it is always better to use the

Re: Remote Connection Problem

2005-08-08 Thread Kent Roberts
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 > o

Re: Remote Connection Problem

2005-08-08 Thread SGreen
"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 s

Re: remote connection

2005-05-21 Thread mfatene
Hi, haven't you added "identified by *" int he grant statement. I don't see it in your show grants comand. Mathias Selon Chris Faulkner <[EMAIL PROTECTED]>: > Hello > > I am trying to connect from host 192.168.0.8 on my home network to a > database on 192.168.0.7. When I connect as root on

Re: remote connection problem

2005-05-19 Thread Gleb Paharenko
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: http://dev.mysql.com/doc/mysql/en/pr

Re: remote connection problem

2005-05-19 Thread Gleb Paharenko
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,

Re: remote connection problem

2005-05-18 Thread Andy McHargue
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 po

Re: remote connection problem

2005-03-22 Thread Michael Kruckenberg
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 (0.0

Re: remote connection problem

2005-03-22 Thread Michael Kruckenberg
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

RE: remote connection problem

2005-03-22 Thread J.R. Bullington
R. -Original Message- From: gerardo Villanueva [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 5:03 PM To: [EMAIL PROTECTED] Subject: RE: remote connection problem 1.- Yes I have a firewall but the port 3306 is open 2.- Mysql is running in the server 3.- I connecting with use

RE: remote connection problem

2005-03-22 Thread J.R. Bullington
1) Are you running a firewall? If so, make sure that port 3306 is open. 2) Is your MySQL server is up and running? 3) Do you have the correct permissions to connect to the server via your mysql.hosts table? Just some thoughts. J.R. -Original Message- From: gerardo Villanueva [mailto:[E

Re: Remote Connection via Toad for MySQL

2005-02-25 Thread Karam Chand
You can try SQLyog (www.webyog.com), it supports 3.23.x to 5.0. Lightweight and very fast! Karam --- [EMAIL PROTECTED] wrote: > Good good. > > On 24 Feb 2005, at 20:46, > [EMAIL PROTECTED] wrote: > > BINGO!!! > Thanks Dan! > Kelly > > > > Daniel Walker <[EMAIL PROTECTED]> > What vers

Re: remote connection with 4.0.22 on win32

2004-12-07 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Access_denied.html "Massimo Petrini" <[EMAIL PROTECTED]> wrote: > I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs > correctly (it is a slave member of my domain). But if I try to connect from > a remote client with mysq

Re: Remote user problem

2004-11-30 Thread Ingo Strüwing
Hi, Am Mo, den 22.11.2004 schrieb Danesh Daroui um 16:29: ... > /*> mysql -h 127.0.0.1 -u root -p > Error 1045 (28000): Access denied for user > 'root'@'localhost.localdomain'. (using password YES) > */ this might be a problem in your DNS. It resolves 127.0.0.1 to 'localhost.localdomain' instea

Re: Remote user problem

2004-11-23 Thread Gleb Paharenko
Hello. I guess your MySQL client library is fresh enough to support authentication protocol of 4.1.x versions. Otherwise you should read: http://dev.mysql.com/doc/mysql/en/Old_client.html If you have 4.1.x client library on your windows machine, probably you should add ability to connec

Re: Remote Connecting

2004-11-21 Thread Peter
Hello Danesh, what error do you get after the upgrade ? Peter Danesh Daroui wrote: Hi all, I have a Linux Fedora Core 3 machine which is supposed to act as database server and a Windows XP client. I had installed mysql server 4.1.5 before and I have defined remote user on my Linux machine as belo

Re: Remote Connecting

2004-09-07 Thread SGreen
I am sorry to say this but I believe you are confusing one product with another. In order to connect to a Linux machine, open a user session (from any platform), and act like a generic user, you need some type of remote shell utility. I use Cygwin as my remote shell but there are others, many

Re: Remote Connecting

2004-09-05 Thread Wesley Furgiuele
It might just be that your connect line isn't working properly. Try this form instead: mysql -u root -h MyLinuxSystem -p You want to connect as user "root" to host "MyLinuxSystem" using a password for which you will be prompted. If that doesn't wok, you need to make sure that on your server, on y

Re: remote connection php code

2004-07-20 Thread jeffrey_n_Dyke
> Hi All > Could someone give me a clue or a snippet of PHP code I can test a romte > connection to my MySQL DB for my website please? Just take the one you're currently using and replace 'localhost' with 'someotherserver.com' $cnx = mysql_connect('someotherserver.com','uname','pword'); mysql_s

Re: Remote Access with Linux

2004-02-09 Thread vpendleton
One way is to expose the port that MySQL is running on via the firewall. Another option could be to run ssh on the target MySQL machine and forward the MySQL ports giving you a secure connection. >> Original Message << On 2/9/04, 6:41:19 AM, Carlos J Souza <[EMAI

RE: Remote access FROM a secure server

2004-01-01 Thread Ugo Bellavance
> -Message d'origine- > De : Amer Neely [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 01, 2004 3:07 PM > À : Larry Brown > Cc : MySQL List > Objet : Re: Remote access FROM a secure server > > > Larry Brown wrote: > > Have you tried to

Re: Remote access FROM a secure server

2004-01-01 Thread Amer Neely
Larry Brown wrote: Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a sec

RE: Remote access FROM a secure server

2004-01-01 Thread Larry Brown
Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a secure facility so I h

RE: remote connection

2003-11-08 Thread John Almberg
uilding You A Better Online Business <><><><><><><><><><><><><><><><><><><><><><><><> -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTEC

RE: remote connection

2003-11-07 Thread Curtis Maurand
<> >Visit us at: www.identry.com >Building You A Better Online Business > <><><><><><><><><><><><><><><><><><><><><><><><> > >

RE: remote connection

2003-11-07 Thread John Almberg
;><><><><><><><><><><><><><><><><><><> Visit us at: www.identry.com Building You A Better Online Business <><><><><><><><><><&g

Re: remote connection

2003-11-06 Thread Curtis Maurand
Its a permissions thing on the server end. You have to have set up a user account on the server. Very important are hostnames. Curtis John Almberg said: > I'm trying to set up a remote connection to a mysql database using Perl > DBI. I have done this without problem on another database. I susp

Re: remote connection 4

2003-10-04 Thread Paul DuBois
At 22:55 +0200 10/4/03, Ms Carlsson wrote: when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen Apparently the MySQL server on domain.com is not r

Re: Remote access for mysql what variable is needed to be set

2003-08-09 Thread Stefan Hinz
Jatin, > I am running mysql 4 on linux server. I want to have a remote access > on it. what are the setting that i need to do this. You need to log into your MySQL server and grant access to your databases from wherever you want to grant access, like: mysql> GRANT ALL ON *.* TO 'remoteuser'@'%'

Re: Remote access to MySQL

2003-06-21 Thread Nils Valentin
Hi Renato, I think you should check once more the right sfor the user you have. Log in to mysql and do: mysql> SHOW GRANS FOR root ; You will get something like this: GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '17cb702624900fa5' Check what it says for the combinaion of "username"

Re: Remote access to MySQL

2003-06-17 Thread gerald_clark
Shane Bryldt wrote: Just a thought, what about encryption of passwords? Shouldn't it be: GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD('password'); No, it should not. Not sure if that is related to the problem, but it may cause an invalid password error. However, your probl

Re: Remote access to MySQL

2003-06-17 Thread Shane Bryldt
"Renato" <[EMAIL PROTECTED]> Cc: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 12:42 PM Subject: Re: Remote access to MySQL > Yes, indeed. You don't have a firewall. > But the firewall from the Internet Service Provider's computer p

Re: Remote access to MySQL

2003-06-17 Thread Shane Bryldt
Just a thought, what about encryption of passwords? Shouldn't it be: GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD('password'); Not sure if that is related to the problem, but it may cause an invalid password error. However, your problem is most likely similar to the problem

Re: Remote access to MySQL

2003-06-17 Thread Primaria Falticeni
Yes, indeed. You don't have a firewall. But the firewall from the Internet Service Provider's computer prohibits the access of the others users from the Internet to the port of your MySQL server. Or you are in a private network which must use IP port forwarding to be reached from the Internet. Talk

Re: Remote access to MySQL

2003-06-15 Thread Becoming Digital
> I have all privileges to all the databases and tables, with user 'root'. User 'root' likely doesn't have access from the desired IP. Users are configured by both name and approved hosts. Try this: GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Edward Dudlik Becoming Dig

Re: remote connection with JDBC

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Erwin Adi wrote: I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysq

Re: Remote Administration

2003-03-14 Thread Brian McCain
There are a few tools you can use to remotely administer MySQL graphically, if that's what you're looking for. You might be interested in MySQL Control Center http://www.mysql.com/products/mysqlcc/index.html although I'm not entirely certain about it's support for secure data transmission. Brian M

Re: remote login

2003-02-13 Thread Branko Kaucic
Thanks to all. Now it works! Branko On Thu, 13 Feb 2003, Martin Hudec wrote: > Hmmm, what about GRANTs on user 'username@machine_name'? > > On Thu February 13 2003 18:44, Branko Kaucic wrote: > > Hi all, > > > > I have similar problems as Kris posted on 12/17/2002. I didn't find any > > solutio

Re: remote login

2003-02-13 Thread Paul DuBois
At 18:44 +0100 2/13/03, Branko Kaucic wrote: Hi all, I have similar problems as Kris posted on 12/17/2002. I didn't find any solution, so I write this e-mail. If I connect to mysql in console with: mysql -u username -p then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and on t

Re: remote login

2003-02-13 Thread Martin Hudec
Hmmm, what about GRANTs on user 'username@machine_name'? On Thu February 13 2003 18:44, Branko Kaucic wrote: > Hi all, > > I have similar problems as Kris posted on 12/17/2002. I didn't find any > solution, so I write this e-mail. > If I connect to mysql in console with: > mysql -u username -p > >

Re: remote database

2003-01-22 Thread Bob Lockie
On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote: I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. Thanks, to all who replied. I have it working. -- Sent from

Re: remote database

2003-01-22 Thread Bhavin Vyas
I think it's allowing 'root@localhost' but not '[EMAIL PROTECTED]'. Select * from user (in mysql db) will show you all the access privileges. Add '[EMAIL PROTECTED]' to that as a user. Bhavin. - Original Message - From: "Bob Lockie" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROT

Re: remote database

2003-01-22 Thread rich allen
mysql -h10.0.0.5 -u[username] -Dvisitor -p[password] should get you in - hcir On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote: I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. It doesn't work when I

Re: remote connect crash

2003-01-09 Thread Christopher E. Brown
On Thu, 9 Jan 2003, Dmitry V. Sokolov wrote: > Good day, > could you help me to solve this problem? > > MySQL server segmentation faults when remote mysql client > tries to connect on source and binary distributions. Local > client connect does not cause any problems whatsoever. The server dies

Re: remote connect crash

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
Dmitry, > MySQL server segmentation faults when remote mysql client > tries to connect on source and binary distributions. Local > client connect does not cause any problems whatsoever. I had the same sort of problem with MySQL 3.23.5x servers on SuSE Linux 8.0/8.1, and some newsgroup postings re

Re: remote connect crash

2003-01-09 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dmitry V. Sokolov wrote: Good day, could you help me to solve this problem? This is a known issue that is already fixed in the BK source for 4.0.x, and will be in 4.0.9, which is currently being built. -Mark - -- MySQL 2003 Users Conference -

Re: remote connect crash

2003-01-09 Thread Gelu Gogancea
Hi, Start mysql daemon with options "--skip-name-resolve" Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Dmitry

RE: remote tcp connection failure

2002-12-17 Thread JamesD
edatabase the firewall accepts the connect and NAT's it to the right machine inside Jim -Original Message- From: Kristopher Yates [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:04 AM To: comcast.net; [EMAIL PROTECTED] Subject: Re: remote tcp connection failure i shoved it

RE: remote tcp connection failure

2002-12-17 Thread Jennifer Goodie
It sounds like you need to edit your hosts.allow file to allow from the IP you want to connect from. add either mysqld : ###.###.###.### : allow or mysqld : all : allow I'm not a sysadmin though, so you might want to do a search on the proper way to do this. -Original Message- From: Kr

Re: remote tcp connection failure

2002-12-17 Thread Kristopher Yates
i shoved it up my ass and things are now running great. Thanks for your invaluable assistance. Now if anyone on this list can be more helpful, I might just have an orgasm, as well as a fix to my 'problem'. Where is Paul DuBois when you need him? MY friend Jason says to look for him on here.

Re: Remote Connection, please help

2002-12-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: > Dear Mark, real thanks , Are you refering to this > issues: > > Issue: > > "When I try to connect to the database with MySQL > Connector/J , I get the > following exception: > Yes. [snip] >>>Thanks Mark for your real quic

Re: Remote Connection, please help

2002-12-12 Thread Csongor Fagyal
Subject: Remote Connection, please help I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using

Re: Remote Connection, please help

2002-12-12 Thread Peter T. Abplanalp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 first a note: this is a topic best discussed on [EMAIL PROTECTED] * On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote: > I am using the official type 4 mysql driver from > www.mysql.com but unable to make a remote connection > with the m

Re: Remote Connection, please help

2002-12-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the ri

RE: Remote Connection, please help

2002-12-12 Thread Peter Vertes
I've never connected your way before. I'm using J/Connector from the MySQL site (http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems connecting. I do it this way: // connect to the database Class.forName("com.mysql.jdbc.Driver"); Connection dbConnection = Drive

Re: Remote connection is blocked because of many connection errors

2002-12-05 Thread Jeremy Zawodny
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote: > I have a problem here. > > I cannot connect to a particular server remotely at certain times. > I get the error remote connection is blocked because of many > connection errors. I can login locally on the box. Ok. > To resolve this p

RE: Remote Connectivity

2002-10-23 Thread Daevid Vincent
Well, you could have the Canadian admin add your pakistan IP address/host to the "mysql" database in the "hosts" table, along with the proper "user" and "db" I'm sure. Then you can use any 3rd party mySQL client to connect and do whatever you want. Something I just did recently is to install phpMy

RE: remote connections have stopped working

2002-10-16 Thread Jon Keller
Moving from glibc 2.2.5-40 to glibc 2.2.5-39 has solved the problem i was having with remote connections, Thanks to everyone who helped. -Jon Keller At 06:18 AM 10/16/2002 -0500, you wrote: >I started to receive this error as well after upgrading the glibc update >just released from Red

re: remote connections have stopped working

2002-10-16 Thread Jon Keller
Mysql was installed from binary, and this is redhat 7.3 running kernel 2.4.18-3 At 02:16 PM 10/16/2002 +0300, you wrote: >Jon, >Wednesday, October 16, 2002, 8:04:12 AM, you wrote: > >JK> I'm running mysql-3.23.49 on a redhat machine, mysql has stopped >responding >JK> to remote connections

re: remote connections have stopped working

2002-10-16 Thread Victoria Reznichenko
Jon, Wednesday, October 16, 2002, 8:04:12 AM, you wrote: JK> I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding JK> to remote connections ever since i rebooted it today. JK> /var/log/mysqld.log says JK> Number of processes running now: 1 JK> mysqld process hanging, pid 3

RE: Remote Connection Probem

2002-10-08 Thread Daevid Vincent
Kuss [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 11:04 AM > To: Ronald Petty > Cc: [EMAIL PROTECTED] > Subject: Re: Remote Connection Probem > > > Thanks for your response. > I tried to connect to the server via telnet as you suggested > with the follow

Re: Remote Connection Probem

2002-10-08 Thread Stefan Kuss
al Message - From: "Ronald Petty" <[EMAIL PROTECTED]> To: "Stefan Kuss" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 10:59 PM Subject: Re: Remote Connection Probem > Try this > telnet yourmachine 3306 > > If you

RE: Remote Connection Probem

2002-10-07 Thread Daevid Vincent
I have the exact same problem. Nothing has changed other than I upgraded from RH7.3 to RH8.0. I've tried at least five (5) different mySQL windows clients and all refuse to connect. However I can use phpMyAdmin locally (via web) and also all my web based database pages work fine too. I've tried ad

re: re: Remote ServerAccess

2002-09-24 Thread Victoria Reznichenko
Eric, Monday, September 23, 2002, 6:55:57 PM, you wrote: EL> Well what if you have a user that you want to give permission to from any EL> computer in the domain. EL> Such as user: mysqluser with READ|SELECT|UPDATE from anywhere EL> in: mydomain.com EL> But not from any other domain. Did

re: Remote ServerAccess

2002-09-23 Thread Eric Lamendola
Follow up question, Well what if you have a user that you want to give permission to from any computer in the domain. Such as user: mysqluser with READ|SELECT|UPDATE from anywhere in: mydomain.com But not from any other domain. Thanks, Eric Lamendola Slingo Inc. And if not, Hey wh

re: Remote ServerAccess

2002-09-23 Thread Victoria Reznichenko
Patrick, Monday, September 23, 2002, 4:24:13 PM, you wrote: PF> I'm just starting out with MySQL. How do you set permission to allow for PF> access from a domain or IP. I found this in the docs. I this all I need? PF> GRANT ALL PRIVILEGES ON *.* TO monty@"%" -> IDENTIFIED BY 'some_pass' WITH

Re: Remote admin app?

2002-08-31 Thread J Irwin
Just found a new one I really like. Does everything, create tables, queries, etc. The best part is that you can create really nice formated reports. http://www.mysqlstudio.com/feature.php3 Jayne - Original Message - From: "neal" <[EMAIL PROTECTED]> To: "mySQL" <[EMAIL PROTECTED]> Sent: F

Re: Remote admin app?

2002-08-30 Thread ju
urSQL from http://www.urbanresearch.com/ursql -- I mostly use urSQL as a development tool for ad hoc queries and reports and stuff -- as well as some basic "admin" tasks... On Fri, 30 Aug 2002, neal wrote: > What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? > Other? > > W

RE: Remote admin app?

2002-08-30 Thread Todd Schacherl
Neal, I use Webmin. It has a MySQL module that allows you to create and drop tables as well as view, edit, add, and delete the records in the tables. I run it on a Linux box and it has other admin features for the rest of the system as well. Todd -Original Message- From: neal [mailto:

Re: Remote admin app?

2002-08-30 Thread John McCauley
phpMyAdmin Great tool. - Original Message - From: "neal" <[EMAIL PROTECTED]> To: "mySQL" <[EMAIL PROTECTED]> Sent: Friday, August 30, 2002 4:07 PM Subject: Remote admin app? > What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? > Other? > > What's most popular and

Re: Remote admin app?

2002-08-30 Thread //mikezero/
if a web based solution is possible for you, use phpMyAdmin. http://phpwizard.net/projects/phpMyAdmin/ //mikezero/ //radiotakeover neal wrote: >What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? >Other? > >What's most popular and why? > >Thanks! >Neal > > >---

Re: Remote entry

2002-07-12 Thread Egor Egorov
Charitha, Friday, July 12, 2002, 7:49:03 AM, you wrote: C> Can i make mysql to put enteries in two different machines C> If there is an entry made in mysql in local machine, is there any options C> so that the same entry is made in the remote machine mysql db C> If there is any option pls. let me

  1   2   >