Author Topic: Mysql Replication  (Read 6328 times)

ober

  • Ashton Shagger
  • Ass Wipe
  • Posts: 14305
  • Karma: +73/-790
  • mini-ober is taking over
    • Windy Hill Web Solutions
Re: Mysql Replication
« Reply #15 on: August 08, 2013, 09:19:01 AM »
That basically said I need the 'show view' permission, which I have already granted:



Mike

  • Jackass In Charge
  • Posts: 11248
  • Karma: +168/-32
  • Ex Asshole - a better and more caring person.
Re: Mysql Replication
« Reply #16 on: August 08, 2013, 09:30:09 AM »
What does 'show grants' on the server actually show? (I've never really trusted cPanel).

ober

  • Ashton Shagger
  • Ass Wipe
  • Posts: 14305
  • Karma: +73/-790
  • mini-ober is taking over
    • Windy Hill Web Solutions
Re: Mysql Replication
« Reply #17 on: August 08, 2013, 01:19:38 PM »
Well... when I do that, the only user it shows is the cpanel user.  So maybe I need to use that user in the cron job instead of my other user that I setup specifically for those 2 DBs.

Mike

  • Jackass In Charge
  • Posts: 11248
  • Karma: +168/-32
  • Ex Asshole - a better and more caring person.
Re: Mysql Replication
« Reply #18 on: August 08, 2013, 01:21:57 PM »
'show grants' should show the permissions of the user you are connected as.  You can do 'show grants for user@host' but when debugging I like to connect as the user in question (since the host part isn't always obvious)