Advertisement
Guest User

Untitled

a guest
Oct 21st, 2013
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. mysql -h localhost -u $MYSQLLOGIN -p$MYSQLROOTPASS -t -e '
  2. CREATE USER $USERNAME@'localhost' IDENTIFIED BY $MYSQLPASS;
  3. create database $MYSQLDB;
  4. grant usage on *.* to $USERNAME@localhost identified by $MYSQLPASS;
  5. grant all privileges on $MYSQLDB.* to $USERNAME@localhost';
  6.  
  7. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$MYSQLPASS' at line 1
  8.  
  9. mysql -h localhost -u $MYSQLLOGIN -p$MYSQLROOTPASS -t -e "
  10. CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$MYSQLPASS';
  11. create database $MYSQLDB;
  12. grant usage on *.* to '$USERNAME'@'localhost' identified by '$MYSQLPASS';
  13. grant all privileges on $MYSQLDB.* to '$USERNAME'@'localhost';"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement