Please paste the results of SELECT User, Host, Password FROM mysql.user when running as root...
Thanks! -jay On 03/08/2013 02:25 PM, Samuel Winchenbach wrote: > Here are my grants. I don't know if this helps, but I did verify that > the password was identical for each grant: http://paste2.org/p/3085361 > > > On Fri, Mar 8, 2013 at 2:17 PM, Samuel Winchenbach <swinc...@gmail.com > <mailto:swinc...@gmail.com>> wrote: > > root@test1:/var/log# mysql -hmysql-ha -unova > -p******************************** -e"SELECT User, Host, Password > FROM mysql.user;" > ERROR 1142 (42000) at line 1: SELECT command denied to user > 'nova'@'test1' for table 'user' > > > On Fri, Mar 8, 2013 at 2:06 PM, Jay Pipes <jaypi...@gmail.com > <mailto:jaypi...@gmail.com>> wrote: > > What does this show? > > mysql -hmysql-ha -unova -p<PASS> -e"SELECT User, Host, Password FROM > mysql.user" > > -jay > > On 03/08/2013 01:46 PM, Samuel Winchenbach wrote: > > Sorry, that must have been a copy and paste error. Here is what I > > actually ran: > > > > http://paste2.org/p/3084996 > > > > > > On Fri, Mar 8, 2013 at 12:40 PM, Jay Pipes <jaypi...@gmail.com > <mailto:jaypi...@gmail.com> > > <mailto:jaypi...@gmail.com <mailto:jaypi...@gmail.com>>> wrote: > > > > On 03/08/2013 12:19 PM, Samuel Winchenbach wrote: > > > Hi All, > > > > > > I have two nodes (test1 and test2) that I am trying to > set up in a > > > highly available configuration. > > > > > > During the setup process I tried running "nova-manage > service list" on > > > both nodes. It worked fine on test2, but fails on > test1 even > > though I > > > can connect to the database with the mysql client from > test1. > > > > > > Here is a screen capture that shows the setup on the two > nodes are > > > basically identical: http://paste2.org/p/3084223 > > > > In the above paste you are doing: > > > > mysql -unova - hmysql-ha -u root nova > > -p******************************** > > > > Note you are supplying 2 -u arguments, and mysql will take > the second > > (root). > > > > -jay > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~openstack > > Post to : openstack@lists.launchpad.net > <mailto:openstack@lists.launchpad.net> > > <mailto:openstack@lists.launchpad.net > <mailto:openstack@lists.launchpad.net>> > > Unsubscribe : https://launchpad.net/~openstack > > More help : https://help.launchpad.net/ListHelp > > > > > > > _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
