mysql

I have recently install a Plesk web admin to use for my websites in the near future but my website requires to set a custom Max_allowed_packet size for MySQL which I can do with Apache and cPanel. I am still new to Plesk, how can I set max_allowed_packet size for MySQL in Plesk?

GPDHost submitted a new resource: US Based Data Center | Unlimited MYSQL Database | Multiple PHP Version | Built-In Cloudflare - US Based Data Center | Unlimited MYSQL Database | Multiple PHP Version | Built-In Cloudflare Read more about this resource...

From what I know, aside from DDoS, the most common kind of website attacks are due to the execution of custom MySQL injected code. All areas where you can input data and are directly connected to a website's database are potentially exploitable through such code... unless they're properly...

Can any one tell me what is the difference between Mariadb and Mysql? which one should I use to have fast queries for my website?

In my config file of my website cms, it decaled this variable $config['Database']['dbtype'] = 'mysqli'; and on old version $config['Database']['dbtype'] = 'mysql'; Which should I use? why? Can you tell me what is the difference between mysqli and mysql? which one is right for you? thanks...

What are the best ways to check my current version of MySQL on my cPanel server and upgrade it or reinstall it? I have root access but I am not sure what commands do I need to use for this task?

I follow this tutorial https://forumweb.hosting/13091-how-to-install-vesta-control-panel-on-your-vps-server.html and installed successfully VestaCP on my hosting but after done, I don't know how to login to Mysql using root account, where is VestaCP MySQL root password? Can any one tell me how...

MySQL master slave replication gives you two copies of your database: the live” one and the backup one. You always write your data to your master and read from the master too, but you will always have an up-to-date copy on your slave. Setting up the master Server Make sure you have...

So I have a dedicated server that was running just fine, but now I updated from Easyapache 3 to 4 and now any php site, wordpress, magento etc. uses like 25% cpu whenever a site is accessed. Does anyone have any idea what to look at or how to fix?

Hi I have just installed a PHPbb forum on my Ubuntu hosting but I am not sure whether I have installed the correct version of PHP and MySQL for it. Is there a way to check from a command line? Thanks a lot!

How can I disable MySQL strict mode in WHM/cPanel or do I have to do so via ssh? I want to disables this to make a couple of applications work properly. How can I do that?

Sometimes my MySQL is crashed and I would reinstall it or upgrade it to a higher version. If the option for reinstalling mysql is not possible, I would know how to reset the mysql installation, that can fix any issues on Mysql that i am facing now.

Are there any methods to set the notification when Apache or Mysql sever is down. I want to have email notifications when services are down / crash, can we set any notification in plesk, directadmin or cpanel hosting panel?

I am using MySQL on my hosting and after a check on the folder /var/lib/mysql and I realized that the ibdata file size is increasing rapidly, over 300MB, I don't know which causes this, can I purge ibdata1 file content or recreate it with a empty file?

I have a large MySQL database file, around 1GB of data, I want to split into multi files and importing them into a database in my hosting. is It possible? is there a tool/way to do this task?

I am trying to set up MySQL access for a remote IP. I have to grante mysql user all privileges for database in cPanel and I have set up to be allowed access for that IP in WHM and cPanel remote access? For some reason its not connecting at all. Any help with detailed steps?

I have just got a new VPS and I want to install LEMP stack on CentOS 7. Can some of you here share any tips for me to get started?

Is there a way to config Mysql root user to allow me log into Mysql console without typing a password? I feel tired when I have to type mysql root password to login Mysql consolve each time, sometime I don't remember the password or changed hosting server and I must to find where it is set...

If you are using MySQL version v5.6, you can do changes in your file my.cnf on your VPS to aneb enable Slow Query Log for your MySQL. In order to enable this for MySQL on your VPS or hosting servers, you should do as follows Open my.cnf nano /etc/my.cnf When you opened your my.cnf file...

uniwebhosting submitted a new resource: Free Web Hosting - cPanel , softaculous, mysql, email. - Free Web Hosting - cPanel , softaculous, mysql, email. Read more about this resource...