Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 18:16:30

Author Topic: MYSQL "problem creating new database"  (Read 21276 times)

0 Members and 2 Guests are viewing this topic.

Offline austinz

  • Junior Member
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
MYSQL "problem creating new database"
« 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)]

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: MYSQL "problem creating new database"
« Reply #1 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"

Offline austinz

  • Junior Member
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: MYSQL "problem creating new database"
« Reply #2 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 ?

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.065 seconds with 19 queries.

web stats analysis