Access MySQL Enterprise Monitor UI Remotely

2014-11-24 Thread Blessing Kamutande (B)
Hi all, How can I access MySQL Enterprise Monitor webpage remotely. I don't want to access it through the localhost, but would like to access it like this: https://192.1.1.1:18443. Where can I change the settings so that the tomcat can listen for incoming connections from my network

Re: How many users access MySQL

2008-12-22 Thread Andy Shellam
Hi If you don't mind keeping the general log, you can periodically parse it. I read that MySQL 5.1 (or some later version) will have an option to keep the general log in a table - that will be very handy. Be careful if you use this option (logging to a table) - while it's an extremely att

Re: How many users access MySQL

2008-12-21 Thread Chandru
Hi Shuly, you can use the method suggested by Shuly or you cook up your query logs if you need more accurate information. May be you can write a small script to do the job. Regards, Chandru forums.mafiree.com On Mon, Dec 22, 2008 at 7:34 AM, mos wrote: > At 02:32 PM 12/21/2008, y

Re: How many users access MySQL

2008-12-21 Thread Jim Lyons
If you don't mind keeping the general log, you can periodically parse it. I read that MySQL 5.1 (or some later version) will have an option to keep the general log in a table - that will be very handy. On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly wrote: > > Hi, > > Is there any way to figure

Re: How many users access MySQL

2008-12-21 Thread mos
At 02:32 PM 12/21/2008, you wrote: Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information,

How many users access MySQL

2008-12-21 Thread Avraham, Shuly
Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information, and be able to analyze it later. Than

Re: Access mySQL database across Internet

2006-08-15 Thread Chris
Neil Tompkins wrote: The problem appears to be retrieving the data which is slow. Are you sure it's not the actual query that's slow? If you run the query in mysql (ie through the command prompt) is it fast? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

RE: Access mySQL database across Internet

2006-08-15 Thread Neil Tompkins
The problem appears to be retrieving the data which is slow. > Date: Tue, 15 Aug 2006 11:32:23 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > You could look into establishin

Re: Access mySQL database across Internet

2006-08-15 Thread Dan Buettner
AIL PROTECTED]> wrote: The connection time to my mySQL database is OK from the ASP page. Are there any ways to speed this up though ? > From: [EMAIL PROTECTED]> To: My.SQL " "@ashcomp.net> Subject: RE: Access mySQL database across Internet> Date: Fri, 11 Aug 2006 12:20:19

RE: Access mySQL database across Internet

2006-08-15 Thread Neil Tompkins
The connection time to my mySQL database is OK from the ASP page. Are there any ways to speed this up though ? > From: [EMAIL PROTECTED]> To: My.SQL " "@ashcomp.net> > Subject: RE: Access mySQL database across Internet> Date: Fri, 11 Aug 2006 > 12:20:19 -0400>

RE: Access mySQL database across Internet

2006-08-11 Thread bnewton
On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote > At the moment our mysql server hosted by an ISP, is updated every > second by a program running on our local Internet connection from > our own office network. We have seen no performance issues from our > websites hosted by the same ISP

Re: Access mySQL database across Internet

2006-08-11 Thread Dan Buettner
ges from another ISP ? > Date: Thu, 10 Aug 2006 16:09:29 -0500 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: Access mySQL database across Internet > CC: mysql@lists.mysql.com > > A good point to make here is that averages are

RE: Access mySQL database across Internet

2006-08-11 Thread Neil Tompkins
remote update, would we see a problem if we queried the mysql database from webpages from another ISP ? > Date: Thu, 10 Aug 2006 16:09:29 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com>

Re: Access mySQL database across Internet

2006-08-10 Thread Dan Buettner
t; Date: Thu, 10 Aug 2006 13:05:11 -0500> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: mysql@lists.mysql.com> > Neil, in theory, this should work fine, given sufficient bandwidth> between the two sites.> > In practice,

Re: Access mySQL database across Internet

2006-08-10 Thread Dan Buettner
o 1000 hits / minute, then you're talking high traffic! Dan On 8/10/06, Neil Tompkins <[EMAIL PROTECTED]> wrote: What would you assume to be high traffic ? 1000 hits per day or more ? > Date: Thu, 10 Aug 2006 13:05:11 -0500> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]>

RE: Access mySQL database across Internet

2006-08-10 Thread Neil Tompkins
What would you assume to be high traffic ? 1000 hits per day or more ? > Date: Thu, 10 Aug 2006 13:05:11 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > Neil, in theory, t

Re: Access mySQL database across Internet

2006-08-10 Thread Dan Buettner
Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to b

Access mySQL database across Internet

2006-08-10 Thread Neil Tompkins
Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access t

Re: Unable to access mysql database with root user after upgrade?

2005-11-13 Thread Murray @ PlanetThoughtful
Murray @ PlanetThoughtful wrote: [EMAIL PROTECTED] wrote: Hi Shawn, Sorry, I'm talking about "root" the MySQL user account. The account exists -- I can perform the following, for example: c:>mysql --user=root ptnew -p Once I supply the password, this will put me in to the ptnew database,

Re: Unable to access mysql database with root user after upgrade?

2005-11-12 Thread Murray @ PlanetThoughtful
[EMAIL PROTECTED] wrote: "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> wrote on 11/11/2005 08:44:37 PM: Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the

Re: Unable to access mysql database with root user after upgrade?

2005-11-12 Thread SGreen
"Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> wrote on 11/11/2005 08:44:37 PM: > Hi All, > > I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. > > For some reason my root login can't access the mysql database anymore, > though I can use it to access the databases I have de

Unable to access mysql database with root user after upgrade?

2005-11-11 Thread Murray @ PlanetThoughtful
Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the databases I have defined. In effect, it seems as though I have no real root (or administrator level, if that's

Re: JVM unable to access MySQL intermittently?

2004-03-22 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric B. wrote: > Hi, > > I'm running into a strange problem with my JVM and MySQL. I'm using > Macromedia JRun 4 as my JVM and everytime I restart the Jrun service, my > application runs smoothly. However, after an indeterminate amount of time > (se

JVM unable to access MySQL intermittently?

2004-03-19 Thread Eric B.
Hi, I'm running into a strange problem with my JVM and MySQL. I'm using Macromedia JRun 4 as my JVM and everytime I restart the Jrun service, my application runs smoothly. However, after an indeterminate amount of time (seemingly random - sometimes a couple of hours, sometimes 12-15 hours), my s

Re: Can't access mysql after kernel upgrade

2004-03-19 Thread Sasha Pachev
James Packham wrote: Hi all. I've just upgraded the kernel on my server from v. 2.4.21 to 2.4.25 (The original had some problems), but now I can't access my database :( If I revert back to the old kernel then MySQL works fine again. Here's some errors and stuff: # /etc/init.d/mysqld status mysq

Can't access mysql after kernel upgrade

2004-03-19 Thread James Packham
Hi all. I've just upgraded the kernel on my server from v. 2.4.21 to 2.4.25 (The original had some problems), but now I can't access my database :( If I revert back to the old kernel then MySQL works fine again. Here's some errors and stuff: # /etc/init.d/mysqld status mysqld (pid 1153 1124) is

Re: unable to access mysql as anyone besideslinux user= root

2004-01-26 Thread gerald_clark
smrtalec wrote: whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=

unable to access mysql as anyone besideslinux user= root

2004-01-25 Thread smrtalec
whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql -

Lotus Notes/Domino Access MySQL DB

2003-10-09 Thread Randy Chrismon
I've been searching the Lotus site and have gotten kind of lost. Does anybody have any experience using Lotus Notes as a front end to a MySQL database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I barking up the wrong tree? Thanks. Randy -- MySQL General Mailing List For list arch

I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes f

2003-10-08 Thread Kenneth Illingsworth
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes from within an application script. They are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted th

Re: It is secure to access MySQL thru internet?

2003-08-29 Thread Hans van Harten
Flavio Tobias wrote: >>> I need to access a database thru internet. It is secure to do this >>> using MySql? >> Sure. If you use a secured connection. > What do you mean with secure connection, ssh? > How to configure this on MySql? I'ld think about SSL http://www.mysql.com/doc/en/Secure_ba

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread Dathan Vance Pattishall
X509 concepts. People who are already familiar with them can skip this part. -->-Original Message- -->From: Cal Evans [mailto:[EMAIL PROTECTED] -->Sent: Friday, August 29, 2003 1:39 PM -->To: Flavio Tobias -->Cc: [EMAIL PROTECTED] -->Subject: Re: It is secure to access MySQL t

Re: It is secure to access MySQL thru internet?

2003-08-29 Thread colbey
We use a point to point VPN between server sites for this... so the security/encryption is totally transparent to mysql, it's just connecting to an IP address on tcp/3306 and the vpn appliances down the line deal with all the data security... There are cheaper solutions such as using freeswan, s

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote: > I need to access a database thru internet. It is secure to do this using > MySql? > If the database traffic is encrypted, yes. I do not know if that is an option in Mysql. If you did not

Re: It is secure to access MySQL thru internet?

2003-08-29 Thread Cal Evans
As stated before, it is possible via ssh. This assumes 2 things: 1: Your client machine is windows 2: Your server is running a ssh server. (Which USUALLY means it's a flavor of Unix but there are ssh servers for windows...why, I don't know but there are.) First, grab putty. Putty is a ssh client

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread Greg.Hering
PROTECTED] > Subject: RE: It is secure to access MySQL thru internet? > > > I think your thinking of SSL. > > There is some work for mySQL that allows a sol connection and > even some work to sol the replication over the net. > > Look for SSL on mysql.com >

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread Dathan Vance Pattishall
12:59 PM -->To: 'Flavio Tobias'; [EMAIL PROTECTED] -->Subject: RE: It is secure to access MySQL thru internet? --> -->Flavio, --> -->Sure. If you wanted to MySQL into a DB over the internet. I'd think -->ssh'ing -->would do the trick. This actually has nothing

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread Fortuno, Adam
; Sent: Friday, August 29, 2003 2:17 PM Subject: RE: It is secure to access MySQL thru internet? > Sure. If you use a secured connection. > > A$ > > -Original Message- > From: Flavio Tobias [mailto:[EMAIL PROTECTED] > Sent: Friday, August 29, 2003 1:11 PM > To: [EM

Re: It is secure to access MySQL thru internet?

2003-08-29 Thread Flavio Tobias
What do you mean with secure connection, ssh? How to configure this on MySql? - Original Message - From: "Fortuno, Adam" <[EMAIL PROTECTED]> To: "'Flavio Tobias'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 2:17 P

RE: It is secure to access MySQL thru internet?

2003-08-29 Thread Fortuno, Adam
Sure. If you use a secured connection. A$ -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:11 PM To: [EMAIL PROTECTED] Subject: It is secure to access MySQL thru internet? I need to access a database thru internet. It is secure to do this

It is secure to access MySQL thru internet?

2003-08-29 Thread Flavio Tobias
I need to access a database thru internet. It is secure to do this using MySql? Thanks Flavio Tobias

Re: cannot access mysql and see privileges

2003-01-29 Thread Doug Thompson
You need to include the (correct) Root password in mysql_connect(h,u,p) On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote: >Warning: Access denied for user: 'root@localhost' (Using password: NO) >in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 > >Warning: MySQL Connection Failed: Access denie

Re: cannot access mysql and see privileges

2003-01-29 Thread R. Hannes Niedner
On 1/28/03 3:42 PM, "Jon Miller" <[EMAIL PROTECTED]> wrote: > Warning: Access denied for user: 'root@localhost' (Using password: NO) > in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 > > Warning: MySQL Connection Failed: Access denied for user: > 'root@localhost' (Using password: NO) in > /v

cannot access mysql and see privileges

2003-01-29 Thread Jon Miller
Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Acces

Cannot access MySql after OS upgrade

2003-01-24 Thread Chamlee, Douglas, B. (Contractor)
I had to upgrade my SGI server to operating system IRIX 6.5.18m from 6.5.15m after the upgrade I can access MySql from the command line but I cannot make an ODBC connection and my web pages using mysql do not work. Other than the OS upgrade no other changes were made. I have tried reinstalling the

RE: RE: Problem to access MySQL via MySQLFront

2003-01-13 Thread David Brodbeck
> Stupid filter fodder: sql,query,queries,smallint > > -Original Message- > > From: Dean Householder [mailto:[EMAIL PROTECTED]] > > > The problem is with the new glibc-2.2.5-40 package released > > on October 3, > > 2002. Apparently its a known issue, and people are aware of > > it. T

Re: Problem to access MySQL via MySQLFront

2003-01-13 Thread Dean Householder
ot;David Rayroud" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 7:14 AM Subject: Problem to access MySQL via MySQLFront > Hi, > > Here is my configuration : > Linux SME Server 5.6 bêta 7 > Mysql 3.23.49 > > I try to access to Mys

Re: OS X 10.2.2 Can not access mysql with the terminal

2002-12-19 Thread Chris Garaffa
On Sunday, December 15, 2002, at 03:43 PM, Helmuth Lutz wrote: First, from where did you install MySQL? Are you using OS X Server? If so, MySQL came installed with your system and you shouldn't have a problem with it. So I'm assuming you're using the client. Does anybody have an idea: - WHY do

Problem to access MySQL via MySQLFront

2002-12-17 Thread David Rayroud
Hi, Here is my configuration : Linux SME Server 5.6 bêta 7 Mysql 3.23.49 I try to access to Mysql via a client programm nammed MysqlFront. I have defined an user like this : Username : "blank" Host : .domain_name.ch Password : "blank" When I try to conn

Re: OS X 10.2.2 Can not access mysql with the terminal

2002-12-15 Thread Paul DuBois
At 21:43 +0100 12/15/02, Helmuth Lutz wrote: Does anybody have an idea: - WHY does my currently installed MySQL 3.23.46 start at System-Start? Becasue something or someone installed the proper startup stuff under System/Library/StartupItems. - WHY do the currently installed db's work within I

OS X 10.2.2 Can not access mysql with the terminal

2002-12-15 Thread Helmuth Lutz
Does anybody have an idea: - WHY does my currently installed MySQL 3.23.46 start at System-Start? - WHY do the currently installed db's work within Internet-Explorer? - WHY does the terminal not know the commands: mysql or mysqladmin? Not as user neither as root The terminal response: [hlut

Re: access->mysql

2002-12-14 Thread Grant Cooper
EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 5:06 AM Subject: RE: access->mysql thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subje

RE: access->mysql

2002-12-05 Thread Sandeep Murphy
thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access->mysql DBTools works great on this matter. You find it at h

Re: access->mysql

2002-12-05 Thread Crercio O. Silva
DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: "Sandeep Murphy" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 12:3

Re: access->mysql

2002-12-05 Thread Carlin Anderson
2sql.htm > > -Original Message- > From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 9:39 AM > To: MySQL List > Subject: access->mysql > > Hi, > > Can anyone please suggest a simple and effective method for converting a > hug

RE: access->mysql

2002-12-05 Thread Chris Couture
I have used Access to MySQL pro and it worked for a few of my databases. http://www.convert-in.com/acc2sqlp.htm Chris -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:39 AM To: MySQL List Subject: access->mysql Hi, Can any

Re: access->mysql

2002-12-04 Thread Steve Yates
On Wed, 4 Dec 2002 14:39:01 -, Sandeep Murphy wrote: >method for converting a huge database i hv in Access xp to MySQL ?? > I just wrote a short program in Delphi (using MyODBC) to pull information from an Access MDB and update a MySQL table. Worked fine. I'm sure one could accompli

RE: access->mysql

2002-12-04 Thread Ian Zabel
st Subject: access->mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a

RE: access->mysql

2002-12-04 Thread David Brodbeck
I used MySQLFront. It wasn't entirely automatic, but it did a reasonable job. There are some gotchas. Take your time, and be sure to read the notes for using Access and MyODBC with MySQL, if that's how you're going to do it -- some column types are not recommended. You'll want to add a TIMEST

RE: access->mysql

2002-12-04 Thread Steve Bradwell
hem how to program, you will frustrate them for a lifetime." -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access->mysql Hi, Can anyone please suggest a simple and effective method for converting

access->mysql

2002-12-04 Thread Sandeep Murphy
Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tri

Re: access MySQL server from remote windows m/c

2002-10-27 Thread Iikka Meriläinen
On Mon, 28 Oct 2002, aman mysql wrote: > Hi all > How do I access a remote MySQL server (on LINUX platform), from a windows > application. > What drivers I need to download and from where? Hi! You don't need any special drivers. Just the MySQL command-line client will do the job. It can be downl

access MySQL server from remote windows m/c

2002-10-27 Thread aman mysql
Hi all How do I access a remote MySQL server (on LINUX platform), from a windows application. What drivers I need to download and from where? How do I set permissions on the mysql server to let be accessed by the remote windows machine. Thanks alot Aman

RE: Allowing a whole class C to access mysql server?

2002-08-27 Thread Adam Ryan
a new grant for every user? Adam -Original Message- From: Lucas Saud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 9:45 AM To: Adam Ryan Cc: [EMAIL PROTECTED] Subject: RE: Allowing a whole class C to access mysql server? Importance: High hi, > How can I get this to allo

RE: Allowing a whole class C to access mysql server?

2002-08-26 Thread Chris Tucker
r? Any user for the 192.168.1% class with a > correct passwd. > It seems I can't have a wildcard for the user statement below? > > > Thanks > > -Original Message- > From: Chris Tucker [mailto:[EMAIL PROTECTED]] > Sent: Sunday, August 25, 2002 6:58 PM &

RE: Allowing a whole class C to access mysql server?

2002-08-26 Thread Adam Ryan
EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 6:58 PM To: Adam Ryan Cc: [EMAIL PROTECTED] Subject: Re: Allowing a whole class C to access mysql server? GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' should do the trick: you just specify the IP you want to allow and the netmask

Re: Allowing a whole class C to access mysql server?

2002-08-25 Thread Chris Tucker
GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' should do the trick: you just specify the IP you want to allow and the netmask to apply to it after the /. You could also use: GRANT SELECT ON db.* TO user@'192.168.1.%' as documented in the manual (http://www.mysql.com/doc/en/GRANT.html).

Allowing a whole class C to access mysql server?

2002-08-25 Thread Adam Ryan
Hi, I am trying to have a whole class C access the mysql server on the network. The class C needs to access many different database names. So adding an entry for each Ip address wouldn't work. Does anyone know how I can go about this? Thanks, Adam ---

RE: How to access MySql using Perl. Help

2002-02-12 Thread Keith A. Calaman
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 4:11 AM To: Andy Cheng Cc: [EMAIL PROTECTED] Subject: Re: How to access MySql using Perl. Help > I am new to MySql. I have MySql installed in my Linux PC. How do I connect > t

RE: How to access MySql using Perl. Help

2002-02-12 Thread Todd Williamsen
3:11 AM To: Andy Cheng Cc: [EMAIL PROTECTED] Subject: Re: How to access MySql using Perl. Help > I am new to MySql. I have MySql installed in my Linux PC. How do I connect > to MySql using Perl script and assign the result of a query to an array? > Where could I find a sample code?

Re: How to access MySql using Perl. Help

2002-02-12 Thread lcalero
> I am new to MySql. I have MySql installed in my Linux PC. How do I connect > to MySql using Perl script and assign the result of a query to an array? > Where could I find a sample code? Thank you. man DBD::mysql Cheers. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who

How to access MySql using Perl. Help

2002-02-11 Thread Andy Cheng
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE dow

Re: How to access MySql using Perl. Help

2002-02-11 Thread admin
Hi. You have to install DBI::DBD module. Then in perl use Mysql; $dbh = Mysql->connect(undef,"database","username",'password'); $sql = "select blah from blah"; $sth = $dbh->query($sql); @arr = $sth->fetchrow; for example if the result is more than one line you have to loop it Ofcoz there is ot

Re: How to access MySql using Perl. Help

2002-02-07 Thread admin
Hi. You have to install DBI::DBD module. Then in perl use Mysql; $dbh = Mysql->connect(undef,"database","username",'password'); $sql = "select blah from blah"; $sth = $dbh->query($sql); @arr = $sth->fetchrow; for example if the result is more than one line you have to loop it Ofcoz there is ot

How to access MySql using Perl. Help

2002-02-07 Thread Andy Cheng
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE dow

RE: Access -> Mysql conversion

2002-01-21 Thread j.urban
Another option might be ursql (http://www.urbanresearch.com/ursql). This tool has the ability to generate MySQL-compatible CREATE TABLE scripts from a connected MS Access database. Once the basic CREATE TABLE scripts are generated, you can easily tweak the data types to your liking. In my exper

RE: Access -> Mysql conversion

2002-01-21 Thread Mike Grabski
www.winmysql.com/ i hope that helps at all. If you find anything useful, would you be able to pass the word along? Thanks. Mike -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:43 PM To: [EMAIL PROTECTED] Subject: Access -> Mysql convers

Access -> Mysql conversion

2002-01-21 Thread Joel Wickard
I'm looking for a program, standalone, or web-based, to convert a current access database to mysql. any hints? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Best Delphi VCL to Access MySql.

2001-12-27 Thread Fredrick Bartlett
Zeos Lib is an open source TDataset descendant... http://zeoslib.org/ dfag wrote: > Wich VCL is the best to access MySql > I used Interbase for long time and I think to switch to MySql ofr My Delphi > Ap

Re: Best Delphi VCL to Access MySql.

2001-12-27 Thread Richard
I have two favourites: http://www.scibit.com http://www.microolap.com/index.htm > Wich VCL is the best to access MySql > I used Interbase for long time and I think to switch to MySql ofr My > Delphi Application. Richard Czerwonka, Par

Best Delphi VCL to Access MySql.

2001-12-27 Thread dfag
Wich VCL is the best to access MySql I used Interbase for long time and I think to switch to MySql ofr My Delphi Application. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Using c-isam calls to access MySQL ISAM data files

2001-12-05 Thread Sergei Golubchik
Hi! On Dec 05, Tobias Crush wrote: > Hi All, > > We am currently investigating the possiblity of migrating a legacy app from > Informix C-ISAM files to MySQL. To do this we are looking to be able to > retain the core application code as unchanged as possible. > > What we want to do is be able

Using c-isam calls to access MySQL ISAM data files

2001-12-04 Thread Tobias Crush
Hi All, We am currently investigating the possiblity of migrating a legacy app from Informix C-ISAM files to MySQL. To do this we are looking to be able to retain the core application code as unchanged as possible. What we want to do is be able to develop a new front end that accesses the data

Re: How to Access MySql Database?

2001-11-16 Thread Robert Alexander
Did you *start* mysqld? :> Sounds to me like mysqld hasn't been launched. Check to make sure the server software is actually running. HTH /Rob >Hi: > >I telnet to the server. But I can not get into MySql >database. What's the problem? > > >% mysql >ERROR 2002: Can't connect to local MySQ

RE: How to Access MySql Database?

2001-11-15 Thread Todd Williamsen
: Thursday, November 15, 2001 10:14 PM To: [EMAIL PROTECTED] Subject: How to Access MySql Database? Hi: I telnet to the server. But I can not get into MySql database. What's the problem? % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/

How to Access MySql Database?

2001-11-15 Thread Georgina Fang
Hi: I telnet to the server. But I can not get into MySql database. What's the problem? % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) % mysql -p linksdb Enter password: Then I type in password, and got the following: ERROR 2002: C

RE: Can't access MySQL via PHP

2001-11-03 Thread Peter Lovatt
> Sent: 03 November 2000 19:49 > To: [EMAIL PROTECTED] > Subject: Can't access MySQL via PHP > > > Hi all, > > I have a MySQL database 'mydb' and I can perfectly access it via telnet. I > have one database and I have full access to it. I can't create

Can't access MySQL via PHP

2001-11-03 Thread Imran Aziz
Hi all, I have a MySQL database 'mydb' and I can perfectly access it via telnet. I have one database and I have full access to it. I can't create user and other databases, but its fine. Problem is that I write a PHP script and I can't access my sql database using that script! I got 'Access Denie

Re: Cannot Access mysql database

2001-10-31 Thread Tshering Norbu
-p'newpassword' Of course, the paths in the above depends on your installation. I am on Linux 7.1 + Apache. NOBBY - Original Message - From: "PHP Nut" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 10:33 AM Subject: Cannot Acc

Cannot Access mysql database

2001-10-31 Thread PHP Nut
Ok here is the short version of the problem. Installed mySQL database on Cobalt server RAQ4 using Linux. Everything worked great. Now the mysql database that is created by default with user table etc...is empty!!! (Due to a user going in using PHPmyAdmin and changing the user and password with

Request for information (MS Access -> MySQL)

2001-10-26 Thread Rob Vonsee
Dear developer, For some years now, we developed a database application in MicroSoft's Access '97. With our user base growing, we're encountering more and more limitations in the Microsoft development environment, especially in the stability and number of simultaneous sessions of the database.

Re: Request for information (MS Access & MySQL)

2001-10-25 Thread j.urban
You can also use a tool like urSQL (http://www.urbanresearch.com/ursql) to convert the table schemas. urSQL has the ability to save MySQL tables as MS Access CREATE TABLE scripts and the ability to build a script of insert statements that can be run against the new table. (You can also save MS A

RE: Request for information (MS Access & MySQL)

2001-10-25 Thread Woolsey, Fred
:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:22 AM To: Rob Vonsee Cc: [EMAIL PROTECTED] Subject: Re: Request for information (MS Access & MySQL) Rob Vonsee wrote: > Dear developer, > > In the past several years, we have developed a database application in > MicroSoft's A

Re: Request for information (MS Access & MySQL)

2001-10-25 Thread Bill Adams
Rob Vonsee wrote: > Dear developer, > > In the past several years, we have developed a database application in > MicroSoft's Access '97. > With our user base growing, we're encountering more and more limitations in > the Microsoft development environment, especially in the stability and > number

Re: Request for information (MS Access & MySQL)

2001-10-25 Thread Daniel Andrade
Rob, You may start by checking the utility at download.com that claims to be able to convert Access to MySQL databases. I am currently trying to get a company off of Access 2000 and onto MySQL in America, but I have not tried this tool yet and any reviews from someone that knows Access well are w

Request for information (MS Access & MySQL)

2001-10-25 Thread Rob Vonsee
Dear developer, In the past several years, we have developed a database application in MicroSoft's Access '97. With our user base growing, we're encountering more and more limitations in the Microsoft development environment, especially in the stability and number of simultaneous sessions of t

Re: Where are the best Access --> Mysql FAQs

2001-10-19 Thread Ken Menzel
and this: http://netgraft.com/~mbac/research/mysqlmyths.html Have a great weekend, Ken - Original Message - From: "howard gramer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 4:29 PM Subject: Where are the best Access --> Mysql FAQs

Where are the best Access --> Mysql FAQs

2001-10-19 Thread howard gramer
Brand new Newbie here! My first post of any meaning! Considering the futile exercise of building an Access frontend to MySql. Where are the best FAQs, Books, Websites? Thanks howard gramer Home of NYPD and FDNY Environment..: Telecommunications at the circuit level.

Re: load access-mysql

2001-09-03 Thread legal
avies" cc: Subject: load access-mysql 09/0

load access-mysql

2001-09-03 Thread Neil Davies
I have a very large database which was made using Access2000. Because of the difficulty Access has in manipulating the database due to its scale I want to move the database to MySQL. However, because of the size of the database I don't want to spend hours doing it by hand so I want to use LOAD

  1   2   >