>>>> 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.
Thanks, I've removed it. - Grant
