MySQL Forums :: Utilities :: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'


Advanced Search

Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'
Posted by: Aaron Lager ()
Date: June 28, 2016 11:03AM

See the command below. This is a test setup, so root doesn't require a password when connecting from this server.

mysqlfailover --master=root@avc2-wus1-app13.local --slave=root@avc2-wus1-app14.local --log=failLog.txt --rpl-user=repl:password

I've made some local mods to the scripts following bug https://bugs.mysql.com/bug.php?id=81326
This in addition to my findings that replication.py also needed some love, and it now works.

Options: ReplyQuote


Subject Views Written By Posted
mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 1362 Aaron Lager 06/21/2016 12:49PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 522 Chuck Bell 06/23/2016 06:45AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 592 Aaron Lager 06/28/2016 11:03AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 597 Aaron Lager 06/29/2016 03:14PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 460 Chuck Bell 07/06/2016 04:05PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 482 Aaron Lager 07/06/2016 04:10PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 472 Aaron Lager 07/06/2016 04:12PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 457 Chuck Bell 07/11/2016 08:18AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 415 Chuck Bell 07/11/2016 08:20AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 421 Aaron Lager 06/29/2016 03:15PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 583 Aaron Lager 06/29/2016 03:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.