As @Rick suggested in the question comments. We need to grant all the permissions, procName expects. In my case, procName Creates and Deletes temporary tables. So, granting CREATE TEMPORARY TABLES permissions on dbName.* did the trick
If the esg
user was already used for replication, you shouldn't need to grant privileges again. Login to the master server with he esg user, and execute show grants
. This will confirm whether or not the esg user has REPLICATION SLAVE
privilege.
If you don't already have it, get the root password set to something you know. That will be helpful for troubleshooting and setup/resync.
If you are unsure of the replication state, execute SHOW SLAVE STATUS
and check the fields SLAVE_SQL_Running
and SLAVE_IO_Running
. If either of those are NO
, then check the status for Error messages and #'s. If Replication is down, then that may be a cause of missing data.
If your SLAVE threads are running, check Seconds_Behind_Master
. If that is not 0 (or something relatively close to 0), then your slave is behind, and that could be the missing data.
If the slave is up to date, and your missing some data, another possible cause is that another user with write privileges accidentally inserted/updated/deleted on the Slave instead of the master. Yes, this does happen.
Another possibility is data inconsistency from using Statement Based Replication, as opposed to Row Based Replication. Check show global variable like 'bingo_format'
to determine if you're using statement or row based replication.
Beyond that, you might need to break your question down a bit more to understand what you're doing (rebuilding rep, vs restarting) and focusing in on one piece at a time.
Best Answer
The hostname component is the reference to the remote address of the connection. See create user.
Recommend keeping this constrained to a subnet.
Domain based grants while they look good, need reverse DNS setup to resolve this to an IP before allowing a connection. I recommend avoid them and using skip-name-resolve as a configuration option for extra speed and reliability.