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. 2020-12-03, 04:50:02

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

0 Members and 1 Guest 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: 414
  • 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 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.044 seconds with 22 queries.

web stats analysis