VPS Dedicated Server Configuration

Server configuration is not an easy task. If anyone want to research or use any VPS dedicated server management for their internal or remote company, they need to learn LINUX commands or server management shell commands.

sudo su
sudo rm -rf tv_bn_site_production
sudo chown -R sysadm:sysadm tv_bn_site
sudo chown sysadm:sysadm php.ini
sudo chown www-data:www-data bplpoint.txt

ssh root@23.92.73.121
ssh -p 10222 sysadm@109.16.74.114

There are some database related command which may help anyone interested based on there need.
mysql -u root -pS@r85#a9vw
SHOW DATABASES;
show processlist;
sudo service apache2 stop;
sudo service mysql stop;
TRUNCATE TABLE news_hits_counter;

create database tvonline_jobs;
grant all privileges on tvonline_jobs.* to 'tvjobs'@'localhost' identified by "Zero2017Cool";
flush privileges;

grant insert, update, select on tvonline_jobs.* to 'tvjobs'@'10.243.205.35' identified by "Zero2017Cool";
grant insert, update, select on tvonline_jobs.* to 'tvjobs'@'10.243.205.34' identified by "Zero2017Cool";
flush privileges;

/etc/apache2/sites-available
ls -l

Here is some import and export related issue to solve the needs.
gzip -dc < /var/www/tvdocs/databases/tvonline_en_video_production.gz | mysql -u tvonline -pZero705001Cool tvonline_en_video

mysql -u root -p tvonline_website < D:\nayeem\DatabaseBackupMay2016\tvonline_website_production.sql

There is a technique for tracing the error log by using the following command:
sudo tail -f /var/log/mysql/mysql-slow.log