Hi,
Concerning DEFINER and latest test DB from the link.
So in standard nubuilder4.sql (latest or in any other before) DEFINER is not present in the file.
on tested sql from the latest post: the DEFINER is used like: DEFINER=`root`@`localhost`
in my case in nuconfig.php I do not use
root so it does not work now and I have an error:
Code: Select all
#1227 - Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation
(just for info - it's not a problem specifically for me)
SO the best - in my case - would be NOT to use DEFINER in the initial sql file (I mean to keep current nubuilder4.sql structure)
Historically 2 years ago I was afraid to place root data to the nuconfig.php so I started to use globeadmin instead and I am continuing with it with no issue at all:
Code: Select all
$nuConfigDBHost = "127.0.0.1";
$nuConfigDBName = "nubuilder4";
$nuConfigDBUser = "globeadmin";
$nuConfigDBPassword = ".........";
$nuConfigDBGlobeadminUsername = "globeadmin"; //-- globeadmin username
$nuConfigDBGlobeadminPassword = ".........."; //-- globeadmin password
$nuConfigTitle = "nuBuilder 4";
$nuConfigIsDemo = false;
I use several instances of databases and to make some differences I use different globeadmin names for different DBs like: globeadmin1, globeadmin2, globeadmin3,
(And it prevents as well form mistakes if you switch between them)
AND to be able to import DB form one to the other first in the .sql file I have to modify the globeadmin name for example from globeadmin2 to globeadmin3. Without that I would have:
Code: Select all
#1227 - Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation
(on linux the change of the name is not painfull at all - just one simple script with:)
Code: Select all
sed -i 's/globeadmin/globeadmin5/g' /root/temp/TestDBtemp.sql
I was testing in the past similar setup on one commerially predifined server with mysql (no root access) - and in basic cofiguration it was working fine - but some options were blocked like events for example - and thats why it was just test only - (they are not willing to make any deviation from standard - and just told me if you need something different you need to go for VPS)
Additional isssue is usage of phpmyadmin - I had bad experience with importing DB's - at least in the past there was limitation of file of 2MB if I well rememeber. So initially works fine until the files are small but one day you can have big problem not be able to import your backup for example - thats why I switch to standard command line MariaDB utility for import/export.