Create a user and a database in postgres
Creating users and databases in postgres is pretty simple via the command line. Assuming you already have postgres installed, just do the following. # Step 1: Login into the psql shell sudo -u postgres...
Category: database
Create a new mysql user and grant all privileges to them on a database
The following command will create a new user and grant them all the permissions on a database. grant all privileges on database_name.* to ‘username’@’localhost’ identified by ‘secure_password’; To list the permissions granted to a...
Recent Comments