MySQL v5.5.12 on Mac OSX - Server won"t start...

--------------000408020401070301040309
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 ...
TIA
Rich

--------------000408020401070301040309--

Re: MySQL v5.5.12 on Mac OSX - Server won"t start...

--------------enig213E181F78381A36BA2E3905
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



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
>=20
> When I try and start the server I get these messages before it aborts..=

>=20
> 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=3D2 because fi=
le 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 m=
ysql_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 =3D 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=3Dutf8'
> 110514 17:16:20 [ERROR] Aborting
>=20
> 110514 17:16:20 InnoDB: Starting shutdown...
> 110514 17:16:21 InnoDB: Shutdown completed; log sequence number 159567=
5
> 110514 17:16:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
>=20
> 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=3Dutf8'
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

--=20

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


--------------enig213E181F78381A36BA2E3905
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3OqhcACgkQhmBjz394AnkNGQCfQjiNax7cY+RTVvSIhNhO KIm/
+vAAn2qBytPC7Etp2vOZLpK6B+qxB4ED
=TjVH
-----END PGP SIGNATURE-----

--------------enig213E181F78381A36BA2E3905--