That's great to hear.
What I needed was to be able to access the database from only my pc.
Hence the IP address but I later tried the '%' and this also worked.
Thanks for the tip on restarting. I was doing the /etc/init.d/mysql stop
and start :-(
Thanks
Tim
-Original Message-
From: Kev
Hi
I have been facing this problem since from many months.
The problem is that when i try to connect mysql from the remote place using
mysqld -h 192.168.1.1 -u temp -p
it ends up with the error ERROR 2013: Lost connection to MySQL server during
query
As in the list i have tried increasing the MAX
well, i did agree if for myself,
it will be just simple as right click and choose "shutdown this tool".
but now i want to use the program to shutdown the tool automatically.
the reason why have to do that is during uninstallation
for my system, so that when the user run again my setup program,
whic
Hello,
Hope this makes sense, I am totally new with using MySQL.
How would I create a unique ID number for a table, for, say, a field named
UserID for example?
Thanks
Yves
-
Before posting, please check:
http://www.mysql.com
Pada Fri, 8 Nov 2002 11:16:16 +0800
"Alice Tan" <[EMAIL PROTECTED]> menulis:
> Hi, i got the stop mysqladmin service done.
> but this time is how to shutdown the mysqladmin service ?
>
> this is due to when ppl remove my system,
> and thinking of reinstall again,
> in my system should shutdo
Hi, i got the stop mysqladmin service done.
but this time is how to shutdown the mysqladmin service ?
this is due to when ppl remove my system,
and thinking of reinstall again,
in my system should shutdown the service which already stop,
then launch again the mysqladmin.
> - Original M
Ok, I tried using the QUOTE() function exactly how they have it on the string page in
the online manual. Needless to say, this has not worked at all...I get an sql syntax
error every time. If anyone else has had this problem or knows how to write a sql
statement using a different function that
Thanks for your help - problem now resolved.
The issue was I was creating the userId field with auto_increment and
setting it as the primary key in the UNION table definition - but had
failed to make the same settings in the table which I was making a UNION
from. I.E check very carefully when
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
> -Original Message-
> From: Doug Coning [mailto:lists@;coning.com]
> Sent: Friday, 8 November 2002 14:35
> To: [EMAIL PROTECTED]
> Subject: Copy Records in a table...
>
>
> Hi eve
Pada Thu, 7 Nov 2002 21:35:00 -0600
"Doug Coning" <[EMAIL PROTECTED]> menulis:
> Hi everyone,
>
> I'm still learning MySQL. I have a database of 600 items. I am still
> adding products. Several of these products are identical in nature, but
> have maybe one or two columns that are different.
Pada Thu, 7 Nov 2002 12:10:21 -0500
[EMAIL PROTECTED] menulis:
> Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
> Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
>
> I am trying to connect to my Mysql DB via Apache and PHP, but I get the
> following error: "Warning: U
Pada Wed, 6 Nov 2002 15:44:58 +
<[EMAIL PROTECTED]> menulis:
> Can't connect to local MySQL server through socket '/tmp/mysql.sock'
> (61) any suggestions on this
>
check your mysqld process, is it running or not ? ps a
Hi everyone,
I'm still learning MySQL. I have a database of 600 items. I am still
adding products. Several of these products are identical in nature, but
have maybe one or two columns that are different. Is there a way to write a
SQL command that selects these items and then inserts them, and
Pada Fri, 8 Nov 2002 02:20:56 -
"Jocelyn Fournier" <[EMAIL PROTECTED]> menulis:
> Hi,
>
> In fact, it's :
>
> joce@forum:~$ perror 124
> Error code 124: Wrong medium type
> 124 = Wrong index given to function
>
> but the solution to resolve the problem remains the same ;)
ups ... sorry ..
What is the handler for Collaborate ?? (What does "show create table
Collaborate" display ?)
- Original Message -
From: "David Herring" <[EMAIL PROTECTED]>
To: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 2:29 AM
Subj
Pada Fri, 08 Nov 2002 02:29:49 +
David Herring <[EMAIL PROTECTED]> menulis:
>
>
> Dicky,
>
> Thank you for the quick response - but it appears tables created as
> unions do not support these repair commands:-
>
> # bin/mysqlcheck -r -p test Collaborate
> Enter password:
> test.Collaborat
Dicky,
Thank you for the quick response - but it appears tables created as
unions do not support these repair commands:-
# bin/mysqlcheck -r -p test Collaborate
Enter password:
test.Collaborate
error: The handler for the table doesn't support check/repair
# mysql -uroot test
Welcome to t
Hi,
In fact, it's :
joce@forum:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
but the solution to resolve the problem remains the same ;)
Regards,
Jocelyn
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Pada Fri, 08 Nov 2002 01:59:20 +
David Herring <[EMAIL PROTECTED]> menulis:
> What does "ERROR 1030: Got error 124 from table handler" mean when
> trying to select a single value from a table created as a UNIOn of
> another table ?
root@slimmer:~# perror 127
Error code 127: Unknown error
Hi,
What does "ERROR 1030: Got error 124 from table handler" mean when
trying to select a single value from a table created as a UNIOn of
another table ?
When selecting just the primary key from a UNION table, with MySQL
3.23.53 I get the following error - however if I select the primary ke
I was reading through the docs and it says:
The following SELECT statements will not use indexes:
mysql> SELECT * FROM tbl_name WHERE key_col LIKE "%Patrick%";
mysql> SELECT * FROM tbl_name WHERE key_col LIKE other_col;
I am using MYSQL on windows. So is that true?
When I use the below stateme
hi,
> MySQL AB is pleased to announce that it has settled its lawsuit with
> Progress Software Corporation and NuSphere Corporation. For more
> information, see the joint press release at
>
> http://www.mysql.com/press/release_2002_14.html
Here's some background-info on the lawsuit:
http:/
I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have
mysql front loaded on a windows xp box which I am trying to use to
connect to the mysql server. The error I am getting when trying to make
a connection is 2013 - lost connection to MySQL server during query. I
have checked t
I think you can set a max quota for a table.
Insane
- Original Message -
From: "Henry Umansky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 21, 2002 8:08 PM
Subject: mysql quota
> I want to let users on my system use MySQL, but I want them to have some
> sort of quot
Hi all,
Sorry to jump in the middle of this thread but there is a much simpler
way to generate sequence numbers:
You create an auxiliary table with a one row:
CREATE TABLE sequence (
code int(11) DEFAULT '0' NOT NULL
);
INSERT INTO sequence VALUES (0);
And, each time you need a new sequence nu
Well, actually I always use the Unix date format because is easier to
use with PHP... and makes easier to do this kind of calculations... ;)
-Mensaje original-
De: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Enviado el: jueves, 07 de noviembre de 2002 15:20
Para: Michael T. Babcock
CC:
how is there a way to retain the user privileges in the mysql table when
dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these
individually , let me know thanks
-
Before posting, please check:
http://www.mysql.co
On Thu, 2002-11-07 at 16:17, [EMAIL PROTECTED] wrote:
> Hi,
>
> I have the following SQL query, that returns the correct records on Access,
> but when I use it with MySQL, it returns duplicate records, and it skips the
> required records.
>
> SearchSQL=select
> MarketData.CustID,Contacts.Conta
John, Michael, Andy and James,
Thanks for the informative responses. I was hoping I was on the right
track. Thanks for the query help, too. It looks like this is going to
work just fine.
Cheers,
Rik Forgo
JIST3
Army Test, Training and Technology Integration Office (T3I)
Diverse Technologies Co
Grigor, Peter wrote:
If you are using a version of MySql that has the query cache you can turn it
on and those queries will run very fast after the initial query. The query
cache is cleared whenever the underlying table(s) are modified so you'll get
the initial time hit again after modification..
I just installed onto a solaris 8 machine.
I've run mysql_install_db
The script says to change the root password by doing this:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h myhost password 'new-password'
When I do that I get ./bin/mysqladmin: No match.
Is pa
> I've got a query that selects the count of distinct rows in a table; the
> table has 453632 rows and 24 distinct class_id's.
>
> mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
> +---+
> | count(DISTINCT(sig_class_id)) |
> +--
Is this line correct?
MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE
Or should it be:
MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE
JFernando
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com]
Sen
there is a Profiler similar to SQL server Profiler ,only for windows
i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm
so sorry its not free :(
Amr Salah
--- "Iago Sineiro" <[EMAIL PROTECTED]> wrote:
>Hi Alexander.
>
>If you specify option log in section mysqld of
On Thu, Nov 07, 2002 at 12:32:58PM -0500, Michael T. Babcock wrote:
> I've got a query that selects the count of distinct rows in a table; the
> table has 453632 rows and 24 distinct class_id's.
>
> mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
> +---+
>
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote:
> Ok, we know that FreeBSD has problems with its thread implementation;
> however, I'd like to know if the MySql guys know exactly what causes the
> problems to which Mr Zawodny refers.
The problem is the MySQL (by default) uses name r
I sent this sometime ago and never got a response, so I will send it
again
I want to change my option to subscribe to this list as a digest, is the
following command below correct, or is this
list not setup has a digest?
subscribe mysql-digest EMAILADDRESS
END
--
Kory Wheatley
Academic Computin
Actually figured out one of my own:
FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM
UserDOB))/ 12) as Age
It's amazing what you can think of as soon as you ask the question.
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Thurs
Hi,
I have the following SQL query, that returns the correct records on Access,
but when I use it with MySQL, it returns duplicate records, and it skips the
required records.
SearchSQL=select
MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke
tData.Occupation,Marke
Hi everyone,
How do I select a group of records in a table and automatically duplicate
them into the same table while modifying 1 or 2 columns without having to
re-insert each record individually?
Thanks,
Doug
MySQL
-
B
Dan Nelson wrote:
Yes, with only 24 values, MySQL will probably never use that index for
paring down records in a regular SELECT. But for your count() case it
should.
According to the EXPLAIN output, it does; but its still horrifically slow.
mysql> explain SELECT count(DISTINCT(sig_class_id
John Meyer wrote:
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
There are several examples in the mailing list archives; but try
subtracting the UNIX_TIMESTAMP of each date (which is the time in
seconds) and then divide by the nu
I am a new customer and have a question about mysqldump recovery, but cannot
seem to be able to logon. My user name is probusine8359 and my support
contract is 2002-1428. Would you please correct this anomaly? I need to get
my questions answered. My phone number is 925.737.3458.
Thanks.
Ian Clark
At 11:14 -0800 11/7/02, Steven Webb wrote:
On that page, it says:
"You can't connect to the embedded server from an
outside process with sockets or TCP/IP."
... not the other way around, which is what I'm trying
to do. I'm trying to connect to another (remote)
server from the same app as is usi
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
In the last episode (Nov 07), Michael T. Babcock said:
> I've got a query that selects the count of distinct rows in a table;
> the table has 453632 rows and 24 distinct class_id's.
>
> mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
> | count(DISTINCT(sig_class_id)) |24 |
> 1 row
Hi Alexander.
If you specify option log in section mysqld of my.cnf configuration file you
get a log file of all queries
and sql operations (inserts, updates, deletes) executed in the MySQL server.
This log file is created by default at $DATADIR/$HOSTNAME.log.
Iago.
> -Mensaje original-
Using 4.0.2 for both server and client, replicating the following query
seems to have caused a crash on the client:
CREATE TEMPORARY TABLE tmp1 (
day DATE NOT NULL,
campaign_id INT NOT NULL,
clicks INT,
clicked FLOAT,
approved FLOAT,
users_raw INT,
users_coreg INT,
I would like to know if the MySQL has any command where I get the queries
requested by the application.
SQL Server has Profiler.
Oracle has any command that I don´t know
With Delphi I run SQLMonitor.
Regards
Alexander
sql,query
__
On that page, it says:
"You can't connect to the embedded server from an
outside process with sockets or TCP/IP."
... not the other way around, which is what I'm trying
to do. I'm trying to connect to another (remote)
server from the same app as is using an embedded
server. It doesn't say anyth
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002
UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer
of the world's most popular open source database, and NuSphere Corporation, an
independent operating company of Progress Software Corporation, tod
Can someone post the piece of News, for the folks that cant get into the
page (I dont have access to web from where I am now...) Thanks, Leo.
- Original Message -
From: "Christopher Hicks" <[EMAIL PROTECTED]>
To: "Michael Widenius" <[EMAIL PROTECTED]>
Cc: "Mysql List" <[EMAIL PROTECTED]>
Se
Hi.
I have some problems to retrieve the doubles I write in my tables.
I use MySQL server 4.0.3-beta-max.
I have not found the solution of my problem on the mailing-lis archive.
Following is the problem:
mysql> create table double_test (d double);
mysql> insert into double_test values(1.7976931
On Thu, 7 Nov 2002, Michael Widenius wrote:
> MySQL AB is pleased to announce that it has settled its lawsuit with
> Progress Software Corporation and NuSphere Corporation. For more
> information, see the joint press release at
>
> http://www.mysql.com/press/release_2002_14.html
The press rele
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: "Warning: Unknown MySQL Server Host '' (1) in
helloSql.php on line 3 Warning: MySQL C
Hi!
MySQL AB is pleased to announce that it has settled its lawsuit with
Progress Software Corporation and NuSphere Corporation. For more
information, see the joint press release at
http://www.mysql.com/press/release_2002_14.html
Regards,
Monty
--
__ ___ ___ __
/ |/ /_ __
Either you are not referencing the correct library for the database access
or you cannot doit from the Learning Edition.
HTH
JFernando
** sql ***
-Original Message-
From: Oliver Gottwald [mailto:goto1@;enteract.com]
Sent: November 6, 2002 22:26
To: [EMAIL PROTECTED]
Subject: ActiveX erro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 07 November 2002 17:46, ktran wrote:
> Configure command: ./configure
> --with-unix-socket-path=/var/tmp/mysql.sock
> --with-low-memory --with-mit-threads=yes
> --without-perl
> --enable-thread-safe-client --with-berkeley-db
> --enable-
Thank you, Egor! It looks like Red Hat released an update to its glibc
libraries yesterday which fix this, so if anybody else is having
problems, they should be able to fix it by updating. :)
Sage
On Thu, 2002-11-07 at 17:46, Egor Egorov wrote:
> Sage,
> Wednesday, November 06, 2002, 3:31:21 PM,
I've got a query that selects the count of distinct rows in a table; the
table has 453632 rows and 24 distinct class_id's.
mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
+---+
| count(DISTINCT(sig_class_id)) |
+---+
|
Make sure /etc/hosts has this line
127.0.0.1 localhost
~Kelly W. Black
-Original Message-
From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk]
Sent: Thursday, November 07, 2002 4:38 AM
To: 'Timothy Venn'; Mysql (E-mail)
Subject: RE: Host not allowed to connect problem
Hello Tim,
Are
John Coder wrote:
right, let me know so I can breath a sigh of relief. And if the
structure is right, could someone offer some guidance on how a query
that allows me to query new_req using the intersecting entity (or
three-way join, whatever it's called) would be written.
That looks right
At 11:41 + 11/7/02, Nikolas Galanis wrote:
Ok, here we are, in much detail. There is a table called
translations and another one called poems. Their structure is given
in the end. The query (given by a php script by the way) is:
select poems.poem_id, language, translation_title,made_by_id f
Philipp Steinkrueger wrote:
if you dont understand the language mysql is written in you
are probably not interested in "how" it works, technically. this
I've actually had any number of people ask me how to do things that they
think they can understand without knowing anything about programmi
[EMAIL PROTECTED] wrote:
This is what I want:
+--+--+
| ticketID | pipelineName |
+--+--+
| 163 | IT, Adv.Tech, R&D|
| 164 | IT, R&D |
| 165 | Video, Multimedia|
| ..
Nikolas Galanis wrote:
and with this I intend to retrieve the 10 latest additions of
translations. However, when running the script, I noticed that always,
on the top of the results was the translation link I had clicked last.
And this happens all the time. Now that I think of it again, the
c
My last post wasn't titled accurately. Sorry for the repost.
I have 3 tables. "Ticket" "Pipeline_Dept", and "Ticket_Matrix". Ticket_Matrix
matches tickets to pipeline depts. A ticket can be posted to multiple pipeline
depts. I want to select all tickets and the pipeline departments they are
pos
Description:
checking size of char...
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by
checking if you have libm.a
in /lib, /usr/lib or some other standard place. If
this is the problem,
install th
Ok, here we are, in much detail. There is a table called translations
and another one called poems. Their structure is given in the end. The
query (given by a php script by the way) is:
select poems.poem_id, language, translation_title,made_by_id from
poems,translations where poems.poem_id=tran
Brad.
Not sure if you got my last mail but did you try Omnis Studio from
www.omnis.net (trial download available).
It is available for MacOS Classic, OSX, Windows, Solaris and Linux. Never
used the Solaris/Linux versions but I do use the Mac and Windows versions
every day.
HTH
Kev.
> --
John,
You're making sense.
If you wanted to find all the systems used on project Test Bed Alpa, you'd
do something like this:
Select sys_name, s.id, project_name
FROM systems s, new_req n,ie_sys_req i
WHERE s.id = i.sys_id
AND n.id = i.proj_name_id
AND n.id = 344;
Hope this helps,
Andy
mysql q
i want to add a user to my system that has permissions to backup all the
databases using mysqlhotcopy. i don't want to use the root user. so what
permissions (minium set) should i give the user in order to accomplish this.
thanks in advance,
shon
--
That looks like a windows-only solution
John Ragan ([EMAIL PROTECTED]) wrote*:
>
>
>i've been hesitant to respond because i'm not
>sure that this is a head on solution for you, but
>take a look at http://corereader.com
>
>it's certainly easier to use than access queries.
>simple point and click
i've been hesitant to respond because i'm not
sure that this is a head on solution for you, but
take a look at http://corereader.com
it's certainly easier to use than access queries.
simple point and click to build complex output.
however, it's not designed for the fancy
formatted output t
Hi,
I have configured a master slave ring architecture. Can anyone suggest
me how to load test this architecture ?
I am using three MySQL servers in the following fashion :
A --> B --> C --> A
where A is the Master to B, B is the Master to C and C is the Master to A.
My aim is
aha! sure. you weren't being vague. you just
needed to educate me.
some of us have used intersecting entities
through the years, but didn't know that there was
a fancy name for what we were doing. if my
memory weren't so bad, i'd use it to impress
people in the next interview.
in this c
Hi,
if you dont understand the language mysql is written in you
are probably not interested in "how" it works, technically. this
perspective can only be explained by using terms from the
programming language. i guess you are interested in learning
more about the user-level, like how to set it up
Heikki Tuuri wrote:
log files are as important a part of a database as ibdata files.
Trust me, I know; they didn't get backed up I've realized too late
though ...
You can try using some dummy log files from another installation and set
force recovery to 6 to skip the log scan.
... what's
Has anyone else using Snort with CERT's ACID (Analysis Console for
Intrusion Databases) reporting software (PHP) done work on optimizing
their tables? I've found a few instances where TEXT was used instead of
VARCHAR unnecessarily and prevented indexes from being created, etc.
Any other tips?
Michael,
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 4:36 PM
Subject: Re: InnoDB recovery
> Heikki Tuuri wrote:
>
> >if you have on tape old images of ibdata files and
On Wed, 2002-11-06 at 23:25, Richard Forgo wrote:
> Sorry for being vague. I think the closest thing I can find to it is,
> possibly, a three-way join. I'm trying to figure out how to write the
> query.
>
> I've got the following tables:
>
> systems
>
> sys_name
Yes, that is what I meant. Thank you for the clarification and response.
Any ideas on maximizing *server* performance besides the usual db-specific
optimizations like indexing? If not too much trouble, could you give me a
brief explanation why I would not see a performance boost if running
separa
>-Original Message-
>From: Fernando Grijalba [mailto:fernando@;ggtours.on.ca]
>Sent: Wednesday, November 06, 2002 11:41 AM
>To: MySQL Help
>Subject: InnoDB row level locking?
>
>
>In the documentation it says that InnoDB supports row level
>locking. How
>can I ensure that rows are locked
I've done a specialized, high-volume FIFO queue implementation using MySql that
performs extremely well - if your concern is speed I think you'll likely do fine. Of
course, speed is relative to each solution - what kind of response time for
enqueue/deque operations do you require? In my situat
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and ib_logfile's, you can try
crash recovery from them, possibly using innodb_force_recovery=6.
Unfortunately, as mentionned, I only have the data files on tape, no log
files.
Are the data files 'dumpable' ??
SQL
--
Michae
Andrew,
Wednesday, November 06, 2002, 7:39:16 PM, you wrote:
AS> SELECT ... FROM table o WHERE o.date >= 2002090100 AND o.date<=2002110624
AS> MySQL 3.23.xx - work (returns >0 rows)
AS> MySQL 4.0.4 - not work (returns 0 rows)
AS> P.S. also in 4.0.4 not work BETWEEN in this case (but as
Michelle,
Wednesday, November 06, 2002, 4:25:32 PM, you wrote:
MdB> If I want to create a database with an arabic
MdB> character-set, will only the data-cells be affected by
MdB> this or will the table names, column names etc also be
MdB> in arabic?
You can use characters from current character s
>If the data contains "\", then database will automatically takes "\"
>away and shift 1 byte left.
>My data will mass up. That is why I still need "\"
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Esca
Hi Michael,
Thanks for your suggestion, but I didn't read C code, and I don't think so
someone in this list will:) Maybe short explanation from you also can:)
Regards,
Han Lin
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Unidux (S) - Han Lin" <[EMAIL PROTECTED
Brad wrote:
A programming environment;
Python comes to mind immediately; very easy to learn, especially
compared to VB, and its even Windows compatible (MFC even).
A database maintenance utility;
To what end?
A database query tool;
Visual query tools exist for MySQL already; someone
Ok, we know that FreeBSD has problems with its thread implementation;
however, I'd like to know if the MySql guys know exactly what causes the
problems to which Mr Zawodny refers.
I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before
which leads me to believe that either FreeB
Unidux (S) - Han Lin wrote:
I wanna know what the steps MySQL perform when we do INSERT in Database?
Anyone can explain? Or anyone here have some reference about how MySQL
works?
The source code is freely available from the website; download it and
take a read -- if you don't read C code, g
> systems
>
> sys_nameID
>
> Abrams 202
> Patriot 544
> Stinger 229
>
> ... and ...
>
> new_req
>
> proj_name ID
>
> Test Bed Alpha 3
> What I want to do is display to the user a list of files that
> require a
> security level that is less than or equal to the user's
> security level, with
> formatted last name and first name and date if the file is
> checked out.
>
> Checked out by is a foreign key refering to username in th
Hi all,
It now works
I did the following
Under the command line I did "insert into user (Host) values
('192.168.8.19')" and restarted mysql. I can now connect.
Thanks for the help.
Tim
-
Before posting, please check:
http
Hello Tim,
Are you getting this regardless of what you put in user,host and db tables.
If you are I am getting the same thing. Any access to my database is denied
except from the console.
How did you install - from the rpm's ??
I will watch this thread as I am at a complete standstill with MySQL
Sage,
Wednesday, November 06, 2002, 3:31:21 PM, you wrote:
S> I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel
S> (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0
S> gHz.
S> MySQL works perfectly fine when connecting from the localhost. However,
S> I have anot
Timothy,
Thursday, November 07, 2002, 11:42:13 AM, you wrote:
TV> I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do
TV> anything from the console command line but any connections from any
TV> other hosts causes a host "xxx.xxx.xxx.xxx" not allowed to connect to
TV> this mysql serv
Dan,
Thursday, November 07, 2002, 9:11:10 AM, you wrote:
DR> mysqldump: Got error: 1030: Got error 127 from table handler when retrieving
DR> data
DR> from server
DR> for some reason i get this when i dump all databases
DR> using mysqldump -p --all-databases --add-drop-table --quote-names >
DR>
Oluwagbamila,
Thursday, November 07, 2002, 10:04:10 AM, you wrote:
OO> No big deal. You can install MySQL in any directory or drive.
OO> You just have to set path of your installation in the mySQL conf file.
OO> Under MySQL Server Section -- Location, you point the directory to where the
OO> Db
1 - 100 of 110 matches
Mail list logo
