Gentoo Archives: gentoo-user

From: Grant <emailgrant@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Should mysql crash sometimes?
Date: Fri, 03 Dec 2010 20:14:37
Message-Id: AANLkTi=hOm-_sMgyVev_nqhK2ubevmQiXdnO0kJaoTdO@mail.gmail.com
In Reply to: Re: [gentoo-user] Should mysql crash sometimes? by Michael Orlitzky
1 >>>> I'm told I need to run mysqld with --skip-grant-tables.  I'm used to
2 >>>> using Gentoo's mysql initscript.  Should 'mysqld --skip-grant-tables'
3 >>>> work?
4 >>>
5 >>> You can add it to /etc/mysql/my.cnf and restart. Remove it and restart again
6 >>> when you've finished.
7 >>>
8 >>> kashani
9 >>
10 >> That worked perfectly, thank you.
11 >>
12 >> I've run mysql_upgrade successfully and all of the warnings have
13 >> disappeared from the mysql log file except the following:
14 >>
15 >> [Warning] No argument was provided to --log-bin, and --log-bin-index
16 >> was not used; so replication may break when this MySQL server acts as
17 >> a master and has his hostname changed!! Please use
18 >> '--log-bin=mysqld-bin' to avoid this problem.
19 >>
20 >> Should I change the default 'log-bin' line in /etc/mysql/my.cnf to
21 >> 'log-bin = mysqld-bin'?
22 >>
23 >> - Grant
24 >>
25 >
26 > Unless you're actually going to use replication, log-bin is essentially
27 > "crash-eventually = true".
28 >
29 > I would just comment it out.
30
31 Thanks, I've removed it.
32
33 - Grant