database

  1. A

    phpMyAdmin - Internal Server Error 500

    Hi Team, I tried to access phpMyAdmin on VPS Server getting 500 Internal Server Error and also my all Created cron jobs are deleted from server.. I try to create new cron and then newly created cron automatically deleted., Please resolve this issue on high priority bacause we dont access last...
  2. plague

    SOLVED [CPANEL-29288] Non-Public Schemas in PostgreSQL Databases Do Not Restore

    Hello. Last week I had to move some server to new hardware and I noticed that postgres databases were transfered with empty data. The database was created in the new server, the user was created, but the database was totally empty. Data was lost. The transfer and restore log shows no error...
  3. Z

    MySQL Restore one account from Backup in WHM

    I currently have 'Entire MySql Directory' checked in my backup configuration. If I restore just one account, will only the databases from that account be restored, or will ALL databases from ALL the sites on the server be restored? Should I check 'per account only' instead? Or maybe per...
  4. A

    SOLVED MySql and PHP upgrade

    Hi I need to upgrade MySql and PHP on my servers. >>>>>>>>>>>>>>>>>>>>>>> Cpanel's documentation says 1) We strongly recommend that you back up your database before you upgrade your database or change to MariaDB. Is this backup a special backup or is this just the regular WHM backups...
  5. S

    Unable to authenticate using the password error

    I keep getting the error "The system was unable to authenticate using the password in the /root/.my.cnf file. Reset the root MySQL password to proceed." I have tried resetting the password. Still no luck I am getting this error as well
  6. G

    SOLVED Disable MySQL strict mode - CloudLinux + MySQL 5.7

    Hello, I have a problem with the STRICT_TRANS_TABLES and i want to disable it. I tried some fixed from this threds: Disable MySQL Strict Mode and Strict Mode Thred sql_mode="" sql_mode=NO_ENGINE_SUBSTITUTION...
  7. B

    VPS MySQL Optimization Needed

    Hello There. I have a vps that on paper should be very powerful but it is running very slow and the cpu is very high. Can someone help please thanks This is the spec Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz Speed 2199.998 MHz Cache 16384 KB 1.2TB SSD and 50gb ram These are my mycnf file...
  8. T

    Can't Connect to Remote MySQL Database

    Hey Guys, I'm new on this forum. Remote Mysql doesn't work anymore on my host, I tried with others host and it's the same problem. The host support told me that CPanel don't support remote Mysql anymore since the new Cpanel update. I whitelist my Ip and even all Ip with the % parameter, but the...
  9. P

    DBD::mysql has been removed during upgrade

    Hello everyone I've had a look round for an answer, but to be honest I'm completely stuck, so apologies in advance for being a noob. I look after the website for the Isle of Man Family History Society - a small group. The host is Manx Telecom and I've used cpanel to set up a SQL database...
  10. S

    Create new database for second website?

    hi 1st i want to tell i am not technical person just little knowledge about the things. my question is we have a free classified website in WordPress now we want to move in another platform we are going to design a customized website in PHP and want to move all data from existing website to new...
  11. M

    PHPMyAdmin User Side slow on cPanel 82.0.9

    Hi all I have a very strange problem accessing PhpMyAdmin from user side then via Cpanel user. Before version 82.0.9 was all ok, after the update the access to PhPMyAdmin in the user area of Panel is veeeery slow. The access from the WHM area, then the access with root rights, it's ok. I tried...
  12. PPNSteve

    Multiple errors (esp database related) on multi-account cPanel -to- cPanel transfers

    Seeing a large bunch of errors during account transfers from old to new server.. mainly can't find the DB user password and then not able to add user to db on new server.. Unable to detect a password set for “commuteb”@“%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80. Unable to...
  13. R

    Import large database

    - Removed - can you login to my cpanel or WHM to help import a database ? I'm not able to use SSH
  14. sahostking

    mysqldump all databases returns error

    mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES I googled it a bit and they state this happens with left over parts from mysql to mariadb upgrade which we did...
  15. M

    Maria 10.4 Support

    Any ETA when 10.4 will be supported as it's stable since one month ago
  16. D

    Granting account access to multiple databases

    I’m trying to share a database between two domains. I have two sites, let’s call them siteA and siteB. Each site has it’s own cpanel account (siteA_user and siteB_user) and each site has it’s own database (siteA_db and siteB_db) which reside on the same server. siteA is an interactive site...
  17. L

    Connection check error

    Hello friends I have received this message yesterday: [2019-07-31 21:17:01 -0300] E [/usr/local/cpanel/scripts/mysqlconnectioncheck] The “/usr/local/cpanel/scripts/mysqlconnectioncheck” command (process 4990) reported error number 1 when it ended. We are using for a long time MariaDB and not...
  18. S

    The service “mysql” appears to be down but it isn't down

    Hi there, I have 2 servers running with WHM/cPanel and with both I have the same problems. Whenever I must reboot my servers because of kernel updates I am notified that mysql appears to be down, but it isn't down. After long research I found what is caused by and found a solution for this...
  19. I

    Restoring backup leaves database

    Hi Regarding to WHM Backup Restoration, there is something strange when I restore a backup for any account. If there is an old backup includes (some files in File Manager, emails and there is no any databases) Today, I created a new database and changed some files & emails. When I try to...
  20. M

    Resellers have no access to MySQL / phpMyAdmin

    Hello guys! All right with you? I have a problem with my whm that I have hosted on Google Cloud. I am unable to enable user access on mysql. Only from WHM and with root user I can access phpMyAdmin. When I migrated from the old server to this WHM that I host on Google Cloud, I used the...