In this article i will show how to list MySQL users, their passwords and granted privileges from the command-line prompt. MySQL account consists of two components: user and host. This allows the same user to use different MySQL accounts with different privileges, depending on which host they are connecting from. In the Host field, besides […]
access-control
HowTo: Grant Root Access to User – Root Privileges – Linux
From this article you’ll learn how to create a user in Linux and grant root access to him or how to grant root privileges to already existent user. This can be easily done by changing UID (user id) and GID (group id) in /etc/passwd file. Also you will learn how to just add user to […]
HowTo: Change a User’s Password in MySQL
Changing a MySQL user’s password is a task handled by the database administrator (root). Once the MySQL user’s password is changed, you should update the user’s privileges. Step 1: Log into MySQL server as root $ mysql -u root -p Step 2: Use ‘mysql’ database mysql> use mysql; Step 3: Change password for user John […]
Changing Permissions of Files and Folders in Linux – Chmod Basics
The сhmod (change mode) command changes the access mode of files and directories. Syntax Syntax of the chmod command is the following: $ chmod [options] permissions file[s] Options: -R, –recursive – Change files and directories recursively; -f, –silent, –quiet – Suppress most error messages. View the current file / directory mode using ls command: $ […]