Create database, user, and Grant Permission
CREATE DATABASE dbname;
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';
GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';
FLUSH PRIVILEGES;
Latest posts
GRANT read only access to a PostgreSQL database for a user
In your terminal, login as the postgres user (for security reasons, the postgres user has no password. That’s...
Command to know TLS Version:
openssl ciphers -v | awk '{print $2}' | sort | uniq
For TLS 1.3:
openssl s_client...
Find Cause of Spam Source
Mass suspend or unsuspend mailboxes of a domain
Using the API, can help you quickly...
How can i disable MySQL strict mode ?
To Disable Strict Mode via SQL
mysql -u root -p -e "SET GLOBAL sql_mode =...
How to give a user permission to restart apache?
Using visudo, add the following to your sudoers file, replacing username with the proper...
MySQL SHOW USERS: List All Users in a MySQL Database Server
MySQL SHOW USERS: List All Users in a MySQL Database Server:
>mysql -u root -p
Enter...
Leave a Comment