Am 14.05.2011 17:32, schrieb rich gray: > I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 > > When I try and start the server I get these messages before it aborts... > > 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from > /usr/local/mysql/data > 110514 17:16:16 [Warning] The syntax '--log-slow-queries' is deprecated and > will be removed in a future release. > Please use '--slow-query-log'/'--slow-query-log-file' instead. > 110514 17:16:17 [Warning] Setting lower_case_table_names=2 because file > system for /usr/local/mysql/data/ is case > insensitive > 110514 17:16:17 [Note] Plugin 'FEDERATED' is disabled. > /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist > 110514 17:16:17 [ERROR] Can't open the mysql.plugin table. Please run > mysql_upgrade to create it. > 110514 17:16:17 InnoDB: The InnoDB memory heap is disabled > 110514 17:16:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 110514 17:16:17 InnoDB: Compressed tables use zlib 1.2.3 > 110514 17:16:17 InnoDB: Initializing buffer pool, size = 128.0M > 110514 17:16:17 InnoDB: Completed initialization of buffer pool > 110514 17:16:17 InnoDB: highest supported file format is Barracuda. > 110514 17:16:19 InnoDB: Waiting for the background threads to start > 110514 17:16:20 InnoDB: 1.1.6 started; log sequence number 1595675 > 110514 17:16:20 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable > 'default-character-set=utf8' > 110514 17:16:20 [ERROR] Aborting > > 110514 17:16:20 InnoDB: Starting shutdown... > 110514 17:16:21 InnoDB: Shutdown completed; log sequence number 1595675 > 110514 17:16:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete > > 110514 17:16:21 mysqld_safe mysqld from pid file > /usr/local/mysql/data/xxxxxxxxx.local.pid ended > Anybody point me towards where I can get this issue sorted... Googling didnt > turn up much ...
what about reading the line with error :-) [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' this is deprecated long ago and with 5.5 no longer supported replace charset/collation default in my.cnf by * character-set-server * collation-server -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature