In this tutorial we will explain couple of ways how to export one or all MySQL databases from one server and import to another server. We will also explain how to export MySQL database in a file for backup. To export database we will using mysqldump command. In this example we will export one database […]
Author: SkyHosting
Best Hosting Services: .rs domain registration, Web Hosting, VPS Servers, SSL Certificates.
Visit us SkyHosting.
Create MySQL database from command line
This tutorial explains how you can create MySQL user and database using command line. First, we will update the system and install MySQL database. We will update system and install MySQL database. For CentOS/RHEL OS:
|
1 |
yum update -y && yum install mysql mysql-server -y && service mysqld start && chkconfig mysqld on && mysql_secure_installation |
How to Set Static IP Address on Linux
As Linux system administrator, you will need to configure IP address on your system. Unlike desktop machines where you can use dynamic IP addresses, on a server infrastructure, you will need to setup a static IP address. Configure Static IP Address in RHEL/CentOS/Fedora To configure static IP address in RHEL / CentOS / Fedora, you […]
Connecting to Linux from Windows over SSH
After you received VPS or Dedicated server details from your hosting provider, you will need to connect to your server and configure it. This article describes how to use a client called PuTTY to form an Secure Shell (SSH) connection from a computer running a Microsoft Windows OS to a Linux server.
How to create MySQL database on cPanel
You can easily create a database in cPanel using MySQL Database Wizard option. Check out our step by step video tutorial.
Test website with the hosts file
If you moved your website to a new server and you want to test it before it completes propagation of DNS records or just develop a site that is not yet publicly available, you can do so by modifying the local host file. Entering IP address of a new server in the host file on […]
How To Free HDD Space On Your Server
If you notice you are not able to connect to your cPanel, Webmail, or WHM and your website is slow and giving errors, your server may be maxed out on the disk space. How to view your overall disk size and usage? Log into your server via SSH.
Install Brute Force Detection (BFD) on CentOS
A malicious person will often use brute force attack to try to get access to one of your accounts (web server, ftp, e-mail, ssh, etc.). It is very important to detect and block persons or scripts before they discover valid login information from services mentioned above. For that purpose we can use BFD (Brute Force […]
Install Apache, MySQL and PHP on CentOS | LAMP
This tutorial explains how you can install and configure LAMP and phpMyAdmin on CentOS 5.11 and CentOS 6.7, 32 and 64 Bit OS versions. First of all we will update system:
|
1 |
yum update -y |
Install EPEL repository for your Linux version. If you are running an CentOS 5 version:
|
1 |
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-5.noarch.rpm && rpm -Uvh epel-release-latest-5.noarch.rpm |
