English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

Unable to create slave site using master database
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Unable to create slave site using master database
#6376
Unable to create slave site using master database 13 Years, 11 Months ago Karma: 0
Hi.. I have followed your video tutorial and i have done everything correct. When i try to create a slave site with same database its showing some errors.. Help me on this at the earlist

Error(1) [1142] query [CREATE OR REPLACE VIEW demo3_users AS SELECT * FROM `theprint_demo`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_users' SQL=CREATE OR REPLACE VIEW demo3_users AS SELECT * FROM `theprint_demo`.`jos_users`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_users` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'theprint_demo'@'localhost' for table 'jos_users' SQL=GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_users` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW demo3_users AS SELECT * FROM `theprint_demo`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_users' SQL=CREATE OR REPLACE VIEW demo3_users AS SELECT * FROM `theprint_demo`.`jos_users`
Error(1) [1142] query [CREATE OR REPLACE VIEW demo3_session AS SELECT * FROM `theprint_demo`.`jos_session`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_session' SQL=CREATE OR REPLACE VIEW demo3_session AS SELECT * FROM `theprint_demo`.`jos_session`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_session` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'theprint_demo'@'localhost' for table 'jos_session' SQL=GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_session` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW demo3_session AS SELECT * FROM `theprint_demo`.`jos_session`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_session' SQL=CREATE OR REPLACE VIEW demo3_session AS SELECT * FROM `theprint_demo`.`jos_session`
Error(1) [1142] query [CREATE OR REPLACE VIEW demo3_core_acl_aro AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_core_acl_aro' SQL=CREATE OR REPLACE VIEW demo3_core_acl_aro AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_core_acl_aro` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'theprint_demo'@'localhost' for table 'jos_core_acl_aro' SQL=GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_core_acl_aro` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW demo3_core_acl_aro AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_core_acl_aro' SQL=CREATE OR REPLACE VIEW demo3_core_acl_aro AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro`
Error(1) [1142] query [CREATE OR REPLACE VIEW demo3_core_acl_aro_groups AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro_groups`]. DB Error: CREATE VIEW command denied to user 'theprint_demo'@'localhost' for table 'demo3_core_acl_aro_groups' SQL=CREATE OR REPLACE VIEW demo3_core_acl_aro_groups AS SELECT * FROM `theprint_demo`.`jos_core_acl_aro_groups`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_core_acl_aro_groups` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'theprint_demo'@'localhost' for table 'jos_core_acl_aro_groups' SQL=GRANT ALL PRIVILEGES ON `theprint_demo`.`jos_core_acl_aro_groups` TO `theprint_demo`@`109.75.171.82` IDENTIFIED BY 'demo1234' WITH GRANT OPTION;]
lsampathl
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6380
Re: Unable to create slave site using master database 13 Years, 11 Months ago Karma: 54
As you will read plenty of times in this forum the error "command denied to user" means that you don't have a MySQL user that has the permission to share mySQL table (create or show views)
So update the privilege of the MySQL user that you are using for that.
See also the tutorial video 0.b slide 35 that show how to add the create and show view with a PHPMyAdmin and the root login.
www.jms2win.com/en/tutorial#jms12x-0b

If you are using shared hosting, contact your hosting provider to ask him increase your MySQL user privileges?
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
Last Edit: 2011/01/25 18:55 By edwin2win.
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla