This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Problems getting mysql server working


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/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]