mysql create user command

Jan 5, 06:58 AM

CREATE USER 'newUser"@'localhost' IDENTIFIED BY "bigidiotpassword" ;

GRANT USAGE ON *.* TO "newUser"@"localhost" IDENTIFIED BY "bigidiotpassword" WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `newDb` ;

GRANT ALL PRIVILEGES ON `newDb`.* TO "newUser"@"localhost" ;

— Mark Edwards

,

---

Commenting is closed for this article.

---