CentOS – Page 4

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;

June 2, 2023 by dev

First add the user, run:
```
sudo adduser <UserNameHere>
```
Add the user to sudo group by typing the command in terminal for Ubuntu version 12.04 and above:
```
sudo adduser <UserNameHere> sudo
```
In an older version of Ubuntu (version 12.04 and older), run:
```
sudo adduser <UserNameHere> admin
```
Verify it:
```
id <UserNameHere>
```

April 3, 2023 by dev

Check whether Screen is installed
```
which screen
```
If Screen is not installed on your system, run the following command:
1. If your system uses yum, you can install Screen with the command below
```
yum install screen
```
2. If your system uses apt, you can install Screen with the command below
```
apt install screen
```
To run a Screen session, enter the screen command.
```
screen
```
If your session disconnects for some reason, log back in to your server and run the screen -r command.
```
screen -r
```
This will reconnect you to your Screen session.

June 20, 2021 by dev

Backup of all important data before proceeding! Changes to the partition table always bear the risk of complete data loss.

Boot your VPS / VDS into the rescue-system
Now connect through VNC (How to use VNC to connect to your VPS and VDS)
Login as “root”
To perform changes on the partition easily use gparted
To start the GUI type “startxfce4” within VNC console and wait a few seconds until the graphical interface appears
On the upper left side you will see “Applications”, open it and select “Run Program”
Type “gparted” within the application finder and the app should start immediately
Now you can resize and create new partition with unallocated space.