Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

replication and grants

Status
Not open for further replies.
msteder

msteder

Technical User
Jan 30, 2003
72
US
I have setup a master/slave scenario.

The mysql database from my master is replicating to the slave.

I have user "test" setup with select priv to "mysql" db from host "localhost" and "%" in the mysql.db and mysql.user tables.

I can connect from slave to master with user test and do a select, but I cannot connect from master to slave.

From MASTER> mysql -h SLAVE -u test mysql
ERROR 1044: Access denied for user: '@MASTER' to database 'mysql'

Any ideas?
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
416
penguinspeaks
penguinspeaks
soushi01
  • Locked
  • Question
MySQL replication slave server re-sync issue
Replies
0
Views
234
soushi01
soushi01
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
392
EdLentz
EdLentz
Yossi Nixon
  • Locked
  • Question
MySQL CPU usage and CPU wait
Replies
1
Views
127
feherke
feherke
jyothi12389
  • Locked
  • Question
create a schedule and MYSQL loading csv data to table
Replies
0
Views
104
jyothi12389
jyothi12389

Part and Inventory Search

Sponsor

Back
Top