Mr. X. wrote:

You have crossposted to five newsgroups. A lot of people will have
newsreaders set to ignore such widely crossposted messages. Your
question is about MySQL not about Java. I recommend you pick one
newsgroup only - say comp.databases.mysql I've set followups there (bye).


I guess the name of the program to be executed should not include
parameters. There's probably somewhere else you should add those. I
don't think you should be fiddling with Registry settings directly. I'm
sure MySQL includes some configuration tools that you should use instead.

"Both mysqld and configure verify that the character set/collation
combination is valid. If not, each program displays an error message and
terminates." -- MySQL reference manual.

1) I doubt "Hebrew" is a valid character set name. You might want
something like ISO 8859-8.

2) I don't see why you want to change it from "utf8" - which supports
Hebrew characters.

--
RGB

Yes,
I suppose utf8 is better,
but when I run the mysqld-nt.exe on windows' services I got the error,
and on command line I don't got the error (on utf8, of course),
as I have mentioned.

How can I use the mysqld-nt on windows' service ?

Thanks

Well,
Right - I won't crosspost to several newsgroups,
(but it seems that I don't have got answers for my questions, for days ....
look at my question at 2/5).

O.K.
I guested too that MySql has a configuration tool,
but where is it ?

Thanks

On Mon, 5 May 2008 09:04:31 +0300, Mr. X. wrote:
You mean OTHER than MySQL Adminstrator?

http://www.mysql.com/products/administrator/

--
3. My noble half-brother whose throne I usurped will be killed, not kept
anonymously imprisoned in a forgotten cell of my dungeon.
--Peter Anspach's list of things to do as an Evil Overlord

Seems to be good.

1. I have just run MySQLAdministrator.exe.
First time it asked me for password.
I put the user + password correctly (port 3306 - where is the port ?).
but I have got the error : "could not find settings. Either the server
service or the
configuration file could not be found ..."
2. I didn't see a way changing the default character-set (I can only view
it)/
3. I suppose something like I have first said (main question !!!)
"C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt.exe" --character-set-server=utf8"
.... Well, I cannot start the service that way, and I don't know what exactly
I should put on registry, but on command line there is no problem.
(I can run from command line, but I preffer running from service).

4. Is there any tutorial for MySQLAdministrator.exe ?

Thanks