Error using multiple databases - JMS, multisite for joomla

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?

JMS, multisite for joomla

Joomla Multi Sites Version 1.2.x

Bugs, errors reporting

Error using multiple databases

(1 viewing) (1) Guest

Page: 12

TOPIC: Error using multiple databases

Forum Tools

#4370

Error using multiple databases 15 Years, 4 Months ago	Karma: -1
I have no problem creating slave sites, provided I am using the same database with different prefixes but when I try to creat a site using a different database I get errors when creating tables during the site install. Any ideas why. Im using MYsql 5 on Go Daddy.

eubotas

Fresh Boarder

Posts: 6

The administrator has disabled public write access.

#4379

Re: Error using multiple databases 15 Years, 4 Months ago	Karma: 55
Which is the error message ? Depending on the operation that you try to do, it is frequent that you have to use the same MySQL User. If you are using a shared hosting at GoDaddy, it is probable that you can not have a same MySQL User that can access several DB

edwin2win

Moderator

Posts: 5370

The administrator has disabled public write access.

#4499

Re:Error using multiple databases 15 Years, 4 Months ago Karma: 0

I have the same problem, I'm using the same userdb that the master.

I use cpanel hosting and this is the error that I have:

Code:

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_users AS SELECT * FROM `joomlazo_jo151`.`jos_users`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_users' SQL=CREATE OR REPLACE VIEW jos_users AS SELECT * FROM `joomlazo_jo151`.`jos_users`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_users` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_users` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH G
RANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_users AS SELECT * FROM `joomlazo_jo151`.`jos_users`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_users' SQL=CREATE OR REPLACE VIEW jos_users AS SELECT * FROM `joomlazo_jo151`.`jos_users`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_session AS SELECT * FROM `joomlazo_jo151`.`jos_session`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_session' SQL=CREATE OR REPLACE VIEW jos_session AS SELECT * FROM `joomlazo_jo151`.`jos_session`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_session` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_session` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH
 GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_session AS SELECT * FROM `joomlazo_jo151`.`jos_session`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_session' SQL=CREATE OR REPLACE VIEW jos_session AS SELECT * FROM `joomlazo_jo151`.`jos_session`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_core_acl_aro AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM'
 WITH GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_core_acl_aro AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_core_acl_aro_groups AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_groups`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_groups' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_groups AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_groups`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_groups` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_groups` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhF
MedDBM' WITH GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_core_acl_aro_groups AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_groups`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_groups' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_groups AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_groups`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_core_acl_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_map`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_map' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_map`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_map` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_map` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMed
DBM' WITH GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_core_acl_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_map`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_map' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_map`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_core_acl_aro_sections AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_sections`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_sections' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_sections AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_sections`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_sections` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_aro_sections` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCD
hFMedDBM' WITH GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_core_acl_aro_sections AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_sections`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_aro_sections' SQL=CREATE OR REPLACE VIEW jos_core_acl_aro_sections AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_aro_sections`

Error(1) [1142] query [CREATE OR REPLACE VIEW jos_core_acl_groups_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_groups_aro_map`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_groups_aro_map' SQL=CREATE OR REPLACE VIEW jos_core_acl_groups_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_groups_aro_map`

Create User error [1132]: Query = [GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_groups_aro_map` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'TjCDhFMedDBM' WITH GRANT OPTION;]
, DB Message = [You must have privileges to update tables in the mysql database to be able to change passwords for others SQL=GRANT ALL PRIVILEGES ON `joomlazo_jo151`.`jos_core_acl_groups_aro_map` TO `joomlazo_jo151`@`72.249.166.78` IDENTIFIED BY 'Tj
CDhFMedDBM' WITH GRANT OPTION;]

Error [1142] retrying query [CREATE OR REPLACE VIEW jos_core_acl_groups_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_groups_aro_map`]. DB Error:
 CREATE VIEW command denied to user 'joomlazo_jo151'@'localhost' for table 'jos_core_acl_groups_aro_map' SQL=CREATE OR REPLACE VIEW jos_core_acl_groups_aro_map AS SELECT * FROM `joomlazo_jo151`.`jos_core_acl_groups_aro_map`

trapezoid

Fresh Boarder

Posts: 3

The administrator has disabled public write access.

#4505

Re:Error using multiple databases 15 Years, 4 Months ago

Karma: 55

When you read the MySQL error message you have
"command denied to user"

When using cPanel, you have to increase the permission of the MySQL user to allow create and show view.
If you search in this forum, you will find plenty of times the same answer.

See also tutorial video 0.b slide 35 that show you the expect MySQL user privileges.
www.jms2win.com/tutorial#jms12x-0b

If you are using a share hosting, ask you hosting provider to increase the permission of your MySQL user

edwin2win

Moderator

Posts: 5370

The administrator has disabled public write access.

#4509

Re:Error using multiple databases 15 Years, 4 Months ago

Karma: 0

Sorry, but to send a post on a forum, is because I did all the tutorials as they say, the user data base, has all the permismos.

I'll give you a little more detail about the problem and see if I am the problem or is an error in the component.

When selects Templates: Master DB, everything works fine, but if I choose any other template, I get the error.

Note: the other templates are replicated Tempate Master DB.

trapezoid

Fresh Boarder

Posts: 3

The administrator has disabled public write access.

#4515

Re:Error using multiple databases 15 Years, 4 Months ago

Karma: 55

The error message "command denied to user" mean that you try to share an extension and the the MySQL user does not have the privilege to do that.

You are clearly noticed that you are using cPanel and I reply again to you that cPanel does NOT provide ALL privileges. This is false and you need to get ALL the privileges manually and request your hosting provider or administrator to give you more privileges or use the MySQL root login.

edwin2win

Moderator

Posts: 5370

The administrator has disabled public write access.

Page: 12

JMS, multisite for joomla

Joomla Multi Sites Version 1.2.x

Bugs, errors reporting

Top Menu

EU e-Privacy Directive

e-Shop

Company information