Author Topic: Mysql problem after migration  (Read 3162 times)

0 Members and 2 Guests are viewing this topic.

Offline
*
Mysql problem after migration
« on: December 21, 2021, 04:11:05 PM »
Hi, Imported mysql accounts users still hold old IP addresses and when I try to save new IP, it says Invalid user.

When I open phpmyadmin, it throws this error:


mysqli::real_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)


Offline
*
Re: Mysql problem after migration
« Reply #1 on: December 21, 2021, 05:44:29 PM »
You need to create respective users for respective databases in
Code: [Select]
Sql Services > Mysql manager
Applications Developer | RHEL Linux Server Administrator

Reach out to me in pm to solve any application deployment such as NodeJS, Java, PHP etc


Managed 40gb Shared CWP PRO Hosting for $20 p/a offer
Managed 60gb Shared CWP PRO Hosting for $40 p/a offer
Managed 100gb Shared CWP PRO Hosting for $60 p/a offer
Managed 200gb Shared CWP PRO Hosting for $120 p/a offer


CentOS 8 died a premature death at the end of 2021 - migrate to RockyLinux Os.

Offline
*
Re: Mysql problem after migration
« Reply #2 on: December 22, 2021, 05:07:27 AM »
Ok, But it would be nice if they were picked from the cpanel migration.

Offline
*
Re: Mysql problem after migration
« Reply #3 on: December 22, 2021, 05:09:31 AM »
Although I got the pro version, these little things will make me go back very soon.   :'(