MySQL

Importar e exportar un ficheiro .sql

Exportar:

mysqldump -u username –-password=your_password database_name > file.sql

Importar:

mysql -u username –-password=your_password database_name < file.sql

👉 How to import a .sql file in MySQL?

Crear un usuario e dar permisos privilexios

Crear un usuario local:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Dar permisos nunha determinada base de datos:

GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';

Dar permisos para todas as bases de datos:

GRANT ALL PRIVILEGES ON *.* TO 'database_user'@'localhost';

👉 How To Create a New MySQL User and Grant Privileges

Resetear contrasinal ROOT

👉 How To Reset Your MySQL or MariaDB Root Password | DigitalOcean

Joins

👉 SQL Joins