i am trying it as per your instructions per our previous disscussion..
but it's not just happening.
Here is the error i am recieving.
| Code: |
Error(1) [1142] query [CREATE OR REPLACE VIEW lvg_users AS SELECT * FROM `loc1005710480816`.`jos_users`]. DB Error: ANY command denied to user 'loclasvg'@'%
' for table 'jos_users' SQL=CREATE OR REPLACE VIEW lvg_users AS SELECT * FROM `loc1005710480816`.`jos_users`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `loc1005710480816`.`jos_users` TO `loclasvg`@`173.201.93.246` IDENTIFIED BY 'password' WITH GRANT OPTION;]
, DB Message = [GRANT,REFERENCES command denied to user 'loc1005710480816'@'97.74.24.182' for table 'jos_users' SQL=GRANT ALL PRIVILEGES ON `loc1005710480816`.`jos_users` TO `loclasvg`@`173.201.93.246` IDENTIFIED BY 'password' WITH GRANT OPTION;]
|
for above: jos_ is the base site tables.
lvg_ is the new site table for which i am trying to replicate.
loc1005710480816 is the main site DB.
loclasvg is the new site DB.
Forum
