AlvaroMartinezQ/clickandbuy

Integrar MySQL con datos persistentes.

AlvaroMartinezQ opened this issue · 1 comments

AlvaroMartinezQ commented
Integrar MySQL con datos persistentes.
AlvaroMartinezQ commented

Comandos útiles bash:

  • mysql -u <user_name> -p

Comandos útiles mysql:

  • show databases;
  • create database <name_of_database>
  • cerate user 'newuser'@'localhost' identified by 'user_password';
  • GRANT permission1, permission2 ON database_name.table_name TO 'database_user'@'localhost';
  • GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';
  • use <name_of_database>
  • show tables;

Más comandos en: https://linuxize.com/post/how-to-create-mysql-user-accounts-and-grant-privileges/