CREATE USER replication@'192.168.23.%'; CREATE USER backup@localhost; GRANT ALL ON *.* TO replication@'192.168.23.%' WITH GRANT OPTION; GRANT ALL ON *.* TO backup@localhost WITH GRANT OPTION; SET PASSWORD FOR replication@'192.168.23.%' = PASSWORD(''); SET PASSWORD FOR backup@localhost = PASSWORD('');