diegoguerrero

DAW - Creación de usuario

Mar 10th, 2021 (edited)
613
121 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # 1. Delete the currently existing user if it already exists.
  2. DROP USER IF EXISTS 'judingUser'@'localhost';
  3.  
  4. # 2. Create a new user
  5. CREATE USER IF NOT EXISTS 'judingUser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'judingPassword_DAWG2';
  6.  
  7. # 3. Give the new attributions for the new user
  8. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, REFERENCES, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON *.* TO 'judingUser'@'localhost';
  9.  
  10. # 4. Creating the new database
  11. CREATE DATABASE IF NOT EXISTS juding;
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×