Re: Starting mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@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


Attachment: signature.asc
Description: OpenPGP digital signature

-- 
devel mailing list
devel@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/devel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Fedora Announce]     [Fedora Kernel]     [Fedora Testing]     [Fedora Formulas]     [Fedora PHP Devel]     [Kernel Development]     [Fedora Legacy]     [Fedora Maintainers]     [Fedora Desktop]     [PAM]     [Red Hat Development]     [Gimp]     [Yosemite News]
  Powered by Linux