Dev {Tricks}

You are here: Home / Archives for Server and Hosting / Providers

by

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

 

by

How to change the SSH port | WHM

How to change the SSH port

  • Log in to the server with root user
  • Open /etc/ssh/sshd_config. 
    vi /etc/ssh/sshd_config
  • Edit the port line. Change the default port 22 to your choice, for example 1234. 
    port 1234
  • Restart SSHD 
    /scripts/restartsrv_sshd
  • Test SSH while specifying the new port 
    ssh USER@HOSTNAME -p1234
  • Please use your USER and HOSTNAME and the new port
  • If unsuccessful, add the new SSH port to your firewalls and then retest.
  • If the SSH test on the new port is successful then you can reboot and log in to the server with new port.

 

by

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;

by

Move files in the Linux terminal

The mv command moves file(s) from one location to another.

To move a file from one directory to another with mv, remember the syntax below

mv <source> <destination>

For example,

mv example.zip /home

Check whether, it moves example.zip

ls /home

Rename the file as you move it

mv example.zip /home/newexample.zip

Rename a file without moving it to another location

mv example.zip renameexample.zip

Moving a directory

mv exampledir /home

Moving a file safely

mv --interactive example.zip /home

This will ask

mv: overwrite '/home/example.zip'?

If you do not want to manually intervene, use –no-clobber or -n instead.

mv --no-clobber example.zip /home

 

 

by

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!