Skip to content

SQL Query

Tarun Mahajan edited this page Nov 26, 2023 · 2 revisions
  1. SHOW DATABASES;
  2. CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';
  3. GRANT ALL PRIVILEGES ON your_database.* TO 'new_user'@'localhost';
  4. FLUSH PRIVILEGES;
  5. EXIT;
  6. DROP DATABASE database_name;
  7. CREATE DATABASE database_name;
  8. use database_name;
  9. show tables;
Clone this wiki locally