MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: austinz on 2020-01-22, 16:09:52

Title: MYSQL "problem creating new database"
Post by: austinz on 2020-01-22, 16:09:52
Good day , am having you creating new database details.

the below is the error message while trying to add or create new mysql database in MYSQL DATABASES   section

Alert: Could not connect to DB [Access denied for user 'root'@'localhost' (using password: YES)]
Title: Re: MYSQL "problem creating new database"
Post by: azzureal on 2020-01-23, 03:35:43
try sh /script/reset-mysql-root-password your password.

if fail,

please make .my.cnf in your root folder

insert


[client]
user="root"
pass="your password"
Title: Re: MYSQL "problem creating new database"
Post by: austinz on 2020-01-30, 10:14:47
Thanks for your response, but i reinstall my vps server and install a new kloxo mr before your respond came.

The issue now is that after restoring from backup , on the newly installed Kloxo mr on Cent OS 7 X86_64, every other things Restored successfully but database table could not be restore , rather only the database names were restore.

Meanwhile this particular backup was previously restored successfully before re-installing the Kloxo mr. 

Do you have an ideal on how to get this solve ?