Starting mysql

Reindl Harald h.reindl at
Sun Dec 11 21:12:51 UTC 2011

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

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 : 

More information about the devel mailing list