Starting mysql

[Reindl Harald]

Am 11.12.2011 22:02, schrieb Paul F. Johnson:
> Hi,
> 
>> Did you initialize databases as suggested (mysql_install_db) ?
> 
> Yep - gave me this
> 
> [root at PB3 paul]# mysql_install_db
> Installing MySQL system tables...
> 111211 21:00:37 [ERROR] Incorrect definition of table mysql.proc:
> expected column 'comment' at position 15 to have type text, found type
> char(64).
> ERROR: 1136  Column count doesn't match value count at row 1
> 111211 21:00:38 [ERROR] Aborting
> 
> 111211 21:00:38 [Note] /usr/libexec/mysqld: Shutdown complete

sounds like this is not a fresh install

people should be advised to call "mysql_upgrade -u root -p" after
EACH minor update to avoid such issues over the long

use this to start mysqld without permissions-system but make sure
it is not reachable for clients as long it is running without priv

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-grant-tables

after mysqld si running use "mysql_upgrade -u" (you do not need a password at this point)
and after that REMOVE skip-grant from your config and restart the service a last time
to active privilege control


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
Url : http://lists.fedoraproject.org/pipermail/devel/attachments/20111211/ecdf258a/attachment-0001.bin