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 |