List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 14 2011 4:13pm
Subject:Re: MySQL v5.5.12 on Mac OSX - Server won't start...
View as plain text  

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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
MySQL v5.5.12 on Mac OSX - Server won't start...rich gray14 May
  • Re: MySQL v5.5.12 on Mac OSX - Server won't start...Reindl Harald14 May