X-Spam-Check-By: sourceware.org
MIME-Version: 1.0
Date: Wed, 3 May 2006 16:07:43 +0200
From: Jean-Philippe Braun <eon AT patapon DOT info>
To: cygwin AT cygwin DOT com
Subject: Problems getting mysql server working
Reply-To: eon AT patapon DOT info
Message-ID: <bd85182822837e773fe0d630371bab9a@localhost>
X-Sender: eon AT patapon DOT info
User-Agent: RoundCube Webmail/0.1b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

Hello,

I'm trying to run a mysql server (I've test 4.1.18 and 5.0.19) on windows 2000 with cygwin. It compile fine (./configure; make; make install) but when I install the databases I get lots of errors :

$ mysql_install_db
Installing all prepared tables
060503 16:01:32 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/ is case insensitive
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/help_topic.frm'
ERROR: 1033  Incorrect information in file: './mysql/help_topic.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/help_category.frm'
ERROR: 1033  Incorrect information in file: './mysql/help_category.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/help_relation.frm'
ERROR: 1033  Incorrect information in file: './mysql/help_relation.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/help_keyword.frm'
ERROR: 1033  Incorrect information in file: './mysql/help_keyword.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/time_zone_name.frm'
ERROR: 1033  Incorrect information in file: './mysql/time_zone_name.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/time_zone.frm'
ERROR: 1033  Incorrect information in file: './mysql/time_zone.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/time_zone_transition.frm'
ERROR: 1033  Incorrect information in file: './mysql/time_zone_transition.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/time_zone_transition_type.frm'
ERROR: 1033  Incorrect information in file: './mysql/time_zone_transition_type.frm'
060503 16:01:32 [ERROR] /usr/local/libexec/mysqld: Incorrect information in file: './mysql/time_zone_leap_second.frm'
ERROR: 1033  Incorrect information in file: './mysql/time_zone_leap_second.frm'
Fill help tables
060503 16:01:32 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/ is case insensitive
ERROR: 1146  Table 'mysql.help_topic' doesn't exist
ERROR: 1146  Table 'mysql.help_category' doesn't exist
ERROR: 1146  Table 'mysql.help_keyword' doesn't exist
ERROR: 1146  Table 'mysql.help_relation' doesn't exist
ERROR: 1146  Table 'mysql.help_category' doesn't exist
...
ERROR: 1146  Table 'mysql.help_relation' doesn't exist

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h idel_xp_cyril password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com


I have read the archives, try to set a user mysql, login as admin or user... but I don't find any solution.

Thanks for your help

-- 
Jean-Philippe Braun



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/