Sudo provides special privileges to any user or group. Some of the commands are accessible by the root user only. For example, a command to reboot the server. None other than the root user can reboot a Linux system but you want to provide the privilege to your team member, so they can reboot...
This tutorial will help you to create SFTP only user (without ssh access) on CentOS and RedHat systems. The user can connect the server with SFTP access only and allowed to access the specified directory. Users can’t SSH into the server. Follow the below tutorial to create sftp only account. Step 1 – Create...
Despite the rising number of cybercrimes, many companies who are willing to invest in proper security measures are much better protected today, than they were in the past. Security solution and practices are advancing rapidly in order to accommodate new threats and help companies stay ahead of the curve. However, not all companies are...
Syntax mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL ON [dbname].[table] TO 'username'@'localhost'; Implementation First login to mysql with root account and use following command to create new user ‘rahul in mysql with Full privileges. But this user can access database server from localhost only. mysql> CREATE USER 'rahul'@'localhost' IDENTIFIED BY 'password';...
Command Syntax: gpasswd -d user_name group_name Change user_name with your actual system user name and group_name with named of group from which you want to remove user. Example Use the following command to remove user jack from sysadmin group. gpasswd -d jack sysadmin Add User to Secondary Group The following command will will add...
How to Create MySQL User and Grant Permission. For the good security implementation, make sure to create separate user account rather than root to access database for each application. This will ensure that application can’t access other application’s database. You need MySQL administrator (root) privileges To create user accounts and assign privileges to the...