After installation can not start up.
Posted: Fri Feb 03, 2023 5:48 am
I have previously, a few years ago, developed a nubuilder database frontend, which worked fine and gave me no problems. Now I am trying it again, on the same database, but I can not get it working
The database development has started some 20+ years ago and for historical reasons contains both InnoDB (more recent tables) and also MyISAM (older tables). There are 100+ tables in the database.
This is the URL and the result message that I always get:
http://127.0.0.1/newric/index.php
Connection to the nuBuilder database failed: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
Verify and update the settings in nuconfig.php
Restart your browser after modifying nuconfig.php in order for changes to be reflecte
I used the user ‘root’ with password and without password.
And I also tried other names of users registered with the database and their passwords.
If I try to load a simple php test file, there is no problem.
Here follows the content of the nuconfig.php file:
$nuConfigDBHost = "127.0.0.1";(also tried localhost)
$nuConfigDBName = "newric";
$nuConfigDBUser = "root";
$nuConfigDBPassword = "";
$nuConfigDBEngine = "InnoDB"; //-- InnoDB or MyISAM
// Administrator Login:
$nuConfigDBGlobeadminUsername = "globeadmin"; $nuConfigDBGlobeadminPassword = "nu";
// Settings
$nuConfigSettingsFromDB = true;
//-- Use settings from setup->settings if set to true (default)
I have also tried other users fith all privileges and registered with the database.
The database table files are now set to
owner = root and group = mysql
Operating system is SUSE Linux version 15.4. fully updated.
Is the presence of both InnoDB and MyISAM tables the reason for the problem?
Access denied for user 'root'@'localhost' – why is there this access denied?
Any suggestions of help would be thankfully appreciated.
Egbert
The database development has started some 20+ years ago and for historical reasons contains both InnoDB (more recent tables) and also MyISAM (older tables). There are 100+ tables in the database.
This is the URL and the result message that I always get:
http://127.0.0.1/newric/index.php
Connection to the nuBuilder database failed: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
Verify and update the settings in nuconfig.php
Restart your browser after modifying nuconfig.php in order for changes to be reflecte
I used the user ‘root’ with password and without password.
And I also tried other names of users registered with the database and their passwords.
If I try to load a simple php test file, there is no problem.
Here follows the content of the nuconfig.php file:
$nuConfigDBHost = "127.0.0.1";(also tried localhost)
$nuConfigDBName = "newric";
$nuConfigDBUser = "root";
$nuConfigDBPassword = "";
$nuConfigDBEngine = "InnoDB"; //-- InnoDB or MyISAM
// Administrator Login:
$nuConfigDBGlobeadminUsername = "globeadmin"; $nuConfigDBGlobeadminPassword = "nu";
// Settings
$nuConfigSettingsFromDB = true;
//-- Use settings from setup->settings if set to true (default)
I have also tried other users fith all privileges and registered with the database.
The database table files are now set to
owner = root and group = mysql
Operating system is SUSE Linux version 15.4. fully updated.
Is the presence of both InnoDB and MyISAM tables the reason for the problem?
Access denied for user 'root'@'localhost' – why is there this access denied?
Any suggestions of help would be thankfully appreciated.
Egbert