From: Reindl Harald
Date: May 14 2011 4:13pm
Subject: Re: MySQL v5.5.12 on Mac OSX - Server won't start...
List-Archive: http://lists.mysql.com/mysql/225008
Message-Id: <4DCEAA17.2000704@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig213E181F78381A36BA2E3905"

--------------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..=
=2E
>=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=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 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+RTVvSIhNhOKIm/
+vAAn2qBytPC7Etp2vOZLpK6B+qxB4ED
=TjVH
-----END PGP SIGNATURE-----

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