database

I'm seeing some PHP errors on one of my web sites. The coding guys are telling me that my server doesn't support MYSQL time zones. The server time is correct, and I can see its configured for the correct time zone. Do I need to enable something in MySql ?

Hello guys, I was searching in the last 2 days to convert all my innodb tables,databases to myisam because is the secand time i have problems witch innodb and i`m not able to fix the tables/databases, so i whant to stop using innodb at all for the entire server. I didnt found nothink clearly...

Hello guys, I upgrade MariaDB 10.1 to 10.3 and since i made this update i get " Error establishing a database connection " on some websites but lots of them. on the tail -f /var/lib/mysql/....hostname.err i dont have any errors at all, only this ones 2019-09-11 9:35:19 3051 [Warning] Access...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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

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...

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

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...

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...