Did not see a reference to reloading tables in the docs.
This is just weird enough for me to vpn in and try again :-)
Thanks!
--
Steve (egrep)
On Fri, 7 Mar 2003, Ben Balbo wrote:
Hi Steve,
Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
Tried this... no go... The wierd part, is that localhost
works fine, but I cannot connect locally if I use the
hostname. Thanks for the help!
(maybe I should go back to an old version of mysql :-)
--
Steve (egrep)
On Fri, 7 Mar 2003, Ben Balbo wrote:
Hi Steve,
Really silly question, but you
Yep, tried that... but I will try it again...
--
Steve (egrep)
On Thu, 6 Mar 2003, Roger Davis wrote:
Or
mysql flush privileges;
Roger
-Original Message-
From: Ben Balbo [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:08 PM
To: MySQL List
Subject: Re: ERROR 1045:
On Thu, Mar 06, 2003 at 04:24:10PM -0800, Ask Bjoern Hansen wrote:
I am running RedHat 7.3, mostly using InnoDB's. I am using the
MySQL-Max rpms (4.0.11) from mysql.com.
Earlier today it crashed, and while trying to start up again it
crashed again. Now I can't start the server with the
When I try telnet localhost 3306 all seems ok. When I try
telnet domain.com 3306 I get the message Connection closed by foreign
host, same goes when trying the IP address from the local box. If I try
this as well from a remote box, I get Connection closed by foreign host.
I believe I have
Ask,
I think some other user encountered the error number 4 EINTR when his
harddisk was broken.
I do not know why in the later runs it did not print an error message.
Possibly the error number was EEXIST, for which InnoDB omits the error
printout and which is nonsensical if you are reading an
Mysql 4.0.11a gamma is crashing on Windows 2000 with service pack 3 with the
following error:
MySql: ready for connections
030203 17:39:10 InnoDB: Started
030305 9:32:50 InnoDB: Operating system error number 1450 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for
Dear Smith, Dave, Clark and Victoria:
Thanks for all of your reply as quick !
Because I am a neewbie on MYSQL, would you mind to teach me how to create a
user and data directory on mysql server ?
Below are the mysql directorys on my server, and I can't find the data
directory. (Does it must be
I've been working for some time with php and mysql. I've always been
curious, and am finally starting to play with C. I downloaded Paul
DuBois' sample Chapter 6: The MySQL C API.
I am running Mac OS X 10.2.4. I am running mysql version 3.23.54-max. I
followed the instructions in the sample
Apologies if you now get this three times now, but I haven't
received any copies through the mailing list yet, and the first 2 were
sent 3 and 4 hours ago.
I know email can go walkies for a few hours, but I've not been
experiencing any other mail problems, either personally or in
receiving MySQL
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
I've heard a lot of cases where upgrading a windows 98 machine to
windows 2000 will cause problems later on. This may be the case with
your system. The only thing I can say is try using that same downloaded
executable on a friend's machine and see if it works there. If not,
theproblem is with
On Thu, 6 Mar 2003, Jeremy Zawodny wrote:
I am running RedHat 7.3, mostly using InnoDB's. I am using the
MySQL-Max rpms (4.0.11) from mysql.com.
Earlier today it crashed, and while trying to start up again it
crashed again. Now I can't start the server with the InnoDB tables.
I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wednesday 05 March 2003 16:05, Johannes Ullrich wrote:
To reduce the size of you index file: try a 'repair table'. The 'alter
table' will take care of it too. You can also drop and recreate this index.
What's the limit for an index file?
At 11:07 +1100 3/7/03, Ben Balbo wrote:
Hi Steve,
Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
mysqladmin -p reload
B.
Yep, it's silly. :-) Because GRANT automatically refreshes the
in-memory copies of the grant tables.
Steve, try this:
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
Hello ,
We are writing some set of generic scripts to start / stop MySQL instances
on a particular Linux machine. We want to address the complexity of
configuring running multiple MySQL instances on the same machine. Can we
get the information about the parameters that we MUST take care for
Dear mysql ,
äÁâ¤Ã«Í¿·ì ( www.microsoft.com ) áÅÐ áÁç¤ÍÒ¿Õ( www.mcafee.com )
à¾Ô觾ºäÇÃÑʵÑÇãËÁè «Öè§ÊÒÁÒöÊÃéÒ§¤ÇÒÁàÊÕÂËÒÂÁÒ¡·ÕèÊØ´à·èÒ·ÕèÁÕÁÒ
áÁç¤ÍÒ¿Õà¾Ô觾ºäÇÃÑʵÑǹÕé
àÁ×èͺèÒ Çѹ·Õè 2¡ØÁÀҾѹ¸ì áÅÐÂѧäÁèÁÕÇѤ«Õ¹»éͧ¡Ñ¹ äÇÃÑʹÕé¨Ð·ÓÅÒÂ
૤àµÍÃì «ÕâÃè
The primary key (message_id)is a UNSIGNED BIGINT,
Which is supposed to be 64 bit, with autoincrement.
The each row is deleted as soon as it is fetched
By the client, and also after the expiry of a period
(~30 days).
64 bits does provide a large number, but there is a
possibility that it
Description:
How-To-Repeat:
mysql -ecreate table `FIELDS` (x int) test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Submitter-Id: submitter ID
Originator:Matthias Urlichs
Organization:
noris network AG, Nuernberg, Germany
MySQL support: licence
Synopsis:
Respondendo,
quinta-feira, 6 de março de 2003, 19:06:06, Mensagem Original:
RM I have a DB where all of the tables are InnoDB, and there are a few
RM straightforward FOREIGN KEY constraints. I would like to use mysqldump to
RM back up the data or move it to another machine.
RM The problem I'm
Respondendo,
sexta-feira, 7 de março de 2003, 03:02:24, Mensagem Original:
P Hello ,
P We are writing some set of generic scripts to start / stop MySQL instances
P on a particular Linux machine. We want to address the complexity of
P configuring running multiple MySQL instances on the same
HI,
I need to create a new user who can can run these two queries
1. SELECT ... INTO OUTFILE
2 LOAD DATA INFILE.
I create a user with this query, GRANT USAGE, SELECT, FILE ON
database.table to [EMAIL PROTECTED]
It gives error running this query...it says illegal Grant/comman check
the manual.
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is no mention of
this in the manual or books. I figured the username length was dynamically limited by
the length of the User field in the mysql.user table.
But i have
Yes you can.
Try this query
grant file on database.* to user@'.
also remember
grant file on database.table to user@'. does not work
Anis
Lakshminarayna U [EMAIL PROTECTED] Friday, March 07, 2003
5:00:30 PM
Hi,
I want to archive and restore a table in MySQL using SQL
Hi,
I want to archive and restore a table in MySQL using SQL
statements. I have tried this by logging in as root user and could
do it fine. But when I created a new user and login as him, I am
not able to archive nor restore. I have granted him all the
rights. Is there any specific rights
As you write your code in somewhat pseduo code format, I can't comment on the
exact syntax. You may use PERL-DBI-DBD:MySQL to implement your code. However,
it may some problems with your logic. First of all, if the quote_for_family
table already exist, the create table sql do nothing and it
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
On Thu, 6 Mar 2003, Fabian Schmidt wrote:
Am 05.03.03 schrieb Thomas Spahni:
Some words like Tetraeder have the combination 'ae' and should be found
looking for LIKE '%ae%'; surprisingly this works:
Queries with LIKE '%...' can't use the index and work correct.
Unfortunately this is no
On Friday 07 March 2003 08:02, Prashant wrote:
We are writing some set of generic scripts to start / stop MySQL instances
on a particular Linux machine. We want to address the complexity of
configuring running multiple MySQL instances on the same machine. Can we
get the information about the
On Friday 07 March 2003 13:30, Lakshminarayna U wrote:
I want to archive and restore a table in MySQL using SQL
statements. I have tried this by logging in as root user and could
do it fine. But when I created a new user and login as him, I am
not able to archive nor restore. I have granted
On Thursday 06 March 2003 18:07, Jonathan Li wrote:
For example I have three databases, db1, db2, db3.
I have used command mysql use db1; to select db1, then forsome silly
reason I forgot which db I am in. Is there a quick mysql command that
can show that you are in db1?
Use:
SELECT
On Friday 07 March 2003 14:08, Ahmed S K Anis wrote:
Yes you can.
Try this query
grant file on database.* to user@'.
It's wrong!
You can't specify FILE privilege on the database, only on the global level
(*.*).
--
For technical support contracts, goto
On Friday 07 March 2003 13:24, Ahmed S K Anis wrote:
I need to create a new user who can can run these two queries
1. SELECT ... INTO OUTFILE
2 LOAD DATA INFILE.
I create a user with this query, GRANT USAGE, SELECT, FILE ON
database.table to [EMAIL PROTECTED]
It gives error running this
On Friday 07 March 2003 00:43, Chris Montgomery wrote:
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Description:
HAVING in SELECT is evaluated before WHERE. This is not the
correct behaviour as HAVING should deal with the remainder of the WHERE
selection (according to manual)
How-To-Repeat:
mysql: create table tt (f1 int, f2 int);
Query OK, 0 rows affected (0.01 sec)
mysql: insert
Hye
I try to translate in MySQL language a problem which I mean is a UML
partition constraint.
I explain:
There is a table A binded with a table B.
This table B is itself binded according to a B.P parameter:
either to a table C
either to a table D
but never to both.
I think one solution should
On Thu, 2003-03-06 at 17:52, tommy liu wrote:
anyways, yes I did run
# ./configure --with-vio --with-openssl --prefix=/usr/local/mysql
and also tried the max version
I also ran mysql_fix_privilege_tables.sh (one along 3.23.46 source)because
we have MySQL 3.23.46 but I don't think it did
On Friday 07 March 2003 00:06, Rick Mann wrote:
I have a DB where all of the tables are InnoDB, and there are a few
straightforward FOREIGN KEY constraints. I would like to use mysqldump to
back up the data or move it to another machine.
The problem I'm running into is that when I try to
Hi Guys and Dolls
I am going to add another table to my lovely MySQL DB.
Basically it is the city table I need to add to. For each city I am going to
have Towns. So I need to relate many Towns to one CityID
The city table at the moment is:
City CityID
What the best way forward?
Andrew
This is correct.
WHERE clause returns (1,1)
HAVING eliminates all records not HAVING f2=3.
[EMAIL PROTECTED] wrote:
Description:
HAVING in SELECT is evaluated before WHERE. This is not the
correct behaviour as HAVING should deal with the remainder of the WHERE
selection (according to
* Andrew
I am going to add another table to my lovely MySQL DB.
Basically it is the city table I need to add to. For each city I
am going to
have Towns. So I need to relate many Towns to one CityID
The city table at the moment is:
City CityID
What the best way forward?
Create a
* gregory lefebvre
I try to translate in MySQL language a problem which I mean is a UML
partition constraint.
I explain:
There is a table A binded with a table B.
This table B is itself binded according to a B.P parameter:
either to a table C
either to a table D
but never to both.
Charlie H. schrieb:
When I try telnet localhost 3306 all seems ok. When I try
telnet domain.com 3306 I get the message Connection closed by foreign
host, same goes when trying the IP address from the local box. If I try
this as well from a remote box, I get Connection closed by foreign host.
I
Ben Balbo wrote:
Teacher (id, name, ...)
TeacherClass (teacherid, classid, timestamp)
Class (id, name, ...)
Now, what I'd really like to do it find all teachers who, for example,
taught Engligh and Math, but not Biology,
Here's a general, recursive, untested solution for you to play with.
We
Hi,
this is NOT correct behavior. Where clause returns (1,1) and (1,2). The HAVING
clause should be applied to what WHERE has selected and choose the (1,2)
record.
A quote from the manual It (HAVING) is applied last, just before items are
sent to the client, with no
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk
On Friday 07 Mar 2003 3:28 pm, Rick Jansen wrote:
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
What OS are you using?
'top' shows that mysqld
At 15:36 7-3-03 +, John Wards wrote:
What OS are you using?
Linux 2.4.20.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk caching. How do I know for sure that mysql is using the rest
of the memory, or how do I get mysql to use it all?
That seems
Hmmm I would say other than upgrading your hardware try upgrading to mySQL 4.
and turn on query caching.
The difference it has made to our server is unbelivable!
We have found no problems with it so far.
John
-
Before
Description:
UPDATE command fail with multiple myisam tables with error:
ERROR 1142: update command denied to user: '[EMAIL PROTECTED]' for table '***'
This situation occures only when non-root user make UPDATE and
'tables_priv' not empty (no matter what it
On Fri, 2003-03-07 at 10:54, [EMAIL PROTECTED] wrote:
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:
sql,query,queries,smallint
If you just reply to
Hello,
I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram.
I am only using InnoDB for databases (40gb) other than the mysql.*.
I have the following relevant memory settings:
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
## For redhat 8.0
set-variable
sql,query,queries,smallint
At 10:56 -0500 3/7/03, Dan Geist wrote:
I read the thread by R. Weiss, P. DuBios, and J. Zawodny regarding the
incomplete implementation of replication over SSL. I had been fighting
the same problem for about a week, thinking it was something I was doing
wrong.
Hello listers,
In mysql, is it possible imbed a conditional CASE statement within a SUM()
function to effect how the SUM() returns the final value for a set of rows?
For example, if I have a table foo with column score, and score has
the rows with the values 1 to 10, can I write the SUM() in
Peter,
I think something like this will work:
mysql select sum( if(score=7, score * 2, score)) from table_name;
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Fri, 2003-03-07 at 17:56, Dan Geist wrote:
If I understand the process, the act of replication is a simple connect
via a dedicated and persistent thread on the slave which which registers
No, it is not simple. It is not very complicated also but bit unusual.
Usually SSL layer stuff uses
MySQL folks,
I posted a full bug report yesterday, but I'm afraid that my problem might
get lost in the details. It also had the wrong reply email address. Here's
a summary:
Under a variety of circumstances, creates and inserts of a
table with many columns, 2304 to be exact, hang the
Thanks All for reply my message.
After I reconfigured mysql server, I did load test. When mysql server
reached 99.7%, but CUP resource is only at 50%. Since this server is
mysql database only.
Is there a way I can change some mysql system variables to increase CUP
resource usage to 80%-90% when
I am using the the following command:
#./configure --enable-thread-safe-client --prefix=/usr/local/mysql
This is what happens:
checking named thread libs:... -lpthread -lthread
checking for strtok_r in -lpthread... yes
checking for strtok_r... yes
checking for dlopen in -ldl... yes
At 11:29 -0500 3/7/03, Peter D Bethke wrote:
Hello listers,
In mysql, is it possible imbed a conditional CASE statement within a SUM()
function to effect how the SUM() returns the final value for a set of rows?
For example, if I have a table foo with column score, and score has
the rows with the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Smurf wrote:
Description:
How-To-Repeat:
mysql -ecreate table `FIELDS` (x int) test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Why not mysqldump --quote-names test
-Mark
- --
MySQL 2003 Users Conference -
That's also right:
select sum( case 1 when score=7 then score * 2 else score end) from foo;
[EMAIL PROTECTED] on 03/07/2003
11:28:03 AM
To: Peter D Bethke [EMAIL PROTECTED], MySQL List
[EMAIL PROTECTED]
cc:(bcc: David P. Giragosian/MDACC)
Subject: Re: CASE statement
How-To-Repeat:
I am tried to use MS DTS to transfer a table from MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation on one data type. The
error happens when I have a text datatype on MSSQL 2000 table, and
text/blob on MySQL table.
The error is fail to insert or
i installed
1. MySQL 3.23---Production release(recommende),
2. Windows 95/98/NT/2000/XP 3.23.55 13.co3M,
3. Windows Source(zip) 3.23.55 13.2M
4. Control Center,
in my PC.
I created a testDB from Control Center, Added it and message shows as 'Connection
added successfully' but
its
When I try to connect to this box from another box which I have
granted all
rights, I get the error:
ERROR 2013: Lost connection to MySQL server during query
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467
lost connection ...
[mysqld]
set-variable
That was a great suggestion (getting rid of the
blank user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL PROTECTED]:~$ mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:~$
Actually thinking about this in a bit more depth! I also have the infamous
items table where individual company records are being stored. So is the best
way to do this:
i) add another field that will coreespond to the items.ItemsID or
ii) create another table town_ref
CREATE TABLE town_ref (
On Fri, Mar 07, 2003 at 11:05:37AM -0600, Judi Buff wrote:
I am using the the following command:
#./configure --enable-thread-safe-client --prefix=/usr/local/mysql
You realize that you've given us no details of your platform. OS,
version, which version of MySQL, etc.
Please help if you can
MATCH / AGAINST problem/bug
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
Under some circumstances this query does never terminate. The win32
service cannot be stopped either.
SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST
('550') AS score FROM
On Fri, Mar 07, 2003 at 01:23:27PM -0600, Judi Buff wrote:
Brian,
I'm sorry, I am running Solaris8 on Sparc, and trying to install MySQL 3.23.53. I
get into this stuff so deep I have tunnel vision and think the whole world should
know what I am talking about.
On Fri, Mar 07, 2003 at
I just installed the standard-4.0.11 binary and
the same problem exists. Error 1130: this host
is not allowed to connect. Run the grant and flush
privs. Access denied...
--
Steve (egrep)
On Fri, 7 Mar 2003, Steve Pirk wrote:
That was a great suggestion (getting rid of the
blank user), but
Your whole query is malformed. You have an aggregate function in the
having.
try:
select f1,max(f2) from tt where f1=1 group by f1;
Gabriel Tataranu wrote:
Hi,
this is NOT correct behavior. Where clause returns (1,1) and (1,2). The HAVING
clause should be applied to what WHERE has
You grant IP address does not match the IP address of the client failing
the connection.
Steve Pirk wrote:
That was a great suggestion (getting rid of the
blank user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL
Hi ..
Free disk space: 32GB
Thats not the problem I guess.
-Mat
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Freitag, 7. März 2003 22:03
To: Mathias Berchtold
Cc: [EMAIL PROTECTED]
Subject: Re: MATCH / AGAINST bug/problem
I you run low on temp filesystem
thank you very much !!!
I will try 4.0 then
tommy
From: Tonu Samuel [EMAIL PROTECTED]
To: tommy liu [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: problem setting up DES_ENCRYPT on MySQL 3.23.46
Date: 07 Mar 2003 16:04:19 +0200
On Thu, 2003-03-06 at 17:52, tommy liu wrote:
anyways, yes I
Hi,
Your whole query is malformed. You have an aggregate function in the
having.
It's absolutely legal query. In fact I don't get any error messages that say
otherwise. I'm not SQL guru but I haven't heard that agregate functions have
to be excuded from HAVING clause. To
030308 8:09:29 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030308 8:09:29 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030308 8:09:29 Slave I/O thread exiting, read up to log 'FIRST', position
4
030308
Both ip's are in the user table along with the
% wildcard.
--
Steve (egrep)
On Fri, 7 Mar 2003, gerald_clark wrote:
You grant IP address does not match the IP address of the client failing
the connection.
Steve Pirk wrote:
That was a great suggestion (getting rid of the
blank user), but
Howdy Egor,
Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote:
Both columns Node are indexed, so just add foreign key constraint. You can
find examples in the InnoDB manual:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
I've looked at the examples, but one thing it doesn't
Hello,
We're a web hosting company currently hosting nearly 2000 MySQL
databases (3.23.54) at around 200-300 queries/second. Amazing
performance, really. But we're growing fast and planning for the next
step. Our wishlist is short:
We want to allow all our customers to have one set of
On Fri, Mar 07, 2003 at 04:56:54PM -0700, John Masterson wrote:
Hello,
We're a web hosting company currently hosting nearly 2000 MySQL
databases (3.23.54) at around 200-300 queries/second. Amazing
performance, really. But we're growing fast and planning for the next
step. Our wishlist is
http://www.databasejournal.com/features/mysql/
-
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
Can I have multiple foreign keys in a table? Like this... I ask because I
can't seem to get it to work. Errno: 150.
CREATE TABLE `dept_table` (
`dept_id` mediumint(8) unsigned NOT NULL auto_increment,
`dept_timestamp` timestamp(14) NOT NULL,
`dept_company_table_id` mediumint(8) unsigned NOT
I'm investigating the feasibility of converting an MS Access
database to
a MySQL based system and could use some advice.
The server side will probably be run on a Linux box and is not a
problem since I
can deal with that easily enough. The clients will all be win98
based (possibility of
Disregard my previous msg. It looks like I have it figured out.
Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote:
I've looked at the examples, but one thing it doesn't mention is whether
both indexes need to be unique. In the primary table they are, but does
the index in the table
If I create a table that uses REFERENCES in it, then mysqldump it, the
REFERENCES isn't there
Notice the `contact_dept_table_id` field in both of the below outputs:
CREATE TABLE `contact_table` (
`contact_id` mediumint(8) unsigned NOT NULL auto_increment,
`contact_timestamp` timestamp(14)
Description:
Message indicates to use /usr/bin/mysqladmin to set root password
at end of installation, but this is not included in the distribution
How-To-Repeat:
RedHat 8.0 - rpm --install -p MySQL-3.23.55-1.i386.rpm
Fix:
Submitter-Id: Paul Higgs
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the server is
foo.bar.com):
% ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
I then try to connect from the local machine with:
% mysql -h localhost -p 3307 --user=me
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the server is
foo.bar.com):
% ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
I then try to connect from the
Hello,
This is my first post to [EMAIL PROTECTED]
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in
At 03:35 2003-03-08, Henrik Leghissa wrote:
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
At 03:51 2003-03-08, Henrik Leghissa wrote:
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
I managed to get passed the ./configure-phase, but now I encountered more
trouble;
To compile mysql I write make... and get these error-messages after a
while;
SNIP
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/usr/local/mysql/var\
-DSHAREDIR=\/usr/local/mysql/share/mysql\
What does it really matter is whether you have create mySQL user that allow
access the database from the SSH server.
Please note that localhost, 127.0.0.1 or the machine ip address will be
treated as different entries by mySQL.
--
Yours,
KH Chiu
CA Computer Consultants Ltd.
Tel: 3104 2070 Fax:
Hello everyone,
I'm trying to write a query that would update a field in a table. Here is
the catch.
Table 1 has two fields - field A and Field B
Table 2 has two fields - field A and Field B
Each table has many more fields but these are the only two I'm concerned
with right now.
Field B in
At 17:10 -0500 3/7/03, Christopher M Burger wrote:
Hello everyone,
I'm trying to write a query that would update a field in a table. Here is
the catch.
Table 1 has two fields - field A and Field B
Table 2 has two fields - field A and Field B
Each table has many more fields but these are the only
Hi,
I had some private e-mail suggesting that MAX functions should apply to
the full table - as it is the maximum value of the field- and this is why
HAVING clause behaved in that manner.
I'm sure this is not the case since MAX does obey (as it should)
WHERE clause in the query.
I have mysql 3.23.55 for Windows where charset win1250ch is included. Now
I download the same version for Linux (rpm) but this charset is not included
here. Why?
Thank you for your quick reply.
Petr Vileta, Czech Republic
http://www.practisoft.cz
1 - 100 of 105 matches
Mail list logo