Elim Qiu wrote:
Here is where i stuck:
I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02
and put it where 5.01 worked.
I'm wondering if there are specific folder names that have "5.02"
instead of "5.01"? Or registry entries?
My version of MySQL doesn't have anything
- SQL command on connect: left empty
Note that I can connect to and manipulate the test database
interactively (I added a table, inserted records, etc., all as user
'whil')
7. Hit "Test Data Source"
8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support
authentication proto
Here is where i stuck:
I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02
and put it where 5.01 worked.
Delete the data folder shipped with 5.02zip and restart the service. Since
my data location is outside
of the mysql installation location and this is working with my.in
Whil Hentzen <[EMAIL PROTECTED]> wrote on 02/03/2005 11:02:48 AM:
>
> 1. Windows 2K and MySQL 5
> 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported
> with the .10 driver, so avoided it to begin with) and installed it. It
> shows up in the ODBC admin nicely.
> 3. Created a n
Elim Qiu wrote:
Anyone successfully make MySQL 5.02 working on windows2000?
I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.
I'm running 5.0.2-alpha-net on W2K. Got it running without any problems.
Getting ODBC to work, on the other hand, was a bit of a chore
Anyone successfully make MySQL 5.02 working on windows2000?
I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005
--
MySQ
1. Windows 2K and MySQL 5
2. Downloaded the 3.51.9 driver (I've seen a number of issues reported
with the .10 driver, so avoided it to begin with) and installed it. It
shows up in the ODBC admin nicely.
3. Created a new file DSN with the ODBC Admin
4. After I entered a name for the dsn ("mysqlf")
Victor Pendleton wrote:
> A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using 4.0.22-nt-max), I can't login. I know that there
are supposed to be mods made to the mysql
ECTED]>
Sent: Friday, December 10, 2004 3:33 PM
Subject: Problems Moving from 3.23 to 4 (Win2k)
> I made a copy of my entire Mysql 3.23 data directory and moved it on to
> a box with a fresh install of MySQL 4. While the NT service starts up
> fine (I'm using 4.0.22-nt-max), I c
What errors are being displayed when you attempt to log in? Is anything
being written to the error log itself?
A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using 4.0.22-
I made a copy of my entire Mysql 3.23 data directory and moved it on to
a box with a fresh install of MySQL 4. While the NT service starts up
fine (I'm using 4.0.22-nt-max), I can't login. I know that there are
supposed to be mods made to the mysql database tables, but I thought
there was at
I've have been looking for libmysqld.dll so I can test the MySQL embedded
server on my Win2k machine. Where can I download it? I've searched
www.mysql.com to no avail. TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Victor Pendleton wrote:
> If you are going to do this, may I suggest starting MySQL with a non
> standard port number?
Yeah, right. And a hacker will not perform a portscan? And he will not
recognize a response from that port (e.g. "Host '' is not allowed
to connect to this MySQL server")???
Rega
MAIL PROTECTED]
Sent: 4/28/04 10:12 AM
Subject: MySQL on Win2k Server open to connections from all IPs
Hi,
I have installed mysql 3.23 on our Windows 2000 Server machine. How can
I
configure the database such that anyone on the internet can connect to
this
database? I know this sounds dangerous bu
Hi,
I have installed mysql 3.23 on our Windows 2000 Server machine. How can I
configure the database such that anyone on the internet can connect to this
database? I know this sounds dangerous but once this has been configured we
will install VPNs on this machine and any machine that we permit
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it
contains confidential client information. It has to be Window because
applications accessing the database are written in Windows.
The problem is laptops do get stolen quite often, even when running on
someone
At 18:06 3/6/2003 -0700, Charles L. Nelson wrote:
Hi,
I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
and I subsequently subscribed to the belief that MySQL would fail when
installed in a location that was different that the default location. I
tried a myriad
6月 4日 水曜日 10:06、Charles L. Nelson さんは書きました:
> Hi,
>
> I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
> and I subsequently subscribed to the belief that MySQL would fail when
> installed in a location that was different that the default location.
Hi,
I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
and I subsequently subscribed to the belief that MySQL would fail when
installed in a location that was different that the default location. I
tried a myriad of things to get the database system to function
ySQL 3.23.39 shuts down by itself on Win2K
>
>
>
> It seems
>
> "The client had been sleeping more than wait_timeout or
> interactive_timeout
> without doing any requests."
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.
It seems
"The client had been sleeping more than wait_timeout or interactive_timeout
without doing any requests."
From: "Al Caponi" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Subject: MySQL 3.23.39 shuts down by itself on Win
Hi all,
(BI've got a java application running with MySQL 3.23.39 on a Win2K server.
(BNo other application uses this MySQL server.
(BAnd yesterday it just shut down without any reason. This is the second time.
(BThe first time was a few months back and I didn't pay attention to i
Hi, i've a problem.
I must put two Mysql server daemon on same WIN2K server, but i don't know
set two different my.ini file.
If i run the service interactively I'm able to set to the service a
different path for my.ini file, but when i start winmysqladmin he create a
new my.ini file
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 installation
Hi
I am new to MYSQL. I have just installed 4.0.5 onto Win2K and I am having
problems getting the thing started. NET START MYSQL starts fine, but it
seems to fail with the following contents generated in the mysql.err file
(below).
Any ideas what I am doing wrong?
Thx
GM
InnoDB: The first
Thanks Stefan - I found the problem in my my.ini file. Fixed and on.
Thanks for the help.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 3:15 PM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: Re: Install on WIN2k
+49 30 7970948-3
- Original Message -
From: "Norris, Joseph" <[EMAIL PROTECTED]>
To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "Norris,
Joseph" <[EMAIL PROTECTED]>; "Mysql_List (E-mail)"
<[EMAIL PROTECTED]
.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 2:27 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: Re: Install on WIN2k
Norris,
> ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
> I rem
On Thursday 23 January 2003 02:55, Norris Joseph wrote:
> I have been running mysql on windows 2000 for about 8 months. Now I have to
> install it on a new win2k box.
> I get everything installed and go to get into mysql and I am getting this
> error:
>
>
> ERROR 2003: C
t;
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Norris, Joseph" <[EMAIL PROTECTED]>
To: "Mysql_List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 1:55 AM
Subject: Install on WIN2k
> H
Hello,
I have been running mysql on windows 2000 for about 8 months. Now I have to
install it on a new win2k box.
I get everything installed and go to get into mysql and I am getting this
error:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I remember this w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Is there a patch update from .3 to .4? So that I don't have to reinstall it
> on my win2k box? If I have to reinstall it do I need to first uninstall
> .3 first?
>
You have to reinstall. But that isn't a big problem - after
Is there a patch update from .3 to .4? So that I don't have to reinstall it
on my win2k box? If I have to reinstall it do I need to first uninstall
.3 first?
mysql.
-
Before posting, please check:
http://www.mysq
At 00:49 15/12/2002 +0100, Stefan Hinz wrote:
Hi,
Dear list,
MySQL 4.0.5 seems to be the first version that does not use named pipes on
my Win2K box ...
Use the --enable-named-pipe at command prompt or in your
configuration file my.ini/my.cnf:
Microsoft Windows 2000 [Versão 5.00.2195]
(C
Dear list,
MySQL 4.0.5 seems to be the first version that does not use named pipes on
my Win2K box ...
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Hi,
I'm trying to build mysql from the development sources (3.23.54,
retreived using bitkeeper) under win2k using cygwin.
Following the instructions in the mysql manual, I'm having a problem
running aclocal:
Dango) aclocal
aclocal: configure.in: 450: macro `AM_PROG_AS' not found
Listen,
Wednesday, November 20, 2002, 7:31:27 PM, you wrote:
LH> thanks for your great advice, finally pointing out the reason for the
LH> problem.
>> SH> mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
>> SH> PRIMARY KEY;
>> SH> ERROR 7: Error on rename of '.\trainee\auftra
lt;http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 7:52 PM
Subject: re: Strange Error w
Stefan,
Sunday, November 17, 2002, 5:12:52 PM, you wrote:
SH> yesterday I imported some tables from MS Access via ODBC into my brand
SH> new MySQL 4.0.4 server. Everything went fine, but the tables did not
SH> have a primary key, so I did the following:
SH> mysql> ALTER TABLE auftrag CHANGE Numme
Dear Jocelyn,
> > On Win2K with MySQL 4.0.4 I get this error with a MyISAM table:
> > mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT
NULL
> > PRIMARY KEY;
> > ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to
> > '.\trainee\#
" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 6:08 PM
Subject: Please help with strange Win2K error
> Dear list,
>
> sorry for bothering you again, but no one has answered to my request for
> help so far, not even Jeremy Z. who *I know* can solve every and any
>
Dear list,
sorry for bothering you again, but no one has answered to my request for
help so far, not even Jeremy Z. who *I know* can solve every and any
problem remotely ;-)
On Win2K with MySQL 4.0.4 I get this error with a MyISAM table:
mysql> ALTER TABLE auftrag CHANGE Nummer Nummer
Dear list,
yesterday I imported some tables from MS Access via ODBC into my brand
new MySQL 4.0.4 server. Everything went fine, but the tables did not
have a primary key, so I did the following:
mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
PRIMARY KEY;
ERROR 7: Error on r
ystem is running on Win2K.
What we plan to do is to partition the disk into two sections: C: contains
all the executlable software - Windows, MySQL and our middleware. D: is
intended to contain *only* the MySQL data. It is therefore mounted as C:
\mysql\data. The idea is then that if we get any ki
4.x.x stuff in MySQL.
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 23, 2002 7:01 AM
Subject: Re: MySQL Gui Install and Setup for Win2K
> And where would one obtain MySQL Navigator?
>
> JMichael
>
>
>
>
uot; <[EMAIL PROTECTED]>
Subject:Re: MySQL Gui Install and Setup for Win2K
Don't let them mislead you, MyCC might as well be dead too... there hasn't
been an update to it for more than 4 months. Go get MySQL Navigator
because
at least IT can export to a file th
list" <[EMAIL PROTECTED]>
Sent: Sunday, September 22, 2002 9:14 PM
Subject: Re: MySQL Gui Install and Setup for Win2K
> Don't let them mislead you, MyCC might as well be dead too... there hasn't
> been an update to it for more than 4 months. Go get MySQL Navigator
beca
We were told by David Axmark of MySQL AB to stop using MySQLGui and switch
to MyCC. MySQLGUI is apparently dead.
- Original Message -
From: "David Kramer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 16, 2002 12:52 PM
Subject: MySQL Gui Insta
er 18, 2002 6:25 AM
To: Dawn Friedland; [EMAIL PROTECTED]
Subject: RE: Japanese Characters in MySQL & Win2k
Hi,
I think Joel Rees wrote an interesting message as well. Hope you read
it.
I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through
ASP/PHP/JSP/Perl DBI. There is no
Original Message-
| From: Dawn Friedland [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, September 18, 2002 7:46 AM
| To: Shashank Tripathi; [EMAIL PROTECTED]
| Subject: RE: Japanese Characters in MySQL & Win2k
|
|
| Thank you Thank you.
|
| Are you run
out
a deepfry (I can't read Japanese!)
-Original Message-
From: Shashank Tripathi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 3:36 PM
To: Dawn Friedland; [EMAIL PROTECTED]
Subject: RE: Japanese Characters in MySQL & Win2k
Storing JP and EN data in the same ta
Storing JP and EN data in the same table has worked for me ever since I
started using MySQL. Unlike Oracle, you don't need any specific charset
configs (I may stand corrected). The idea is to use the correct
character encodings when you *display* the data after pulling it out. In
your case, I'd th
This is for anyone out there storing Japanese characters along with
English characters. I've searched everywhere for anything that has to do
with my particular situationwith no progress. I'm stuck.
SUMMARY:
The client recently requested that Japanese be stored in an otherwise
standard Engli
Matthew,
- Original Message -
From: "Matthew Fallshaw" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 17, 2002 5:40 AM
Subject: Re: InnoDB Win2k Service doesn't start
> [EMAIL PROTECTED] (Matthew Fallshaw) wrote in messag
Message -
From: "Iikka Meriläinen" <[EMAIL PROTECTED]>
To: "AOK Lansing" <[EMAIL PROTECTED]>
Cc: "MySql List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 3:47 PM
Subject: Re: Win2K Problem?
Hello,
If you provide the exact error message, it woul
which i call Edupro which uses
> PEAR and Mysql as the DB
>
> Everything was fine till i notied that when
> i was trying to lock the tables for WRITE access It showed an
> error and the table couldnt be locked
>
> Is there something i need to do before i lock a table
I know version 4.0.1 does.
I use Delphi 6 to write my UDF's for it.
mike
-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 9:20 PM
To: [EMAIL PROTECTED]
Subject: UDF on win2k??
hi,
i checked the manual, but i want a confirmation
hi,
i checked the manual, but i want a confirmation here: Mysql for window
doesn't have UDF, right?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
On 5 Jun 2002, at 7:50, Jared Richardson wrote:
> This table is part of a product that contains publicly available (and
> always expanding) publicly avilable biological data in addition to
> large companies internal data. A one terrabyte cap very well could
> come back to haunt us one day! (sadl
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Jared Richardson" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 5:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
| On 4
On 4 Jun 2002, at 15:43, Jared Richardson wrote:
> | >AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295;
> |
> | Why do you use AVG_ROW_LENGTH=4096? It seems to me the max record |
> length is 528...? |
>
> According to the MySql docs, the max table size is AVG_ROW_LENGTH *
> MAX_ROWS
>
> We were try
I replied below
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
| * Jared Richardson
| [...]
| > CREATE TABLE Ic
| Jared, I can't help solve your problem, but I'd be very interested if you
| got an answer!
|
| Two suggestions though that may be of use:
| 1) Make sure your indexes are healthy
| 2) Try using a MERGE table
Thanks! The indexes are the problem as I understand it... it appears that
MySql is
* Jared Richardson
[...]
> CREATE TABLE IcAlias(
>IcAliasID BIGINT NOT NULL PRIMARY KEY,
>mID VARCHAR(255) NOT NULL,
>IcEntityID BIGINT NOT NULL,
>IcTypeID SMALLINT NOT NULL,
>IcDupSortID VARCHAR(255) NOT NULL,
>INDEX mIDIdx (mID),
>INDEX IcTypeIDIdx (IcTypeID),
>IN
ay, June 04, 2002 4:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
> Thanks Walter since their is no reason (that I am aware of) for the
> system not to handle the current problem, I want to try to solve it if
> possible. I have been using MySql for
ed Richardson '" <[EMAIL PROTECTED]>; "Schneck Walter"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 10:20 AM
Subject: AW: Bug related to large tables and it's indexes on Win2k
| Well,
|
| im not an exper
t: AW: Bug related to large tables and it's indexes on Win2k
| Hi,
|
| what table-typ do you use ?
|
| rg Walter
|
| -Originalnachricht-
| Von: Jared Richardson
| An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
| Cc: Jared Richardson
| Gesendet: 04.06.02 14:17
| Betreff: Bug related to
Win2k (at least the version that we are on) does indeed support files much
larger than 2 gigs. Another db we use has index files that are 6.8 gigs and
4.7 gigs.
- Original Message -
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: "Jared Richardson" &l
Hi all,
When large tables are being addressed, we seem to have encountered a bug
related to having large indexes on the table.
We have several tables in our system that have reached 4 gigs in size. We
altered the table definition to allow it to get larger... this is our
current table creation s
jake williamson 28 queried:
> hello!
>
> i've been developing a MySQL database in mac osX - i would like to
transfer
> it to work onto a win2k box running apache and mysql.
Have you looked at mysqldump and mysqlhotcopy, in section 4.8 of the manual?
> what files from X do
hello!
i've been developing a MySQL database in mac osX - i would like to transfer
it to work onto a win2k box running apache and mysql.
what files from X do i need to copy over? is this a fairly simple process or
am i heading for a world of pain?!
cheers,
jake
p.s. if this is possible,
I am having a heck of a time getting a simple c program up and running using mingw and
the mysql c api.
My makefile is simple enough I'm not sure what the -lm switch on the search compile
line is for but I saw it in someone's makefile on the web so I through it in hoping it
would work):
# mak
I am having a heck of a time getting a simple c program up and running using mingw and
the mysql c api.
My makefile is simple enough I'm not sure what the -lm switch on the search compile
line is for but I saw it in someone's makefile on the web so I through it in hoping it
would work):
# mak
The problem is following:
MySQL 4.0.1 alfa on Win2k machine
MyODBC 3.51.01
Access XP
I need to migrate my clients database from Access to MySQL server and
use Access as a frontend to MySQL for adding data. BUT default system
locale is different from MySQL locale (cp1257). My database is in
The problem is following:
MySQL 4.0.1 alfa on Win2k machine
MyODBC 3.51.01
Access XP
I need to migrate my clients database from Access to MySQL server and
use Access as a frontend to MySQL for adding data.
BUT default system locale is different from MySQL locale (cp1257). My
database is in
- Original Message -
From: <[EMAIL PROTECTED]>
To: Michael Vejs <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 12:45 PM
Subject: Re: MySQL security on Win2k server ??
> Your message cannot be posted because it appears to be either spam or
> simply off topic
Problem is solved ... customer had his server configured so any new services
being installed were automatically disabled! That is why the service would
not start.
We have installed MySQL on about a dozen Win2K Advanced servers ... this is
the first time we have encountered this issue.
Thank you
t_fltk]
> help_file= F:\MYSQL\sql_client\MYSQL.help
> client_file= F:\MYSQL\MYSQL.options
> history_length=20
> database = Wires
> queries_root= F:\MYSQL\queries
> last_database_file= F:\MYSQL\lastdb
>
>This system is to use MyISAM tabl
= F:\MYSQL\queries
last_database_file= F:\MYSQL\lastdb
This system is to use MyISAM tables.
>From a DOS prompt, we switched into the F:\MYSQL\BIN directory and...
mysqld-nt --install
Win2K reports the service installed.
When we ...
net start mysql
we get the following e
Hi,
i installed mysql-3.23.47-win version on win2k, but i cant start MySql
service.
When i try to start mysql service, i get an error msg like this;
Can't start MySql service on Local Computer
Error 1067 : Unexpected process termination.
i installed mysql once again and started service
SQL
> : -)
>
> Also NB, Roel
>
> -Oorspronkelijk bericht-
> Van: Bryan Capitano [mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 10 januari 2002 8:51
> Aan: [EMAIL PROTECTED]
> Onderwerp: setting root psswd on Win2K ??
>
> Having some problems setting root p
Gerald...
He isn't on a Unix box, he is on a Win2k box
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 8:46 AM
To: Bryan Capitano
Cc: [EMAIL PROTECTED]
Subject: Re: setting root psswd on Win2K ??
You can't login as plain
However, you are running WIN2K, not unix as i assumed in my previous post.
There still must be some default user which apparently has full privileges.
Bryan Capitano wrote:
>Having some problems setting root password on MySQL. Can anybody help
>me?
>
>I've just installed M
You can't login as plain old nobody.
The default mysql user is your unix user, so if you are
logged into unix as root , and entered "mysql" you were logged into
mysql as root.
You appear to have been logged in as "mysql".
If the user "mysql" has full privileges, then there was nothing to
prevent
Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows 2000 server.
I'm following the directions in the documenation for setting the root
password:
>mysql -u root mysql
mysql>UPDATE user
mysql>SET password=password('mynewpass')
my
At 22:00 01/12/01 +, Chris Withers wrote:
Hi,
I have a Win2000 machine and I would like to do a test with
your problem. Please can you send me more specify details
(definition table and SQL statements) so as I can build a
C/C++ client program for try to repeat the issue ?.
Regards,
Miguel
>H
Hi again, Sinisa...
Chris Withers wrote:
>
> Okay, table_cache increased from 64 to 256...
>
> > * check free disk space on all drives
Well, it got up to indexing 10,000 documents this time but then hung again. Now,
I don't know if this is because increasing the table_cache made a difference o
Hi Sinisa,
Sinisa Milivojevic wrote:
>
> There are several possibilities. You could be reaching some OS limits
> or haning user / group permission problems.
Don't think its permissions, since I had a similar process which ran fine, but I
had to change the schema to use the last insert id for ot
Chris Withers writes:
> Hi,
>
> I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables.
>
> I'm running an import process which inserts a big set of rows ('bout 27
> million), as part of a document indexing process. Each new row uses the
> AUTO_INCREMENT_ID from the previous
Hi,
I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables.
I'm running an import process which inserts a big set of rows ('bout 27
million), as part of a document indexing process. Each new row uses the
AUTO_INCREMENT_ID from the previous row. So, I have a loop which basica
Hi!
I am desperately trying to get the following combination to run:
MySQL (Win32 3.23.44) on host_1.something.tld
ColdFusion Enterprise 4.5.1 SP2 for Windows on host_2.something.tld
MyODBC 2.50.39 for NT/2000/XP on host_2.something.tld
The MySQL-DB ist hosting one database named TEST with one
I want to be able to define a user defined function in a Update query
eg Update Table Set MyField=MyFunction(TestField1,TestField2);
Where Myfunction tests 2 fields to return a result.
I am after a quick solution
Thanks
Dean
--
ki
>
>best wishes
>Chris
Regards,
Heikki
http://www.innodb.com
>-Original Message-
>From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
>Sent: Friday, October 26, 2001 8:24 AM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: Re: persistent shutdown of MySQL 3.23.42
27;m just trying to test it locally. But I'm
>getting ahead of myself here.
>
>I want to use the --DataDir option of mysqld-max-nt to look for the data
>in the F:\Apache Group\Apache\htdocs\data\ directory. Simple, right?
>Here's what happens:
>(BTW, this is a Win2k mach
Hi,
I have an application written in MS Access 2000 which has linked tables from
a MYSQL database.
I'm having a problem running queries which update the linked tables. I can
update individual records ok from Access, but as soon as i tried to run a
query, the query failes saying X number of recor
Hi all,
I've done a decent amount of searching on Deja.com but haven't found anyone
with this particular problem.
I have two boxes running MySql on Win2k. Replication works great. One box
is Master, one is Slave. After the boxes are running, any write to the
Master is replicated to
Michael,
Have a look at the thread "Can't get MySQL running on Win2K" (started by me) - I have
it working now (thanks Heikki!) and the solution might be of use to you as well.
At 08:27 2001-09-06 -0700, Michael Tam wrote:
>Hi all,
>
>I have uninstall mysql3.23.3
he
server on my web host.)
Thanks again - problem solved within one day!
At 17:25 2001-09-06 +0300, Heikki Tuuri wrote:
>>Date: Thu, 06 Sep 2001 17:24:21
>>To: Marjolein Katsma <[EMAIL PROTECTED]>
>>From: Heikki Tuuri <[EMAIL PROTECTED]>
>>Subject: Re:Can
the print
of the message errors when you start the server as standalone
and the last lines from mysql.err.
Regards,
Miguel
>Hi all,
>
> I have uninstall mysql3.23.39 from Win2k and after I install
>mysql3.23.41-max ... I was unable to run it as service. When I tried to
>start
Hi all,
I have uninstall mysql3.23.39 from Win2k and after I install
mysql3.23.41-max ... I was unable to run it as service. When I tried to
start the service I receive the following message ...
Could not start the MySql service on Local Computer
Error 1067: The process terminated
1 - 100 of 139 matches
Mail list logo