|
Re: database errors on creating new slave site 14 Years, 1 Month ago
|
Karma: 54
|
|
The PHPMyAdmin present in a cPanel never provide the "root" login because you don't have all the privileges. This is the reason why we have created this slide 35 to illustrate this case.
If you have a dedicated server with WHM and PHPMyAdmin present in this case you have the PHPMyAdmin with the root login and also the "privileges" menu available.
You can use this one to modify the privileges of your MySQL User.
If you don't have this PHMyAdmin to do it yourself, you have to contact your hosting provider and ask him to do it for you.
|
|
|
|
|
|
|
Re:database errors on creating new slave site 14 Years ago
|
Karma: 0
|
|
Today I contacted my host and was told that the user privileges for my main hosting account include the ones needed, so I should use it instead of a user created by the CPanel database management tool.
I did so, and all the errors disappeared. However, now in the joomla backend, my main hosting account username AND password is listed. This troubles me and I wonder if it could lead to problems in sites where people besides the main account holder have administrative access, and could them access the Cpanel themselves.
|
|
|
|
|
|
|
Re:database errors on creating new slave site 14 Years ago
|
Karma: 54
|
|
What do you mean by my main hosting account info is listed ?
Is this the login and password to access the master website ?
|
|
|
|
Last Edit: 2010/07/13 10:25 By edwin2win.
|
|
|
Re:database errors on creating new slave site 14 Years ago
|
Karma: 0
|
|
No, my account for CPanel! My host told me that was the account that has the privileges needed and that I should use it. Now my password to the entire CPanel is visible to anyone who can get into the backend (hopefully just me for this test).
|
|
|
|
Last Edit: 2010/07/13 12:25 By mlgrise.
|
|
|
Re:database errors on creating new slave site 14 Years ago
|
Karma: 0
|
|
I have the same database access problem, and have no Privileges access in phpMyAdmin. Setting multisites.cfg.php variable to my cpanel username and password simply results in a create user error (1044).
Is there a workaround to this?
(odd thing is I have successfully created slave site on the same host using the same method before - ie replicating a template to have a copied images and templates folder).
|
|
|
|
|
|
|
Re:database errors on creating new slave site 14 Years ago
|
Karma: 0
|
|
I have found the "workaround":
1. My master database has the prefix jml_ (kindly created by Simple Scripts). When I use the same prefix for the slave I get a permission error, so I used jos_ which worked fine
2. I cannot set user sharing to on, since then I get a long list of 'command denied to user' errors
(JFusion will have to solve the user sharing problem)
|
|
|
|
|
|
|
Forum
