Scripts posted recently tagged to db in Kelpi

1- 2 of 2.

Create a user in a MySQL Database

to user db mysql sql by nando.quintana

# su - mysql
# mysql
CREATE DATABASE databasename;
GRANT ALL PRIVILEGES ON databasename.* TO "user"@"hostname" IDENTIFIED BY "password";
FLUSH PRIVILEGES;

Create a user in a PostgreSQL Database

to user db postgresql sql by nando.quintana

# su - postgres
# psql
CREATE USER username WITH PASSWORD 'password' CREATEDB CREATEUSER;

hits counter