In today’s dont forget your commands section or DFYC for short,
To login on mysql server,
>mysql -u username -p (hit enter) and then the password prompt is shown.
To create a database obviously,
> create database xxxxx;
To create a user,
> create user username identified by “password”;
To grant this user privs on a db
> grant all privileges on db.* to [email protected];
Dont forget to flush privileges
> flush privileges;
Follow Us!