On 11/29/2010 08:46 AM, Grant wrote: >>> I'm told I need to run mysqld with --skip-grant-tables. I'm used to >>> using Gentoo's mysql initscript. Should 'mysqld --skip-grant-tables' >>> work? >> >> You can add it to /etc/mysql/my.cnf and restart. Remove it and restart again >> when you've finished. >> >> kashani > > That worked perfectly, thank you. > > I've run mysql_upgrade successfully and all of the warnings have > disappeared from the mysql log file except the following: > > [Warning] No argument was provided to --log-bin, and --log-bin-index > was not used; so replication may break when this MySQL server acts as > a master and has his hostname changed!! Please use > '--log-bin=mysqld-bin' to avoid this problem. > > Should I change the default 'log-bin' line in /etc/mysql/my.cnf to > 'log-bin = mysqld-bin'? > > - Grant >
Unless you're actually going to use replication, log-bin is essentially "crash-eventually = true". I would just comment it out.
