Categories
Server

MySQL: create database with user and password

The following instructions are to create:

  • one database
  • one user with all privileges on this database

Connect to MySQL with root user.

mysql -u root -p

Create a database and give it a name.
For this example we name it “db_name”.

create database db_name;

Create a user.
For this example we name it “db_users”;

create user db_user;

Now one stone three birds:
– we are giving all privileges to the user “db_user” on all the tables of the database “db_name”.
– we say that the user can login only locally.
– we create the user password.

grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';

To test it, first log out from root.

exit

Connect as your new user to the new database

mysql -u db_user -p db_name

Congratulations!

Categories
Cuisine

Oven bake sweet potatoes

I am going to share you an healthy and quick recipe for sweet potatoes.
Sweet potato is an healthy food, it’s very nutritious and is good for fiber and vitamins.

This is the to go food when you don’t want to spend time cooking and still get an healthy meal.
All you need is 5 minutes for preparation and 45 min baking time.

Pro Tip

Depending on how many sweet potatoes you are making and how big is your backing pan, you will have food ready for the next two or three meals!

Instructions

1. Wash and peel the sweet potatoes
2. Cut them in half , then cut them quarter inch (0.5 cm) thick.
3. On a baking pan lay the sweet potatoes without overlapping them
4. Brush the sweet potatoes with olive oil
5. Bake for 45 min at 350F (180C) or until soft
6. Add extra cheese (swiss, cheddar, parmesan, …) at the end!
7. You can keep the left over in your fridge a couple of days and reheat or eat them cold anytime.

Pro Tip during hot summer

You have baked you sweet potatoes and now they are in the fridge.
You can add them cold to ANY salad mix. It will be a great source of fiber and cool you down during hot days.
My favorite is to eat them cold with cold coucous or bulgur and fresh herbs like parsley and olive oil.