Dev {Tricks}

  • Home
  • WordPress
  • OJS
  • Oxwall
  • Server and Hosting
You are here: Home / Archives for Server and Hosting / Web Control Panel / Plesk

September 14, 2023 by dev

MySQL: Error Code: 1118

  • #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Change limit for “Mysql Row size too large”
  • Row size too large 8126 Changing some columns
  • 1118 Row size too large

The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Solution
  • Login to phpMyAdmin with root previllege
  • Go to Variables
  • Then edit Innodb Strict Mode as follows
    innodb_strict_mode = 0

 

Filed Under: aaPanel, Almalinux, AWS, Bluehost, CentOS, CentOS Web Panel, Cloudcone, Contabo, cPanel, CyberPanel, Debian, Digitalocean, DirectAdmin, Error and Fix, HostGator, How to, ISPConfig, KeyHelp, Linux Distribusion, MySQL, Plesk, Server and Hosting, Ubuntu, VPS Management, VPSDime, Webmin, WHM Tagged With: innodb strict mode, mysql row size

July 30, 2023 by dev

How To Create a New User and Grant Permissions in MySQL

Access MariaDB Server

mysql -u root -p

Create new database

CREATE DATABASE bdhostidb;

Check whether the database created

SHOW DATABASES;



GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;

Filed Under: aaPanel, Almalinux, AWS, Bluehost, CentOS, CentOS Web Panel, Cloudcone, Contabo, cPanel, CyberPanel, Debian, Digitalocean, DirectAdmin, HostGator, ISPConfig, KeyHelp, Linux Distribusion, MySQL, Plesk, Providers, Server and Hosting, Ubuntu, VPS Management, VPSDime, Web Control Panel, Webmin, WHM

March 25, 2023 by dev

MariaDB Upgrade to the new version | Plesk – CentOS 7 / RHEL 7

  • For CWP and CentOS 7
    MariaDB Upgrade to the new version | CWP 

By default, CentOS 7 is shipped with MariaDB 5.5. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7.

Automatic method

Note: The script below is applicable only for upgrading default MariaDB 5.5 to the MariaDB 10.5 version, for other cases apply the steps from the Manual Method section. Make sure Obsidian 18.0.30 or later is installed on the server.

  1. Download the attached script and provide it with executable rights:
    wget https://raw.githubusercontent.com/plesk/kb-scripts/master/c7-mariadb-10-5-upgrade/c7-mariadb-10-5-upgrade.sh && chmod +x c7-mariadb-10-5-upgrade.sh
  2. Execute the script via CLI:
    ./c7-mariadb-10-5-upgrade.sh

 

Filed Under: Plesk, Server and Hosting, VPS Management

February 26, 2023 by dev

How to Clean the YUM Cache in CentOS

We need to clean the YUM cache to reclaim the disk space used or to fix some errors due to corrupted metadata files.

  • Clean all the cached packages from the enabled repository cache directory.
    yum clean packages
  • Delete package headers.
    yum clean headers
  • Delete metadata for each enabled repository.
    yum clean metadata
  • Clean database cache
    
    yum clean dbcache
  • Clean expire cache
    
    yum clean expire-cache
  • Clean all cached information.
    yum clean all

Done!

Filed Under: AWS, Bluehost, CentOS Web Panel, Cloudcone, Contabo, cPanel, Digitalocean, DirectAdmin, HostGator, ISPConfig, Plesk, Providers, Server and Hosting, VPS Management, VPSDime, Web Control Panel, Webmin, WHM Tagged With: cache, centos cache, clean yum, yam cache, YUM Cache

February 26, 2023 by dev

How to run php file through command line? How do I enable PHP?

For Windows, make sure you have PHP installed and type this into command prompt:

C:\Path\To\php.exe C:\Path\To\Your\script.php

And for Linux/Unix:

php /path/to/script.php
How do I enable PHP in Plesk?
  • Go to Tools & Settings > Updates to start the Plesk Installer.
  • Click Add/Remove Components, expand the Web hosting section, and
  • Then the PHP interpreter versions section.
  • PHP from OS vendor (install)

Filed Under: AWS, Bluehost, CentOS Web Panel, Cloudcone, Contabo, cPanel, Digitalocean, DirectAdmin, HostGator, How to, Plesk, Server and Hosting, VPS Management, VPSDime, Web Control Panel

  • 1
  • 2
  • 3
  • …
  • 5
  • Next Page »
  • Upwork
  • Freelancer
  • Fiverr
  • Guru
  • PPH

Recent Posts

  • How to Install cPanel/WHM on Ubuntu 20.04
  • MySQL: Error Code: 1118
  • Install office 365 with free lifetime license
  • Download and Install Office 2021 from Microsoft | Free | Genuine Version
  • Google Scholar Indexing | PKP Docs
  • How to change the SSH port | WHM
  • aaPanel Error and Solutions
  • How To Create a New User and Grant Permissions in MySQL
  • aaPanel Security Risk and Solution
  • aaPanel Management script
  • KeyHelp server control panel
  • Protected: MultiSaaS – Multi-Tenancy Multipurpose Website Builder (SaaS)
  • How to install aaPanel web hosting control panel on CentOS 7 or Ubuntu or Debian
  • How to Change MySQL Root Password in Ubuntu 22.04
  • How to test Laravel Email is functioning.
  • How to set up Hestia on Ubuntu 20.04 LTS & 22.04 LTS
  • How to Reset Laravel Admin Password directly from the Database
  • How to create su user on Linux
  • How to install CyberPanel
  • How to Reset Laravel Admin Password directly at phpMyAdmin

Categories

  • Affiliate Marketing (1)
  • Customization (3)
    • CSS (1)
  • Email Solutions (21)
    • FrontApp (1)
    • Google Spreadsheet (2)
    • Microsoft Outlook (1)
    • PHP Email Form (3)
    • PolyMail (1)
    • Recaptcha (1)
    • Roundcube (3)
    • Thunderbird (2)
    • WebMail (4)
  • Games (1)
  • How to (81)
  • Joomla (6)
    • Akeeba (1)
    • Fix & Tricks (3)
  • jQuery (3)
  • jQuery Plugins (4)
    • BX Slider (1)
    • Slick (1)
  • Laravel (4)
  • Marketplace (5)
  • Miscellaneous (28)
  • MultiSaaS (1)
  • OJS (53)
    • Help (35)
    • Installation (9)
      • Issues (5)
    • Plugins (7)
    • Scholar Indexing (1)
    • Theme (6)
      • Templates (6)
        • Frontend (5)
        • legacy (1)
    • Theme Customization (9)
    • Theme Development (13)
    • TPL CSS JS (2)
    • Upgrade (11)
  • Oxwall (3)
  • Payment Methods (1)
    • Paypal (1)
  • PC Tips and Tricks (13)
    • MS Office (2)
      • PowerPoint (1)
    • Windows (3)
  • PHP Parse error (2)
  • phpBB (2)
  • Server and Hosting (194)
    • Billing and Management (10)
      • Blesta (5)
      • Boxbilling (2)
      • WHMCS (5)
    • Email (9)
      • Postfix (3)
    • Error and Fix (17)
    • FTP (2)
    • Linux Distribusion (16)
      • Almalinux (5)
      • CentOS (5)
      • Debian (11)
      • Ubuntu (9)
    • Mail Server Solusion (7)
      • iRedMain (6)
    • MySQL (12)
    • Providers (59)
      • AWS (28)
      • Bluehost (28)
      • Cloudcone (17)
      • Contabo (31)
      • Digitalocean (59)
      • HostGator (27)
      • RackNerd (1)
      • VPSDime (29)
    • Security (19)
      • SSH (7)
    • VPS Management (66)
    • Web Control Panel (136)
      • aaPanel (6)
      • CentOS Web Panel (39)
      • cPanel (29)
      • CyberPanel (3)
      • DirectAdmin (92)
        • Find & fix (38)
      • ISPConfig (13)
      • KeyHelp (3)
      • Plesk (22)
      • Webmin (21)
        • Usermin (2)
        • Virtualmin (11)
      • WHM (15)
  • Uncategorized (16)
  • Wordpress (87)
    • Elementor (2)
    • Find and Fix (10)
    • Functions (5)
    • Genesis (9)
    • Glossary (1)
    • How to (21)
    • Neuron TD (15)
      • Console Error (1)
      • functions (5)
        • register_post_type (1)
        • register_sidebar (1)
        • theme_files (1)
        • theme_supports (1)
      • Image Directory (1)
      • Menu (2)
      • Query (4)
    • Plugins (12)
      • Contact Form 7 (5)
      • Duplicator (1)
      • Essential Grid (2)
    • Softaculous (3)
    • Speed and Security (4)
    • Stock Theme Development (6)
      • Header Footer (1)
      • PHP (1)
      • VC (1)
    • Theme Development (2)
      • Issues (1)
      • Menu (1)
    • Timer Theme Development (3)
    • Update (2)
    • Woocommerce (2)
    • WP Basic Guideline (8)

Important DEV links

  • Premium Themes
    • Themeforest
    • Envato Market
  • Built With (What Theme is That?)
    • What WP theme is that
    • Joomla Template Detector
    • Drupal Template Detector
    • Prestashop Template Detector
    • Shopify Theme Detector
    • Squarespace Template Detector
    • OpenCart Detector
    • WordPress.com Theme Detector
  • Domain/IP history checker
    • Who IS request
    • Hosting Info
  • Check DNS Propagation
    • DNS Checker
    • intoDNS
  • What is my IP
    • What is My IP Address
    • What is My IP
    • IP location
    • What is My IP
    • Porkbun
  • SEO Tools
    • Visitor Traffic
    • Broken Link
    • Website Speed Test
      • SEMrush
      • GTmetrix
      • Pingdom
      • PageSpeed Insights
      • DebugBear
      • keyCDN
  • Photo Image
    • Remove Background 50 Free Preview Image 375 × 666 per month
  • Domain Registrars
    • 123-Reg
    • Porkbun
    • Freenom
    • Namecheap NEWCOM598
  • Hosting Providers
    • Bluehost
    • Hostgator
    • Inmotion
  • Hosting Control Panel
    • CWPpro (FREE)
    • DirectAdmin (Trial 60 Days, One account $2/month)
    • ISPConfig (Free)
  • Webmaster Tools
    • Google
    • Bing
    • Yandex
  • Miscellaneous
    • Time Calculator

 

  • Home
  • WordPress
  • OJS
  • Oxwall
  • Server and Hosting

Copyright © 2023 · Executive Pro Theme on Genesis Framework · WordPress · Log in