Almalinux – Page 2

#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
```

August 27, 2023 by dev

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.

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;