We already discussed about the creation of MySQL DB and DB users. Here I am explaining the commands which are using to Grand Privileges to users for accessing the Databases in your server. Enter the mysql prompt by following the…
commands
How to create a database and database user from command line
This is actually the base of MySQL command usage. By the help of a control panel we can simply create a database, create DB users, edit variables, set previeages etc. But in some situations it is necessary to manage these…
15+ Rkhunter usages with example – Unix/Linux
We have already discussed about the installation of Rkhunter on Linux machine, Refer this Steps to install Rkhunter. Here I am explaining some common uses/switches of Rkhunter with examples. Switches with example: 1, -c, –check Check the local system. –config-check…
Steps to install Rkhunter(Rootkit hunter) on server – Linux
Before starting the Rkhunter installation we must have an idea about the ‘Rootkit’. A rootkit is a stealthy type of software, typically malicious, designed to hide the existence of certain processes or programs from normal methods of detection and enable…
How to replace MySQL with PerconaDB on a cPanel server
Percona Server is an enhanced drop-in replacement for MySQL. Features of PerconaDB >> Your queries will run faster and more consistently. >> You will consolidate servers on powerful hardware. >> You will delay sharding, or avoid it entirely. >> You will…
How/Command to change the login shell for a user – Unix/Linux
We have already discussed one method to change the login shell of a user by changing the shell value in /etc/passwd file by using the command USERMOD. Shell is a program that takes your commands from the keyboard and gives…
10+ ‘rpm’ command usages with examples – Unix/Linux
RPM – Red Hat Package Manager. RPM is the package manager for Linux system. The ‘rpm’ command is used to install, manage, uninstall packages from server/system. Here I am explaining some common usages of the ‘rpm’ command with example: 1,…