Messages

1

CentOS 7 Problems / Re: Database not showing for users

« on: February 10, 2024, 09:58:25 PM »

Hi josemnunez

Ticket #351715

Thank you for looking into this issue

2

CentOS 7 Problems / Re: Database not showing for users

« on: February 08, 2024, 11:34:38 PM »

Just wondering maybe an update caused that but I haven't updated anything on this server.
I started to configure another server today. I will replace the one with issues on Sunday. I will check this file and let you know if I find anything

3

CentOS 7 Problems / Re: Database not showing for users

« on: February 07, 2024, 10:08:56 PM »

Hi  josemnunez

Thanks for the reply
I found the file mysql_user_prefix.conf
This file is empty. No content on it

4

CentOS 7 Problems / Re: Database not showing for users

« on: February 07, 2024, 05:04:07 AM »

Thank you for the reply.

I get this: Attention! An error occurred when listing databases.

On the user side, no databases. The only way to see it is from the PHPMyAdmin.

Thank you

5

CentOS 7 Problems / Database not showing for users

« on: February 06, 2024, 12:37:31 AM »

I build a new server on Dec 20 2023
Everything working good. No issues.

Around Jan 15 2024, I noticed that users were not able to see their database on the database manager on their panel.
The databases are there, because the websites work fine and I can see them in phpmyAdmin.

The following is the output of:
[root@app ~]# mysql -e "SELECT @@sql_mode;"
mysql: unknown variable 'sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[root@app ~]#

Anyone have had this issue and know how to solve it?
Thank you