Hi,
is it possible to connect with Mysql Administrator (1.0.12) to an 4.1.4 mysql
server runnig with either named pipes or shared memory on winxp/2k?
As far as I tried no chance, but I may be proven wrong.
Thanks
Friedhelm
--
http://www.jungle-world.com/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
On Tuesday 21 September 2004 23:08, Friedhelm Betz wrote:
> Hi,
> is it possible to connect with Mysql Administrator (1.0.12) to an 4.1.4
> mysql server runnig with either named pipes or shared memory on winxp/2k?
> As far as I tried no chance, but I may be proven wrong.
>
> Thanks
> Friedhelm
Sorry, just realized it is the wrong list...
F.
--
http://www.jungle-world.com/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
ron,
the pipe-transport does not connect a port,
it connects a pipe with an unique name. In current versions, mysql =
server creates a pipe-listener with default (device)name \\.\PIPE\mysql =
but only, if option 'enable-named-pipe =3D1' is specified in the config =
file.
On the local-host, the transport through the named-pipe mechanismus is =
faster than through the tcp/ip stack, as it is implemented mostly like =
an inter-process-comm. (IPC).
On a remote system, things look different, the named-pipe-protocol is =
routed down a thicker stack (SMB->NetBIOS Session Service->TCP->IP) and =
has imho disadvantages against the pure tcp/ip connection. First of all, =
you run into problems with security-descriptors and firewalls.
I've observed a few other problems regarding named-pipe-connections so =
my recommendation is thorough testing before working with this =
feature...
regards,armin.
> -----Original Message-----
> From: Randy Clamons [mailto:randy@novaspace.com]=20
> Sent: Saturday, April 09, 2005 12:29 AM
> To: Ron Smith; MySQL Mailing List
> Subject: Re: MySQL Administrator
>=20
> Since you are able to ping 127.0.0.1, you must have TCP/IP=20
> enabled! Why would you rather use a named pipe? It's slower=20
> and, I think, a bit less secure.
>=20
> What's the mysqld section of you my.ini look like?
>=20
> Randy Clamons
> Systems Programming
> Novaspace.com
>=20
>=20
> > ------------Original Message------------
> > From: Ron Smith
> > To: "MySQL Mailing List"
> > Date: Fri, Apr-8-2005 3:07 PM
> > Subject: MySQL Administrator
> >
> > There's one last problem. I've downloaded and installed "MySQL=20
> > Administrator". But, I'd like to use the named pipe 'mysql'=20
> instead of=20
> > port '3306' to establish a connection (I'm not connected to=20
> anything=20
> > via TCP/IP). When I try to establish a connection with a named pipe=20
> > specified in "MySQL Amin" and with the port specified at=20
> '3306', I get an error.
> > 'ping' works to '127.0.0.1'. The 'OK' button to establish the=20
> > connection greys-out when I try to remove the port number=20
> and just use=20
> > the named pipe setting by itself. Is there something I'm=20
> missing? Ping=20
> > replies with the following:
> > Reply from 127.0.0.1: Time=3D0ms TTL=3D128 Reply from=20
> 127.0.0.1: Time=3D0ms=20
> > TTL=3D128 Reply from 127.0.0.1: Time=3D0ms TTL=3D128 Reply from=20
> 127.0.0.1:=20
> > Time=3D0ms TTL=3D128 TIA again for any help.
> > Ron
> >=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =20
> http://lists.mysql.com/win32?unsub=3Darmin.schoeffmann@aegae on.de
>=20
>=20
>=20
>=20
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
Yep, it's just that my machine is not connected to any
network. It's a standalone that I'm using to develop
on, before connecting it to a network.
Here's what 'my.ini' looks like.
>=======================snip=====================<
# CLIENT SECTION
#
------------------------------------------------------------ ----------
#
# The following options will be read by MySQL client
applications.
# Note that only client applications shipped by MySQL
are guaranteed
# to read this section. If you want your own MySQL
client program to
# honor these values, you need to specify it as an
option during the
# MySQL client library initialization.
#
[client]
pipe
socket=mysql
# SERVER SECTION
#
------------------------------------------------------------ ----------
#
# The following options will be read by the MySQL
Server. Make sure that
# you have installed the server correctly (see above)
so it reads this
# file.
#
[mysqld]
skip-networking
enable-named-pipe
>=======================snip=====================<
# The Pipe the MySQL Server will use
socket=mysql
--- Armin Schöffmann
wrote:
> ron,
> the pipe-transport does not connect a port,
> it connects a pipe with an unique name. In current
> versions, mysql server creates a pipe-listener with
> default (device)name \\.\PIPE\mysql but only, if
> option 'enable-named-pipe =1' is specified in the
> config file.
>
> On the local-host, the transport through the
> named-pipe mechanismus is faster than through the
> tcp/ip stack, as it is implemented mostly like an
> inter-process-comm. (IPC).
>
> On a remote system, things look different, the
> named-pipe-protocol is routed down a thicker stack
> (SMB->NetBIOS Session Service->TCP->IP) and has imho
> disadvantages against the pure tcp/ip connection.
> First of all, you run into problems with
> security-descriptors and firewalls.
>
> I've observed a few other problems regarding
> named-pipe-connections so my recommendation is
> thorough testing before working with this feature...
>
> regards,armin.
>
>
>
> > -----Original Message-----
> > From: Randy Clamons [mailto:randy@novaspace.com]
> > Sent: Saturday, April 09, 2005 12:29 AM
> > To: Ron Smith; MySQL Mailing List
> > Subject: Re: MySQL Administrator
> >
> > Since you are able to ping 127.0.0.1, you must
> have TCP/IP
> > enabled! Why would you rather use a named pipe?
> It's slower
> > and, I think, a bit less secure.
> >
> > What's the mysqld section of you my.ini look like?
> >
> > Randy Clamons
> > Systems Programming
> > Novaspace.com
> >
> >
> > > ------------Original Message------------
> > > From: Ron Smith
> > > To: "MySQL Mailing List"
> > > Date: Fri, Apr-8-2005 3:07 PM
> > > Subject: MySQL Administrator
> > >
> > > There's one last problem. I've downloaded and
> installed "MySQL
> > > Administrator". But, I'd like to use the named
> pipe 'mysql'
> > instead of
> > > port '3306' to establish a connection (I'm not
> connected to
> > anything
> > > via TCP/IP). When I try to establish a
> connection with a named pipe
> > > specified in "MySQL Amin" and with the port
> specified at
> > '3306', I get an error.
> > > 'ping' works to '127.0.0.1'. The 'OK' button to
> establish the
> > > connection greys-out when I try to remove the
> port number
> > and just use
> > > the named pipe setting by itself. Is there
> something I'm
> > missing? Ping
> > > replies with the following:
> > > Reply from 127.0.0.1: Time=0ms TTL=128 Reply
> from
> > 127.0.0.1: Time=0ms
> > > TTL=128 Reply from 127.0.0.1: Time=0ms TTL=128
> Reply from
> > 127.0.0.1:
> > > Time=0ms TTL=128 TIA again for any help.
> > > Ron
> > >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
>
http://lists.mysql.com/win32?unsub=armin.schoeffmann@aegaeon .de
> >
> >
> >
> >
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Yep,
I'm using 'localhost' in the server field. I'll check
into www.mysqlfront.de in the meantime.
Ron
--- Petr Vileta
> I don't know "MySQL Administrator" but it must have
> some connection dialog.
> Write "localhost" into "Server:" field in this
> dialog.
> BTW take a look to www.mysqlfront.de :-)
>
> Petr Vileta
> http://www.zivnosti.cz
> http://www.practisoft.cz
>
> ----- Original Message -----
> From: "Ron Smith"
> To: "MySQL Mailing List"
> Sent: Saturday, April 09, 2005 12:06 AM
> Subject: MySQL Administrator
>
>
> > There's one last problem. I've downloaded and
> installed "MySQL
> Administrator". But, I'd like to use the named pipe
> 'mysql' instead of port
> '3306' to establish a connection (I'm not connected
> to anything via TCP/IP).
> When I try to establish a connection with a named
> pipe specified in "MySQL
> Amin" and with the port specified at '3306', I get
> an error. 'ping' works to
> '127.0.0.1'. The 'OK' button to establish the
> connection greys-out when I
> try to remove the port number and just use the named
> pipe setting by itself.
> Is there something I'm missing? Ping replies with
> the following:
> > Reply from 127.0.0.1: Time=0ms TTL=128
> > Reply from 127.0.0.1: Time=0ms TTL=128
> > Reply from 127.0.0.1: Time=0ms TTL=128
> > Reply from 127.0.0.1: Time=0ms TTL=128
> > TIA again for any help.
> > Ron
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
No network connection is not a problem, as long as you have a network card =
installed. You can ping, therefore you can connect! Specify the ip address =
(127.0.0.1) rather than localhost as your bind address. Port should remain =
3306, unless you have other special needs like running more than one server=
on a single machine. =
Randy Clamons
Systems Programming
Novaspace.com
> ------------Original Message------------
> From: Ron Smith
> To: "MySQL Mailing List"
> Date: Fri, Apr-8-2005 4:42 PM
> Subject: RE: MySQL Administrator
>
> Yep, it's just that my machine is not connected to any
> network. It's a standalone that I'm using to develop
> on, before connecting it to a network.
> =
> Here's what 'my.ini' looks like.
> =
> >===================3D=3 D===3Dsni=
p===================3D=3 D=3D<
> =
> # CLIENT SECTION
> #
> ------------------------------------------------------------ ----------
> #
> # The following options will be read by MySQL client
> applications.
> # Note that only client applications shipped by MySQL
> are guaranteed
> # to read this section. If you want your own MySQL
> client program to
> # honor these values, you need to specify it as an
> option during the
> # MySQL client library initialization.
> #
> [client]
> =
> pipe
> socket=3Dmysql
> =
> =
> # SERVER SECTION
> #
> ------------------------------------------------------------ ----------
> #
> # The following options will be read by the MySQL
> Server. Make sure that
> # you have installed the server correctly (see above)
> so it reads this =
> # file.
> #
> [mysqld]
> =
> skip-networking
> enable-named-pipe
> =
> >===================3D=3 D===3Dsni=
p===================3D=3 D=3D<
> =
> # The Pipe the MySQL Server will use
> socket=3Dmysql
> --- Armin Schöffmann
> wrote:
> > ron,
> > the pipe-transport does not connect a port,
> > it connects a pipe with an unique name. In current
> > versions, mysql server creates a pipe-listener with
> > default (device)name \\.\PIPE\mysql but only, if
> > option 'enable-named-pipe =3D1' is specified in the
> > config file.
> > =
> > On the local-host, the transport through the
> > named-pipe mechanismus is faster than through the
> > tcp/ip stack, as it is implemented mostly like an
> > inter-process-comm. (IPC).
> > =
> > On a remote system, things look different, the
> > named-pipe-protocol is routed down a thicker stack
> > (SMB->NetBIOS Session Service->TCP->IP) and has imho
> > disadvantages against the pure tcp/ip connection.
> > First of all, you run into problems with
> > security-descriptors and firewalls.
> > =
> > I've observed a few other problems regarding
> > named-pipe-connections so my recommendation is
> > thorough testing before working with this feature...
> > =
> > regards,armin.
> > =
> > =
> > =
> > > -----Original Message-----
> > > From: Randy Clamons [mailto:randy@novaspace.com] =
> > > Sent: Saturday, April 09, 2005 12:29 AM
> > > To: Ron Smith; MySQL Mailing List
> > > Subject: Re: MySQL Administrator
> > > =
> > > Since you are able to ping 127.0.0.1, you must
> > have TCP/IP =
> > > enabled! Why would you rather use a named pipe?
> > It's slower =
> > > and, I think, a bit less secure.
> > > =
> > > What's the mysqld section of you my.ini look like?
> > > =
> > > Randy Clamons
> > > Systems Programming
> > > Novaspace.com
> > > =
> > > =
> > > > ------------Original Message------------
> > > > From: Ron Smith
> > > > To: "MySQL Mailing List"
> > > > Date: Fri, Apr-8-2005 3:07 PM
> > > > Subject: MySQL Administrator
> > > >
> > > > There's one last problem. I've downloaded and
> > installed "MySQL =
> > > > Administrator". But, I'd like to use the named
> > pipe 'mysql' =
> > > instead of =
> > > > port '3306' to establish a connection (I'm not
> > connected to =
> > > anything =
> > > > via TCP/IP). When I try to establish a
> > connection with a named pipe =
> > > > specified in "MySQL Amin" and with the port
> > specified at =
> > > '3306', I get an error.
> > > > 'ping' works to '127.0.0.1'. The 'OK' button to
> > establish the =
> > > > connection greys-out when I try to remove the
> > port number =
> > > and just use =
> > > > the named pipe setting by itself. Is there
> > something I'm =
> > > missing? Ping =
> > > > replies with the following:
> > > > Reply from 127.0.0.1: Time=3D0ms TTL=3D128 Reply
> > from =
> > > 127.0.0.1: Time=3D0ms =
> > > > TTL=3D128 Reply from 127.0.0.1: Time=3D0ms TTL=3D128
> > Reply from =
> > > 127.0.0.1: =
> > > > Time=3D0ms TTL=3D128 TIA again for any help.
> > > > Ron
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
--0-1539643999-1113064468=:92039
Content-Type: text/plain; charset=us-ascii
Hmmm,
....doesn't work with 127.0.0.1 instead of localhost with 3306 as the port either. The command-line client that comes with MySQL connects just fine using a named pipe. I just thought it would be nice to have a front end to things. I'm not sure what you mean by "running more than one server". What I'm trying to do is develop web pages and Visual Basic applications that interact with MySQL. There are other services running like IIS ...etc.
Ron
dy Clamons
No network connection is not a problem, as long as you have a network card installed. You can ping, therefore you can connect! Specify the ip address (127.0.0.1) rather than localhost as your bind address. Port should remain 3306, unless you have other special needs like running more than one server on a single machine.
Randy Clamons
Systems Programming
Novaspace.com
> ------------Original Message------------
> From: Ron Smith
> To: "MySQL Mailing List"
> Date: Fri, Apr-8-2005 4:42 PM
> Subject: RE: MySQL Administrator
>
> Yep, it's just that my machine is not connected to any
> network. It's a standalone that I'm using to develop
> on, before connecting it to a network.
>
> Here's what 'my.ini' looks like.
>
> >=======================snip=====================<
>
> # CLIENT SECTION
> #
> ------------------------------------------------------------ ----------
> #
> # The following options will be read by MySQL client
> applications.
> # Note that only client applications shipped by MySQL
> are guaranteed
> # to read this section. If you want your own MySQL
> client program to
> # honor these values, you need to specify it as an
> option during the
> # MySQL client library initialization.
> #
> [client]
>
> pipe
> socket=mysql
>
>
> # SERVER SECTION
> #
> ------------------------------------------------------------ ----------
> #
> # The following options will be read by the MySQL
> Server. Make sure that
> # you have installed the server correctly (see above)
> so it reads this
> # file.
> #
> [mysqld]
>
> skip-networking
> enable-named-pipe
>
> >=======================snip=====================<
>
> # The Pipe the MySQL Server will use
> socket=mysql
> --- Armin Schöffmann
> wrote:
> > ron,
> > the pipe-transport does not connect a port,
> > it connects a pipe with an unique name. In current
> > versions, mysql server creates a pipe-listener with
> > default (device)name \\.\PIPE\mysql but only, if
> > option 'enable-named-pipe =1' is specified in the
> > config file.
> >
> > On the local-host, the transport through the
> > named-pipe mechanismus is faster than through the
> > tcp/ip stack, as it is implemented mostly like an
> > inter-process-comm. (IPC).
> >
> > On a remote system, things look different, the
> > named-pipe-protocol is routed down a thicker stack
> > (SMB->NetBIOS Session Service->TCP->IP) and has imho
> > disadvantages against the pure tcp/ip connection.
> > First of all, you run into problems with
> > security-descriptors and firewalls.
> >
> > I've observed a few other problems regarding
> > named-pipe-connections so my recommendation is
> > thorough testing before working with this feature...
> >
> > regards,armin.
> >
> >
> >
> > > -----Original Message-----
> > > From: Randy Clamons [mailto:randy@novaspace.com]
> > > Sent: Saturday, April 09, 2005 12:29 AM
> > > To: Ron Smith; MySQL Mailing List
> > > Subject: Re: MySQL Administrator
> > >
> > > Since you are able to ping 127.0.0.1, you must
> > have TCP/IP
> > > enabled! Why would you rather use a named pipe?
> > It's slower
> > > and, I think, a bit less secure.
> > >
> > > What's the mysqld section of you my.ini look like?
> > >
> > > Randy Clamons
> > > Systems Programming
> > > Novaspace.com
> > >
> > >
> > > > ------------Original Message------------
> > > > From: Ron Smith
> > > > To: "MySQL Mailing List"
> > > > Date: Fri, Apr-8-2005 3:07 PM
> > > > Subject: MySQL Administrator
> > > >
> > > > There's one last problem. I've downloaded and
> > installed "MySQL
> > > > Administrator". But, I'd like to use the named
> > pipe 'mysql'
> > > instead of
> > > > port '3306' to establish a connection (I'm not
> > connected to
> > > anything
> > > > via TCP/IP). When I try to establish a
> > connection with a named pipe
> > > > specified in "MySQL Amin" and with the port
> > specified at
> > > '3306', I get an error.
> > > > 'ping' works to '127.0.0.1'. The 'OK' button to
> > establish the
> > > > connection greys-out when I try to remove the
> > port number
> > > and just use
> > > > the named pipe setting by itself. Is there
> > something I'm
> > > missing? Ping
> > > > replies with the following:
> > > > Reply from 127.0.0.1: Time=0ms TTL=128 Reply
> > from
> > > 127.0.0.1: Time=0ms
> > > > TTL=128 Reply from 127.0.0.1: Time=0ms TTL=128
> > Reply from
> > > 127.0.0.1:
> > > > Time=0ms TTL=128 TIA again for any help.
> > > > Ron
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
--0-1539643999-1113064468=:92039--
Hello,
If you are on Windows then I would suggest SQLyog
(www.webyog.com). Its by far the best GUI i have used
and I have tried atleast 6 other MySQL GUI.
Karam
--- Ron Smith
> Yep,
>
> I'm using 'localhost' in the server field. I'll
> check
> into www.mysqlfront.de in the meantime.
>
> Ron
>
> --- Petr Vileta
> > I don't know "MySQL Administrator" but it must
> have
> > some connection dialog.
> > Write "localhost" into "Server:" field in this
> > dialog.
> > BTW take a look to www.mysqlfront.de :-)
> >
> > Petr Vileta
> > http://www.zivnosti.cz
> > http://www.practisoft.cz
> >
> > ----- Original Message -----
> > From: "Ron Smith"
> > To: "MySQL Mailing List"
> > Sent: Saturday, April 09, 2005 12:06 AM
> > Subject: MySQL Administrator
> >
> >
> > > There's one last problem. I've downloaded and
> > installed "MySQL
> > Administrator". But, I'd like to use the named
> pipe
> > 'mysql' instead of port
> > '3306' to establish a connection (I'm not
> connected
> > to anything via TCP/IP).
> > When I try to establish a connection with a named
> > pipe specified in "MySQL
> > Amin" and with the port specified at '3306', I get
> > an error. 'ping' works to
> > '127.0.0.1'. The 'OK' button to establish the
> > connection greys-out when I
> > try to remove the port number and just use the
> named
> > pipe setting by itself.
> > Is there something I'm missing? Ping replies with
> > the following:
> > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > TIA again for any help.
> > > Ron
> > >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
>
http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
> >
> >
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
I have one copy of few mont old SQLyog but IMHO MySQL-Front will be better
shortly ;-)
Petr Vileta, Czech republic
(My server reject all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
----- Original Message -----
From: "Karam Chand"
To: "Ron Smith"
Sent: Saturday, April 09, 2005 11:54 PM
Subject: Re: MySQL Administrator
> Hello,
>
> If you are on Windows then I would suggest SQLyog
> (www.webyog.com). Its by far the best GUI i have used
> and I have tried atleast 6 other MySQL GUI.
>
> Karam
>
> --- Ron Smith
> > Yep,
> >
> > I'm using 'localhost' in the server field. I'll
> > check
> > into www.mysqlfront.de in the meantime.
> >
> > Ron
> >
> > --- Petr Vileta
> > > I don't know "MySQL Administrator" but it must
> > have
> > > some connection dialog.
> > > Write "localhost" into "Server:" field in this
> > > dialog.
> > > BTW take a look to www.mysqlfront.de :-)
> > >
> > > Petr Vileta
> > > http://www.zivnosti.cz
> > > http://www.practisoft.cz
> > >
> > > ----- Original Message -----
> > > From: "Ron Smith"
> > > To: "MySQL Mailing List"
> > > Sent: Saturday, April 09, 2005 12:06 AM
> > > Subject: MySQL Administrator
> > >
> > >
> > > > There's one last problem. I've downloaded and
> > > installed "MySQL
> > > Administrator". But, I'd like to use the named
> > pipe
> > > 'mysql' instead of port
> > > '3306' to establish a connection (I'm not
> > connected
> > > to anything via TCP/IP).
> > > When I try to establish a connection with a named
> > > pipe specified in "MySQL
> > > Amin" and with the port specified at '3306', I get
> > > an error. 'ping' works to
> > > '127.0.0.1'. The 'OK' button to establish the
> > > connection greys-out when I
> > > try to remove the port number and just use the
> > named
> > > pipe setting by itself.
> > > Is there something I'm missing? Ping replies with
> > > the following:
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > TIA again for any help.
> > > > Ron
> > > >
> > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > >
> >
> http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
> > >
> > >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
> >
> >
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=petr@practisoft.cz
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
--0-2107919005-1113239219=:31146
Content-Type: text/plain; charset=us-ascii
Hey all,
It seems I have solved the problem. I was making things *too* difficult for myself. The problem was I thought the 'myODBC' driver needed to be configured also. This, of course, sent me spinning out into a wild goose chase.
All I had to do was the follwing:
1) Install the mySQL database using port 3306 on localhost
2) Install the 'myODBC' driver (do *not* try to configure it; just add it through 'Data Sources' under "Administrative Tools' in the 'Control Panel'.
3) Install 'mysql-administrator' and log in.
For: MySQL Administrator-1.0.19-win.msi
Install by right-clicking on the file and selecting 'Install'.
Note: MySQL-Front is a 30-day trial license, while 'mysql-administrator' is freeware.
Thanks to everyone for their input. It really did help. I'm sure I'll be back on the list with other questions as I explore. :-)
Ron
Petr Vileta
I have one copy of few mont old SQLyog but IMHO MySQL-Front will be better
shortly ;-)
Petr Vileta, Czech republic
(My server reject all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
----- Original Message -----
From: "Karam Chand"
To: "Ron Smith" ; "MySQL Mailing List"
Sent: Saturday, April 09, 2005 11:54 PM
Subject: Re: MySQL Administrator
> Hello,
>
> If you are on Windows then I would suggest SQLyog
> (www.webyog.com). Its by far the best GUI i have used
> and I have tried atleast 6 other MySQL GUI.
>
> Karam
>
> --- Ron Smith wrote:
> > Yep,
> >
> > I'm using 'localhost' in the server field. I'll
> > check
> > into www.mysqlfront.de in the meantime.
> >
> > Ron
> >
> > --- Petr Vileta
wrote:
> > > I don't know "MySQL Administrator" but it must
> > have
> > > some connection dialog.
> > > Write "localhost" into "Server:" field in this
> > > dialog.
> > > BTW take a look to www.mysqlfront.de :-)
> > >
> > > Petr Vileta
> > > http://www.zivnosti.cz
> > > http://www.practisoft.cz
> > >
> > > ----- Original Message -----
> > > From: "Ron Smith"
> > > To: "MySQL Mailing List"
> > > Sent: Saturday, April 09, 2005 12:06 AM
> > > Subject: MySQL Administrator
> > >
> > >
> > > > There's one last problem. I've downloaded and
> > > installed "MySQL
> > > Administrator". But, I'd like to use the named
> > pipe
> > > 'mysql' instead of port
> > > '3306' to establish a connection (I'm not
> > connected
> > > to anything via TCP/IP).
> > > When I try to establish a connection with a named
> > > pipe specified in "MySQL
> > > Amin" and with the port specified at '3306', I get
> > > an error. 'ping' works to
> > > '127.0.0.1'. The 'OK' button to establish the
> > > connection greys-out when I
> > > try to remove the port number and just use the
> > named
> > > pipe setting by itself.
> > > Is there something I'm missing? Ping replies with
> > > the following:
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > TIA again for any help.
> > > > Ron
> > > >
> > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > >
> >
> http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
> > >
> > >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
> >
> >
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=petr@practisoft.cz
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
--0-2107919005-1113239219=:31146--
--0-520622840-1113319773=:13481
Content-Type: text/plain; charset=us-ascii
Armin,
Yes, both excellent points. The first of which I shortly found out in comparing another front-end with mysql-administrator. And, my apologies on the second point due to ignorance, on my part, of the facts.
Thanks for your corrections. :-)
Ron
Armin Schöffmann
Ron,
mysql-administrator is not linked to myodbc as it uses the dynamic c-api-lib.
your point 2) should be re-verified.
mysql-administrator is covered by GPL - and not free-ware. there might be people in the list considering this fact an important difference.
:-)
regards,armin.
> -----Original Message-----
> From: Ron Smith [mailto:geeksatlarge@yahoo.com]
> Sent: Monday, April 11, 2005 7:07 PM
> To: MySQL Mailing List
> Subject: Re: MySQL Administrator
>
> Hey all,
>
> It seems I have solved the problem. I was making things *too*
> difficult for myself. The problem was I thought the 'myODBC'
> driver needed to be configured also. This, of course, sent me
> spinning out into a wild goose chase.
>
> All I had to do was the follwing:
>
> 1) Install the mySQL database using port 3306 on localhost
> 2) Install the 'myODBC' driver (do *not* try to configure
> it; just add it through 'Data Sources' under "Administrative
> Tools' in the 'Control Panel'.
> 3) Install 'mysql-administrator' and log in.
>
> For: MySQL Administrator-1.0.19-win.msi
> Install by right-clicking on the file and selecting 'Install'.
>
> Note: MySQL-Front is a 30-day trial license, while
> 'mysql-administrator' is freeware.
>
> Thanks to everyone for their input. It really did help. I'm
> sure I'll be back on the list with other questions as I explore. :-)
>
> Ron
>
> Petr Vileta
wrote:
> I have one copy of few mont old SQLyog but IMHO MySQL-Front
> will be better shortly ;-)
>
>
> Petr Vileta, Czech republic
> (My server reject all messages from Yahoo and Hotmail. Send
> me your mail from another non-spammer site please.)
>
>
> ----- Original Message -----
> From: "Karam Chand"
> To: "Ron Smith" ; "MySQL Mailing List"
>
> Sent: Saturday, April 09, 2005 11:54 PM
> Subject: Re: MySQL Administrator
>
>
> > Hello,
> >
> > If you are on Windows then I would suggest SQLyog (www.webyog.com).
> > Its by far the best GUI i have used and I have tried
> atleast 6 other
> > MySQL GUI.
> >
> > Karam
> >
> > --- Ron Smith wrote:
> > > Yep,
> > >
> > > I'm using 'localhost' in the server field. I'll check into
> > > www.mysqlfront.de in the meantime.
> > >
> > > Ron
> > >
> > > --- Petr Vileta
> wrote:
> > > > I don't know "MySQL Administrator" but it must
> > > have
> > > > some connection dialog.
> > > > Write "localhost" into "Server:" field in this dialog.
> > > > BTW take a look to www.mysqlfront.de :-)
> > > >
> > > > Petr Vileta
> > > > http://www.zivnosti.cz
> > > > http://www.practisoft.cz
> > > >
> > > > ----- Original Message -----
> > > > From: "Ron Smith"
> > > > To: "MySQL Mailing List"
> > > > Sent: Saturday, April 09, 2005 12:06 AM
> > > > Subject: MySQL Administrator
> > > >
> > > >
> > > > > There's one last problem. I've downloaded and
> > > > installed "MySQL
> > > > Administrator". But, I'd like to use the named
> > > pipe
> > > > 'mysql' instead of port
> > > > '3306' to establish a connection (I'm not
> > > connected
> > > > to anything via TCP/IP).
> > > > When I try to establish a connection with a named pipe
> specified
> > > > in "MySQL Amin" and with the port specified at '3306', I get an
> > > > error. 'ping' works to '127.0.0.1'. The 'OK' button to
> establish
> > > > the connection greys-out when I try to remove the port
> number and
> > > > just use the
> > > named
> > > > pipe setting by itself.
> > > > Is there something I'm missing? Ping replies with the following:
> > > > > Reply from 127.0.0.1: Time=0ms TTL=128 Reply from 127.0.0.1:
> > > > > Time=0ms TTL=128 Reply from 127.0.0.1: Time=0ms TTL=128 Reply
> > > > > from 127.0.0.1: Time=0ms TTL=128 TIA again for any help.
> > > > > Ron
> > > > >
> > > >
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives: http://lists.mysql.com/win32 To unsubscribe:
> > > >
> > >
> > http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
> > > >
> > > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32 To unsubscribe:
> > >
> > http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
> > >
> > >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new resources site!
> > http://smallbusiness.yahoo.com/resources/
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32 To unsubscribe:
> > http://lists.mysql.com/win32?unsub=petr@practisoft.cz
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32 To
> unsubscribe: http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
>
>
--0-520622840-1113319773=:13481--
MySQL-Front crashes too many times.
--- Petr Vileta
> I have one copy of few mont old SQLyog but IMHO
> MySQL-Front will be better
> shortly ;-)
>
>
> Petr Vileta, Czech republic
> (My server reject all messages from Yahoo and
> Hotmail. Send me your mail
> from another non-spammer site please.)
>
>
> ----- Original Message -----
> From: "Karam Chand"
> To: "Ron Smith"
> Mailing List"
>
> Sent: Saturday, April 09, 2005 11:54 PM
> Subject: Re: MySQL Administrator
>
>
> > Hello,
> >
> > If you are on Windows then I would suggest SQLyog
> > (www.webyog.com). Its by far the best GUI i have
> used
> > and I have tried atleast 6 other MySQL GUI.
> >
> > Karam
> >
> > --- Ron Smith
> > > Yep,
> > >
> > > I'm using 'localhost' in the server field. I'll
> > > check
> > > into www.mysqlfront.de in the meantime.
> > >
> > > Ron
> > >
> > > --- Petr Vileta
> > > > I don't know "MySQL Administrator" but it must
> > > have
> > > > some connection dialog.
> > > > Write "localhost" into "Server:" field in this
> > > > dialog.
> > > > BTW take a look to www.mysqlfront.de :-)
> > > >
> > > > Petr Vileta
> > > > http://www.zivnosti.cz
> > > > http://www.practisoft.cz
> > > >
> > > > ----- Original Message -----
> > > > From: "Ron Smith"
> > > > To: "MySQL Mailing List"
>
> > > > Sent: Saturday, April 09, 2005 12:06 AM
> > > > Subject: MySQL Administrator
> > > >
> > > >
> > > > > There's one last problem. I've downloaded
> and
> > > > installed "MySQL
> > > > Administrator". But, I'd like to use the named
> > > pipe
> > > > 'mysql' instead of port
> > > > '3306' to establish a connection (I'm not
> > > connected
> > > > to anything via TCP/IP).
> > > > When I try to establish a connection with a
> named
> > > > pipe specified in "MySQL
> > > > Amin" and with the port specified at '3306', I
> get
> > > > an error. 'ping' works to
> > > > '127.0.0.1'. The 'OK' button to establish the
> > > > connection greys-out when I
> > > > try to remove the port number and just use the
> > > named
> > > > pipe setting by itself.
> > > > Is there something I'm missing? Ping replies
> with
> > > > the following:
> > > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > > Reply from 127.0.0.1: Time=0ms TTL=128
> > > > > TIA again for any help.
> > > > > Ron
> > > > >
> > > >
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives:
> http://lists.mysql.com/win32
> > > > To unsubscribe:
> > > >
> > >
> >
>
http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com
> > > >
> > > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > >
> >
>
http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
> > >
> > >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new resources
> site!
> > http://smallbusiness.yahoo.com/resources/
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
>
http://lists.mysql.com/win32?unsub=petr@practisoft.cz
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Thanks a lot Daniel,
I read this documentation and this solved the problem,
stil, sometimes, when I look at the catalogs for one
instance, I get the catalogs for the other, I still
think there is some kind of bug in there...
Greetings
Hans Hahn
--- Daniel da Veiga
> Not a bug, not even close, kinda like a feature.
> RTM, STW, a google for "mysql administrator services
> configuration file"
> brought me this:
>
http://dev.mysql.com/doc/administrator/en/mysql-administrato r-service-control-configure-service.html
>
> While you are at it:
>
http://dev.mysql.com/doc/administrator/en/mysql-administrato r-starting-configure-service.html
>
> Good luck,
>
> On 11/17/05, Hans Hahn
> > Hi Everyone,
> >
> > I have a "problem?" with MySql Administrator
> running under Windows XP.
> > I had Mysql 4 installed with a windows service
> called Mysql runnig on
> > port 3306. I decided to test drive Mysql 5 so I
> downloaded, instaled it
> > and started up a new service on port 3307 named
> Mysq5. I opened 2 Mysql
> > administrators one for version 4 and one for
> version 5 and it worked but
> > then I noticed that the "configure service" tab
> under the Service
> > control section for the Mysql 5 version was
> actually reading the my.ini
> > file for version 4 instead of version 5.... after
> some time I noticed
> > that Mysql Administrator looks for Mysql services
> and "grabbs" the first
> > service it finds no matter to which of both
> instances I connect I think
> > this is a bug...
> >
> > Has anyone encountered a similar probem ?
> >
> >
> > Greetings
> >
> > --
> >
> > Hans Hahn
> > Director General
> >
> > Erendur Information Technology, S.C.
> > http://www.erendur.com
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$
> N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+
> y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=info@hanshahn.net
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Hmmm, I'll try and see if this happens to me, never happened with
remote connections, maybe when it comes to multiple instances at
localhost Administrator may get a little lost.
I'll check out and get back if I find something odd.
On 11/18/05, hh@erendur.com
> Thanks a lot Daniel,
> I read this documentation and this solved the problem,
> stil, sometimes, when I look at the catalogs for one
> instance, I get the catalogs for the other, I still
> think there is some kind of bug in there...
>
> Greetings
> Hans Hahn
>
>
> --- Daniel da Veiga
>
> > Not a bug, not even close, kinda like a feature.
> > RTM, STW, a google for "mysql administrator services
> > configuration file"
> > brought me this:
> >
> http://dev.mysql.com/doc/administrator/en/mysql-administrato r-service-con=
trol-configure-service.html
> >
> > While you are at it:
> >
> http://dev.mysql.com/doc/administrator/en/mysql-administrato r-starting-co=
nfigure-service.html
> >
> > Good luck,
> >
> > On 11/17/05, Hans Hahn
> > > Hi Everyone,
> > >
> > > I have a "problem?" with MySql Administrator
> > running under Windows XP.
> > > I had Mysql 4 installed with a windows service
> > called Mysql runnig on
> > > port 3306. I decided to test drive Mysql 5 so I
> > downloaded, instaled it
> > > and started up a new service on port 3307 named
> > Mysq5. I opened 2 Mysql
> > > administrators one for version 4 and one for
> > version 5 and it worked but
> > > then I noticed that the "configure service" tab
> > under the Service
> > > control section for the Mysql 5 version was
> > actually reading the my.ini
> > > file for version 4 instead of version 5.... after
> > some time I noticed
> > > that Mysql Administrator looks for Mysql services
> > and "grabbs" the first
> > > service it finds no matter to which of both
> > instances I connect I think
> > > this is a bug...
> > >
> > > Has anyone encountered a similar probem ?
> > >
> > >
> > > Greetings
> > >
> > > --
> > >
> > > Hans Hahn
> > > Director General
> > >
> > > Erendur Information Technology, S.C.
> > > http://www.erendur.com
> > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > >
> > >
> >
> >
> > --
> > Daniel da Veiga
> > Computer Operator - RS - Brazil
> > -----BEGIN GEEK CODE BLOCK-----
> > Version: 3.1
> > GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$
> > N o+ K- w O M- V-
> > PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+
> > y++
> > ------END GEEK CODE BLOCK------
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=3Dinfo@hanshahn.net
> >
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org