> Dear All,
>
> I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat
> linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and
> libc-5.3.12-3.1. How can i upgrade to version 3.23.
>
> thanks in advance
>
> sankalap
>
>
>
--
MySQL General Mailing List
Fo
Dear All,
I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat
linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and
libc-5.3.12-3.1. How can i upgrade to version 3.23.
thanks in advance
sankalap
--
MySQL General Mailing List
For list archives: http
Hi,
I'm using MySQL 4.0.13 for both master and slave servers.
However I have problem starting slave server. Error log says:
030804 14:06:10 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'backend2-bin.228' at position 43583528
030804 14:11:48 Slave I
Roger -
Thank you for taking the time to clarify that for me. I was using "PHP
with MySQL" and they are not clear on the differences I found and you
explained.
Thanks again
Todd
Roger Baklund wrote:
* Todd Cary
I did some experimenting and here is what I found:
* Todd Cary
> I did some experimenting and here is what I found:
[...]
> The "%" in the Host column does not appear to work for me,
> and there is something different about "*" and "*.*".
The manual is a usefull source of information... ;)
http://www.mysql.com/doc/en/Adding_users.html >
http://
Hi Todd,
Thank you for the reply.
I once more created an account.
See below the "SHOW GRANTS FOR usertest" command. I did login without setting
a default database. If you use the first command * then you will only be
able to login (no other privileges), depending on the mysql version you will
I did some experimenting and here is what I found:
grant all
-> on *
-> to bugsbunny indentified by 'bugs
-> with grant option;
After putting the above into MySQL as root, I signed on as "todd" with
the appropriate PW and tried to get into mysql with
mysql -u bugsbunny -p [using bugs
What is annoying about this is that if you use mysqlimport to put this
data into the table, I get:
testdb.testtable: Records: 3 Deleted: 0 Skipped: 0 Warnings: 2
So, where are the warnings coming from? Is there some public API, below
the C API layer, that one can use to obtain this inform
Hi,
I've installed 4.0.13 on a WinXP system. The service starts and stops just fine, but
I cannot connect to the server, nor can I ping the 3306 port. I think the problem may
be failure to complete the post-installation processing. The doc says to run
installdir\scripts\mysql_install_db. H
Hi FT,
2003年 8月 4日 月曜日 09:24、あなたは書きました:
> Thanks Nils...good to have you around...in Tokyo
> This worked except for the UPDATE than was not recognized by MySql 3.23.36
> but strangely all previous tables were still there and it looks like it is
> running again.. still worry about this UPDATE comm
Hi Todd,
2003年 8月 4日 月曜日 08:17、Todd Cary さんは書きました:
> Jamie -
>
> <<<
>
> grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
> grant all;
> flush privileges;
Flush privileges is not necessary here I believe. Only when you update the
privileges 'manually' with INSERT, UPDATE
I just got it working by rebooting the computer.
Thanks any way
Ashish
From: "Ashish Gupta" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: installation of mysql 4.0.14 on windows xp
Date: Sun, 03 Aug 2003 19:30:48 -0500
Dear Mysql-help,
I am new to mysql server and trying to install the mysql
Hi Todd,
2003年 8月 4日 月曜日 08:01、Todd Cary さんは書きました:
> Nils -
>
> What is the difference between "*.* " and "* "?
Hi Todd I just double checked.
There is no difference. Both work the same way. I originally thought that the
first one wouldn't have worked, but I checked it now. However I believe tha
OK,
I have a MySQL server running 4.0.12 on a 12 CPU Sun U4500 with 12GB of
memory.
With the query cache running, this machine would noticeably "hiccup"
(just stop responding to requests) every so often and wouldn't squeeze
more then 1000 queries per second or so as a result (heavily mixed OLT
Dear Mysql-help,
I am new to mysql server and trying to install the mysql server on my
windows xp home edition. I have downloaded 4.0.14 zip file on my computer.
I can unzip the file and it generates 10-15 files. When I do double click on
the setup.exe it loads for 5 seconds and then stops. No wind
Hi everyone, I was wondering if there's any way I can lower MySQL's memory
useage? It often uses more than 5kb which I consider to much.. I'm
guessing I should play with my.cnf or whatever it's called (located at C:/
and windows calls it cardnumber or something)...
Thanks in advance...
// DvD
Jamie -
<<<
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant all;
flush privileges;
>>>
That definitely works, but what I am not sure about is now -u todd -h localhost has all "Y" in the privileges; before only the first few had "Y".
Why is that? Is that due to
Forgot to copy the list ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 4日 月曜日 07:45、Nils Valentin さんは書きました:
> Hi Kevin,
>
> Correct me if I am wrong, but the sweddish character set is the default
> setting with mysql ;-).
>
> I was supposing that includes the most or all scandinavian charac
Jamie -
Two questions:
1) Does "grant all" give the user the rights to create a database.
2) What is the difference between "on * " and "on *.* "
Todd
Jamie Krasnoo wrote:
You still need to flush the privileges. Changes in permissions are not
automatically committed. Also you should add
What version of MySQL are you using?
Regards,
A$
On Saturday, August 2, 2003, at 11:45 PM, Pascal Délisle wrote:
Hi!
I try to figure out how to use a nested "SELECT" statement after the
"IN" predicate. For example, when I try this code, it doesn't return
anything although it should:
SELECT b
Mike,
Sure, try this:
UPDATE table SET days = TO_DAYS(exp_dte) - TO_DAYS(NOW());"
As a side note, I recommend you make this calculation in whatever
application this DB supports. Otherwise you will continue to need
running a script to update the dates.
Regards,
A$
On Saturday, August 2, 2003,
Hi!
> "Bennett" == Bennett Haselton <[EMAIL PROTECTED]> writes:
Bennett> Is there any way to do a long update/delete on a table such that you can
Bennett> view the progress as the command runs, so that long before it's over, you
Bennett> have some idea of what the total running time will b
I know the replication method is different in MySQL 4.0 then MySQL
3.23.x, but I have a bug that causes problems. The following query will
cause MySQL's logic to not properly read any of the following my.cnf
commands on slave servers:
replicate-wild-do-table
replicate-wild-ignore-table
replicate-
In the last episode (Aug 03), Pascal Dlisle said:
> Finally, I solved my problem by creating a temporary table that holds
> the result of the subquery. So, it looks like this:
...
> The only problem I see is when there are concurrent access to the
> table "livreTemp", e.g. when there are multiple
>The only problem I see is when there are concurrent access to the table
>"livreTemp", e.g. when there are multiple simultaneous requests of that
>kind. Is there a better way for achieving this under mySQL 3?
Yes, concurrent access would be a problem. I think I have the answer using a
single que
Since I'm new to mySQL, could you point me how to create temporary
tables dynamically?
Le dimanche, 3 aoû 2003, à 15:32 Canada/Eastern, Jim McAtee a écrit :
- Original Message -
From: "Pascal Délisle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 03, 2003 1:02 PM
Subje
- Original Message -
From: "Pascal Délisle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 03, 2003 1:02 PM
Subject: Re: Nested SELECT statements problem
> Finally, I solved my problem by creating a temporary table that holds
> the result of the subquery. So, it looks
David,
Is it possible to cause the client to wait by the server issuing a
SLEEP? What if the client just disconnectes and immeadiately reconnects?
Say you use a sleep of 2 seconds. If your server can accept 100
connections at once then 1 client can issue 100 login attempts and wait
2 seconds for th
Mattias,
Your 'blueprint' table looks good.
> This where "itemID" corresponds to a item in the master table and the
> "componentID" ALSO referes to items in the Master table???
Correct. This allows 'recursive' components. For example, Item 3
contains components 1,3,4 and component 4 is actually
Finally, I solved my problem by creating a temporary table that holds
the result of the subquery. So, it looks like this:
CREATE TABLE livreTemp (IDLivre int(11));
INSERT INTO livreTemp (IDLivre) SELECT book.IDLivre
FROM livre book, livreEcritPar ecr, auteur aut WHERE aut.Prenom like
'%$firstNa
You still need to flush the privileges. Changes in permissions are not
automatically committed. Also you should add the host to the username.
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant option;
flush privileges;
Jamie
On Sun, 2003-08-03 at 09:52, Todd Cary wrot
Is there an option for mysqld to add a sleep() call after each failed
connection request, before reporting to the client (to slow down brute
force attack)? I glanced at the manual and there doesn't seem to be one.
If there isn't, would it be a good idea? If yes, I could probably submit
a patch.
While I found some information on this subject:
http://groups.google.com/groups?q=mysql+win32+encrypt&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=be3g14%24ulu%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1
I can't make much sense of it.
Is there a *clear* way to have encrypt() call working on mySQL running on Wi
I have installed Red Hat 9 and it installs MySQL. After logging on as
root, I did the following:
mysql
mysql> use mysql;
mysql> grant all
-> on *
-> to todd indentified by 'my_password'
-> with grant option;
I then log out of mysql and log out as root. Logged in as "todd" I
type the followi
Thanks for your input!
First, I removed the quotation marks into the sub-query in order to fix
syntax. Then, I tried to use different alliases from the main query.
However, this doesn't work. I mean that mySQL return a syntax error.
I checked the server version and it is 3.23.56. As someon
Sunday August 03 2003 15:47, =?iso-8859-1?Q?Kevin_=D8stmark?= wrote to
All:
is> Does newer versions MySQL support words with Scandinavian letters
is> like
is> , , , , etc in full-text searches?
Those have nothing to do with ANSI.
KS
KARICO Business Services
Toronto, ON Canada
* Todd Cary
> I have a file produced by mysqldump and I need to restore it. Can
> someone point me toward the instructions on how to do this?
http://www.mysql.com/doc/en/mysqldump.html >
Just before the user comments:
"You can read this back into MySQL with:
mysql database < backup
I have a file produced by mysqldump and I need to restore it. Can
someone point me toward the instructions on how to do this?
Todd
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* KB
> i am a new-bie,
> should i even think of using mySQL in the following scenario ?
> i have a situation in mind where two or three ( sometimes
> concurrently ) people will be making invoices, on three computers
> in different locations on lan.
mysql is perfect for such a scenario, and you ha
Does newer versions MySQL support words with Scandinavian letters like æ, ø,
å, ö, ä etc in full-text searches? The server I'm on runs 3.23.53a. If so,
from what version was it supported? And where can I find documentation on
it? Can't find anything in the full-text manual..
Best regards,
Kevin Øs
to mention one step before re-installing anything and skipping user handling of
mysql...
initially, there's no root passwort set at all. so you came into the server without
any changes to pma configuration or any special parameter to the mysql client.
did you change that password in the phpmyad
41 matches
Mail list logo
