sorry, it's a test

sorry, it's a test database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

RE: recursive select

Ah recursion. Nothing like it to get your mind tied up in knots... :) Try this - untested, but this is the basic idea, and it or something like it should work. Call the function with the node you want to start from and the array you want the results to land in... Like so: ?

Re: longtext

Hi, my question is: is it possible to load in a Longtext column a .txt file? furthermore, is it possible to do that with a .xml file? of course.. at first you must use seperator, field-encloser and line-terminator, which is not contained in your data. for example this way: SELECT * FROM

Re: Data Directory

Ciao! I am new to both Linux and MySQL. I used the source to compile MySQL on Linux 7.0 with the default options. It's working fine. What's Linux 7.0? :-) But can i change the data directory where all the databases are stored to something other than the default, without having to compile

load-balancing with NFS

Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a

mysql and php3

Hi, Can somebody tell me why I cannot use php3 with mysql? I have just installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. PHP3 was already installed when I installed mysql. Does it have to be the other way round? that is php first and then mysql? I also configured

Error logs

Hi Is it possible to remove MySql's error log file without restarting the server. With other db's, ie Oracle, errors are just appended to the end of the log file. Is this the same with MySql, or does MySql permenantly hold the file open ? Thanx Simon -- Simon Windsor CricInfo

Re: Data Directory

Thanks a lot, But another problem. I did the changes in my.cnf and restarted mysql. It stops immediately, shows the following: Starting mysqld daemon with databases from /base1 010613 14:22:38 mysqld ended But when I changed the 'datadir' values in the my.cnf back to the default directory, it

Help me please

Hi, I want to insatll Mysql in my station, i have Debian (linux 2.2),i installaed all the package of mysql, and after when i Write command : mysqladmin -u user create db , It ansers, mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through

RE: re: startup Help

I take it you're running Windows? If so then PATH is an environment variable that allows you to run any command in its directories from anywhere. Example: c:\ path=c:\windows;c:\windows\command c:\ dir *.exe Volume in drive C has no label Volume Serial Number is 07D1-0502 Directory of

restore a backuped database

hello i need to export a database from a linux system to a nt-workstation so i've backuped the database with mysqldump and got this specific file. but what shall i do now with this file ? where do i have to copy it to on the nt-workstation, what are the commands to create the database

mysql and MyODBC

Hi, My setup MySQL version : Ver 8.8 Distrib 3.23.22-beta OS : RH 7.0 I downloaded MyODBC-2.50.37-1.i386.rpm from mysql's site but when I tried to install it, give this error: libmysqlclient.so.10 is needed by MyODBC-2.50.37-1 In /usr/lib/mysql I have the following entries

Re: startup help

On Tue, 12 Jun 2001, Neil Zanella wrote: On Tue, 12 Jun 2001, Martin Scherer wrote: I am told that mysqladmin is not an understood command. Looks like you need to update your PATH variable. Or one of the following: $ /var/lib/mysql/bin/mysqladmin $ cd /var/lib/mysql/bin $

Re: mysql and php3

On Wed, 13 Jun 2001, Saisab Pradhan wrote: Hi, Can somebody tell me why I cannot use php3 with mysql? I have just installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. PHP3 was already installed when I installed mysql. Does it have to be the other way round? that is

RE: recursive select

On 13-Jun-01 Alok K. Dhir wrote: Ah recursion. Nothing like it to get your mind tied up in knots... :) Try this - untested, but this is the basic idea, and it or something like it should work. Call the function with the node you want to start from and the array you want the results to

table locking and priorities

Hi All, Can anyone help me... My registration form looks up the last username in the members table (select distinct username from members order by uid desc limit 1), and increments this username (e.g. from abc2 abc3) which will be used as the username for the next user to sign up...

RE: mysql and php3

On 13-Jun-01 Saisab Pradhan wrote: Hi, Can somebody tell me why I cannot use php3 with mysql? I have just installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. PHP3 was already installed when I installed mysql. Does it have to be the other way round? that is php first

Re: table locking and priorities

No, I mean you can use an autoincrement field besides your username field. and use that to constructing user name, In this way you will be sure about uniqness and also you can maintain your user name as a text field although its some sort of redundancy. Regards Hi, The username field is

table corrupt - cant/wont recover! Help!!

One of my tables is corrupt and I tried all the usual ways to repair it but to no avail even when I restored the backup.. Tried this.. isamchk --recover --quick user_host isamchk --recover user_host isamchk --safe-recover user_host All that happened is the last 3 records were wiped out!

Re: GRANT annoyance...

Hello. Only a minor correction: On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote: [...] GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password' - the PRIVILEGES keyword is redundant. - database can be * for all databases. - table can be * for all tables

Re: compile problem on solaris , possibly others

Mark Vann writes: Well, i just did a pkginfo | grep zlib and this is what I got, application JGzlib zlib So it appears to be installed. Any ideas? Take a look at the end of config.log. Cut the code at the end and try to build it with a command immediately above. Then

Can't create table from another table

Hi Sorry for this question but this is my first shot at this list. I have created a table that contains the following: CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT NULL, projno INT(5) UNSIGNED ZEROFILL DEFAULT '1' NOT NULL, ritnummer INT(8) UNSIGNED

Re: mysql.sock not created

Hello. On Tue, Jun 12, 2001 at 08:39:59PM -0700, [EMAIL PROTECTED] wrote: Thanks for the reply Conducting a 'find' does not turn up the mysql.sock file anywhere on my server. Is there any reason why the installation would not create this file? That may sound like a stupid question, but

Re: Cannot install mysql from source distribution

[EMAIL PROTECTED] writes: Description: Unable to compile a binary for mysql-3.23.38. How-To-Repeat: Downloaded mysql-3.23.38.tar.gz. Used gunzip, then gtar to uncompress. No errors indicated. Used the command from the mysql instruction manual: CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3

Re: Error logs

Hi. On Wed, Jun 13, 2001 at 09:35:09AM +0100, [EMAIL PROTECTED] wrote: Is it possible to remove MySql's error log file without restarting the server. With other db's, ie Oracle, errors are just appended to the end of the log file. Is this the same with MySql, or does MySql permenantly

Re: Help me please

Hi. On Wed, Jun 13, 2001 at 11:12:02AM +0200, [EMAIL PROTECTED] wrote: [...] Hi, I want to insatll Mysql in my station, i have Debian (linux 2.2),i installaed all the package of mysql, and after when i Write command : mysqladmin -u user create db , It ansers, mysqladmin: connect to server

Re: What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?

David Ayliffe writes: As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6? I want to accept a table name at runtime, and then export both the data and data structure to a file which is compatible with MS Access; which the table will eventually be imported into. Are

New DBTools version (1.0.9) Available

I'm glad to let you all know that there is a new version of DBTools available. Go to our website http://dbtools.vila.bol.com.br to download it. What´s new: - Fixed bug when Importing from MSSQL Server using ODBC in tables that has IDENTITY (autoincrement) property - Added XML support to Dump

Re: restore a backuped database

Hi. On Wed, Jun 13, 2001 at 11:17:55AM +0200, [EMAIL PROTECTED] wrote: hello i need to export a database from a linux system to a nt-workstation so i've backuped the database with mysqldump and got this specific file. but what shall i do now with this file ? where do i have to

Password not accepted

I have the problem, that since a few weeks ago my mysql-server does not let me in anymore as root or admin. the connect via scripts on the internet(asp) works fine but i can't administer it anymore. so, what can i do that i can login again. i also tried to start the daemon with the option

Re: Data Directory

At 14.38 13/06/01 +0530, Suvarsha Walters wrote: Thanks a lot, But another problem. I did the changes in my.cnf and restarted mysql. It stops immediately, shows the following: Starting mysqld daemon with databases from /base1 010613 14:22:38 mysqld ended But when I changed the 'datadir'

Getting MySQL-3.23.35/up working on my box.

Hi all, I am a new subscriber of this list. I have a question that have confuse me for a long time. I am currently running MySQL-3.23.32 on Debian(woody) with kernel 2.4.x on a i386 box /w 1G Ram.. We are currently runing two different kind of database on the same server. One of them is a few

special select

Re: mysql and MyODBC

Hi. Sounds as if you have to install a newer MySQL package. Use rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0 to find out, which package contains the lib (for me, it is MySQL-shared-3.23.36-2mdk, which contains libmysqlclient.so.10.0.0) and install a more recent version (take it, for example,

New InnoDB release in MySQL/InnoDB-3.23.39

Hi! MySQL/InnoDB-3.23.39 binaries and source now available for Unix at http://www.mysql.com. Windows binaries will be released in a few days. InnoDB is a database backend which brings high-performance transactions and row level locking to MySQL. Main changes in InnoDB: * CHECK TABLE now works

GRANT ANNOYANCE REVISITED

Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql GRANT ALL PRIVILEGES ON *.* TO monty@% -IDENTIFIED BY 'some_pass' WITH GRANT OPTION; ERROR 1047: Unknown command

howto insert a variable in a query in C?

hi all, im currently using a C program to access my mysql database. but i have a small question. How do i insert a variable into a query? imagine: *query=select blah,blah from table_name where name = variable; im a bit in the dark on this one and would appriciate any/all suggestions. regards

Error locating host.frm

I've installed the Solaris 2.7 binary and am trying to connect to the database after doing the setup, when I attempt to start the database I get a message that mysql ended and there is no process started. I use the following (all things should be run with sudo on our server) - sudo

Re: how to install mysql replication ?

On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote: Make sure you have also read chapter 4.16, most importantly 4.16.5. it has some important information in it, too. Those chapters have nothing directly regarding replication. If you're to the point of worrying about

Problem adding new charset

Hi, I am trying to add new charset in my preinstalled mysql-3.23.26-beta. Manual says: Add the character set name to the CHARSETS_AVAILABLE and COMPILED_CHARSETS lists in configure.in. But I CAN NOT find COMPILED_CHARSETS list there. Please help me. Regards, Ivan Lulukyan

Re: Cannot install mysql from source distribution

Even if you have the zlib library, you may have to add the flag for it manually - it's not properly found by the configure routine as of 3.23.37, at least on Debian Linux 2.2. On Wed, Jun 13, 2001 at 03:11:42PM +0300, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: Unable

Re: Getting MySQL-3.23.35/up working on my box.

I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a

Re: mysql and php3

If PHP is compiled with its own MySQL support (as compared to using the MySQL shared libraries - which are not in every MySQL distribution) it expects mysql.sock to be in /tmp - whereas recent versions of MySQL put it in /var/lib/mysql/. PHP will find it if you add mysql.default_socket =

Newbie stumped by table error

Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book MySQL. I've entered the create table statement exactly as shown in the book (pg. 28 if you have the book) and I get an error message every time. This is very frustrating as I can't go any further with the

Re: Always problem

Hello. On Wed, Jun 13, 2001 at 05:01:21PM +0200, you wrote hi, when i do : find / -name mysqld.sock, it doesn't find nothing, i have read the article what u tell me, it wrote, for running server mysql, u put :mysql or mysqld.server i tried the both :when i put mysqld.server, the response

mysql GUI for windows NT/98 is it available?

I am just curious to know whether you have any GUI for mysql for Windows NT/98? If so kindly send me the link where I could download it. I am curios to work on MYSQL. thanks John _ Get your FREE download of MSN Explorer at

Re: GRANT ANNOYANCE REVISITED

At 10:16 AM -0500 6/13/01, David Simcik wrote: Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql GRANT ALL PRIVILEGES ON *.* TO monty@% -IDENTIFIED BY 'some_pass'

Daemon crashing (I'm going nuts here)

I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have

Re: how to install mysql replication ?

However, it is important to know about my.cnf and where to put it, IMHO! Quoting Whit Blauvelt [EMAIL PROTECTED]: On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote: Make sure you have also read chapter 4.16, most importantly 4.16.5. it has some important information

Re: GRANT ANNOYANCE REVISITED

Hello. On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote: Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql GRANT ALL PRIVILEGES ON *.* TO monty@% -

Re: Cannot install mysql from source distribution

How do you do this? --- Whit Blauvelt [EMAIL PROTECTED] wrote: Even if you have the zlib library, you may have to add the flag for it manually - it's not properly found by the configure routine as of 3.23.37, at least on Debian Linux 2.2. On Wed, Jun 13, 2001 at 03:11:42PM +0300, Sinisa

Re: howto insert a variable in a query in C?

Hi. This is not really a MySQL related question, but something about C basics, IMHO. On Wed, Jun 13, 2001 at 04:38:28PM +0200, [EMAIL PROTECTED] wrote: hi all, im currently using a C program to access my mysql database. but i have a small question. How do i insert a variable into a query?

RE: Newbie stumped by table error

Go through http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html This is a good starting point. Look this over and you will see your error ; Use a CREATE TABLE statement to specify the layout of your table: mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), -

Re: Newbie stumped by table error

on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wrote: Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book MySQL. I've entered the create table statement exactly as shown in the book (pg. 28 if you have the book) and I get an error message every time.

Re: my.cnf mystery

My point was that this is a configuration file, text, not a program. Still, there should be an appendix in the documentation that lists all of the options rather than have this hunt-and-seek approach. Quoting Paul DuBois [EMAIL PROTECTED]: At 8:15 PM -0400 6/12/01, William M. Quarles wrote:

Re: mysql GUI for windows NT/98 is it available?

http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html Tyler - Original Message - From: John Kennedy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 10:31 AM Subject: mysql GUI for windows NT/98 is it available? I am just curious to know whether you have

Re: special select ( try 2)

Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply,

Re: Multiple CPU's in Freebsd

Try this: update your ports, then build the mysql port with WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary linked against linuxthreads instead of libc_r, so it should use multiple processors. Matt Ken Menzel wrote: Hi Rafael, This is not an easy task, there are

Re: Newbie stumped by table error

Also, I don' think -00-00 is a valid Date. You might want to use something else as a default. - TIM Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book MySQL. I've entered the create table statement exactly as shown in the book (pg. 28 if you have

Re: Newbie stumped by table error

Did you try taking out one of the 'last_name' field definitions?? It looks like you have two there... - TIM Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book MySQL. I've entered the create table statement exactly as shown in the book (pg. 28 if you

RE: GRANT ANNOYANCE REVISITED

Nope, it says version 3.23.38. However, I should point out that I started the service (under NT) with the --skip-grant-tables option enabled. Was locked out of my database when I updated my password manually using a SQL Update on the User table, so I am trying to change that using the method

i need help completing install of newest version

so i'm trying to install mysql 3.23.38 on slackware linux, kernel 2.0.27 i'm installing from a tar.gz and have no previous mysql on this server. so i'm ok to scripts/mysql_install_db.sh then i get the following 3 lines scripts/mysql_install_db.sh: my_print_defaults: command not found didn't

Re: Error locating host.frm

Make sure that mysql owns its files and directories. Furmaniuk, Michael wrote: I've installed the Solaris 2.7 binary and am trying to connect to the database after doing the setup, when I attempt to start the database I get a message that mysql ended and there is no process started. I use

Re: Daemon crashing (I'm going nuts here)

Have you tried rebooting? I'm seeing the same problem with 3.23.38 (after stopping the server with mysqladmin and then trying to restart with safe_mysqld) but rebooting resets whatever it is that 3.23.38 is not properly clearing on the shutdown. Don't have this problem on another system running

mysql -h hostname error

Hi, when I try the following command, I got hostname is not allowed to connect to this mysql server. Any clue? Nancy - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Getting MySQL-3.23.35/up working on my box.

Upgrade to 3.23.39 first ( and make sure to use our binary). 3.23.35 has some critical bugs. -- MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/

Re: Daemon crashing (I'm going nuts here)

Walker, Brian wrote: I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start

Re: my.cnf mystery

At 08:30 PM 06/12/2001, Philip Mak wrote: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the socket one,for example, was one that I asked about last week, when the

Fwd: mysql -h hostname error

The command I used was: mysql[2]mysql -u root -h som-host-name ERROR 1130: Host 'some-host-name.bbn.com' is not allowed to connect to this MySQL serv er Date: Wed, 13 Jun 2001 14:18:46 -0400 To: [EMAIL PROTECTED] From: Nancy Yang [EMAIL PROTECTED] Subject: mysql -h hostname error Cc: Danny

Re: mysql GUI for windows NT/98 is it available?

Try urSQL from http://www.urbanresearch.com/ursql also see the MySQL website: http://www.mysql.com/downloads/gui-clients.html http://www.mysql.com/downloads/contrib.html#SEC592 On Wed, 13 Jun 2001, John Kennedy wrote: I am just curious to know whether you have any GUI for mysql for Windows

RE: special select ( try 2)

Is this French for This is a MIME format message in multiple parts? If so, Franky, try sending your message in plain text, please. Merci, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] -Original Message- From: franky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June

Re: MySQL compilation problems, Solaris 8

Ya know, why is solaris such a pain in the butt. I have issues, no one appears to be able so answer it. When i compile this on linux, it works great. WTF --- Josh Rivel [EMAIL PROTECTED] wrote: Hi. I am trying to compile MySQL-3.23.38 on Solaris 8 box. This is a Sun Netra T1 (1u rackmount,

THANKS! RE: GRANT ANNOYANCE REVISITED

Thanks to all of those who lent their advice. Seems that when you initialize MySQL using the --skip-grant-tables option enabled, it disallows the ability to use the GRANT command. I guess that makes perfect sense. I also forgot the use the PASSWORD() function when I used SQL to update my root

RE: load-balancing with NFS

Hi As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp

Can't install mysql-2.23.6 server , client on Redhat 6.2

Hi there, I'm trying to setup qmail with mysql database. How can i work the install process on Redhat 6.2 is there a specific package (rpm) that i can install quickly since i got a long way to go. regards, _ AVISO ! Le meilleur de

Re: Multiple CPU's in Freebsd

Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use DB_DIR=/usr/local/var you will get an error at the end of make install, but it's

Re: GRANT annoyance...

Hi. On Wed, Jun 13, 2001 at 02:55:07PM -0230, [EMAIL PROTECTED] wrote: On Wed, 13 Jun 2001, Benjamin Pflugmann wrote: On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote: [...] GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password' - the PRIVILEGES

Super-smack compile error

Hi All anyone ever get this? FreeBSD 4.3 OS, using default configure. $ gmake -s Making all in src client.cc:21: redefinition of `union semun' /usr/include/sys/sem.h:49: previous definition here client.cc: In method `void Client::setup_pipe()': client.cc:286: no matching function for call to

Re: Multiple CPU's in Freebsd

It went in Wed May 23 20:26:06 2001 UTC. http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/mysql323-server/Makefile.diff?r1=1.114r2=1.115 Matt Ken Menzel wrote: Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning

MySQL 3.23.39 released

Hi! This release fixes a couple of bugs in InnoDB tables and a couple of other minor bugs. If you are not using InnoDB tables, you probably don't need to upgrade. Changes in release 3.23.39 -- * If one dropped and added an `AUTO_INCREMENT' column, the

URGENTE

hey eu estou acessando um banco de dados do mysql via delphi usando o winzeos meu chefe pediu p/ instalar na máquina dele p/ ele ver como está (ainda nao terminei tudo) e eu nao consigo instalar pois ele da erro na hora de executar a query eu ja coloquei a libmysql.dll no pc e nada alguem

snort plug-in database: mysql question

Hi, I have installed mysql version 3.23.38 on solaris 2.7and then installed and configured the snore to have mysql as the plug-in database. I created a database 'snort' for snort and a user 'snort' that has privileges to INSERT and SELECT on that database. I then built the structure of the

error reading communication packets

I am getting the following error in my error log periodically, 010613 9:45:38 Aborted connection 1246 to db: 'databaset' user: 'user' host: `localhost' (Got an error reading communication packets) since upgrading from 3.22.32 to 3.23.36. The only application using the database is a

Re: mysql -h hostname error

In order for this to work you must have privileged access to the mysqld server on which you must be able to execute a GRANT statement to allow access from your host. If you do not have this privilege then you're out of luck. Connecting from other hosts then the server host is considered to be a

Re: mysql GUI for windows NT/98 is it available?

Some months ago I had the same question and I looked at many different Windows MySQL GUI clients. The best one I know of is Mascon. They have a free version for download. http://www.scibit.com/Products/Software/Utils/Mascon.asp -Philip Mak ([EMAIL PROTECTED])

Re: mySQLGUI Error

Hi, I am trying to use MySQL GUI client on W2K to connect to MySQL server running on RedRat Linux 7.1 and I am getting the following error Host '192.168.0.152' is not allowed to connect to this MySQL server. Do I need to change something on my Linux? Yes, you have to check your MySQL access

Re: mysql GUI for windows NT/98 is it available?

Hi, I am just curious to know whether you have any GUI for mysql for Windows NT/98? If so kindly send me the link where I could download it. I am curios to work on MYSQL. Look at http://www.mysql.com/downloads/index.html - you will find what you are searching ... Thomas Karcher

Re: my.cnf mystery

At 2:30 PM -0400 6/13/01, Dennis wrote: At 08:30 PM 06/12/2001, Philip Mak wrote: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the socket one,for example, was one

RE: recursive select

Good catch :) -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 6:44 AM To: Alok K. Dhir Cc: [EMAIL PROTECTED]; Chih-Lii Chen/Trans-EZ/TW Subject: RE: recursive select On 13-Jun-01 Alok K. Dhir wrote: Ah recursion. Nothing like

Re: Newbie stumped by table error

Tim, I noticed that too. I only repeated it when I typed it into the email message though, not my MySQL monitor. Thanks, Jeff From: Tim [EMAIL PROTECTED] Date: Wed, 13 Jun 2001 12:19:29 -0400 (EDT) To: Jeff Caron [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie stumped by

Re: Newbie stumped by table error

Tim, I took out the dashes as another person suggested and that made it work. I typed in -00-00 because that is what it says to enter in my MySQL book (by Michael Widenius). Thanks, Jeff From: Tim [EMAIL PROTECTED] Date: Wed, 13 Jun 2001 12:20:49 -0400 (EDT) To: Jeff Caron [EMAIL

one way encryption for a 16 digits string

Hi, I need a one way encryption for a 16 digits string. let's call $string the clear string, and e($string) the encypted string. I need e($string) to give always the same result for any $string, and I need e($string1) != e ($string2) for all ($string1,$string2), having $string1!= string2. Does

Pregunta

Hola. Hola. Soy estudiante de Sistemas y necesito ayuda por favor. En que sitio puedo encontrar un frontal gráfico de MySql para Linux, necesito generar mi base de datos y diseñar las tablas de un sistema. At. Anita C. Gracias

Question about order by rand()

I can't seem to find a specificatoin on order by rand() and have a question. Lets say a table has 10,000 rows in it, and I want to get one row that matches so I do a select * from table where number=1 order by rand() limit 1; What if 100 rows match? Does it first get all 100 rows and then

Re: Multiple CPU's in Freebsd

On Wed, Jun 13, 2001 at 03:19:30PM -0400, Ken Menzel wrote: Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use

RedHat 6.2 MySQL

I have the following install of mysql on RedHat 6.2: mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) The server was running for about two weeks until yesterday when the server just stopped accepting connections. I rebooted the entire machine and on startup of mysqld, the following

Re: Newbie stumped by table error

You'll see exactly that error if you type the default date -00-00 *without* the quotes. If you included the quotes, then something is quite odd indeed. This is such a basic statement in the book that you can be sure any error would have been reported by now. What version of MySQL are you

Re: one way encryption for a 16 digits string

On Wed, Jun 13, 2001 at 02:14:48PM -0700, samuel wrote: Hi, I need a one way encryption for a 16 digits string. let's call $string the clear string, and e($string) the encypted string. I need e($string) to give always the same result for any $string, and I need e($string1) != e ($string2)

Lost connection

Dear support. I own a webserver (not located @ home but with a virtual host) using php4 and mysql. Normally I do not have any trouble with the mysql but today I got some strange errors from mysql during a session of an IRC bot (made in php): 2013: Lost connection to MySQL server during query

Re: Question about order by rand()

On Wed, Jun 13, 2001 at 03:25:55PM -0600, Matt Heaton wrote: I can't seem to find a specificatoin on order by rand() and have a question. Lets say a table has 10,000 rows in it, and I want to get one row that matches so I do a select * from table where number=1 order by rand() limit 1;

  1   2   >