Advertisement
Guest User

Untitled

a guest
Mar 10th, 2014
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. \\>MySQLPasswortReset
  2. sudo /etc/init.d/mysql stop
  3. sudo mysqld_safe --skip-grant-tables &
  4. sudo mysql -u root
  5. use mysql;
  6. update user set password=PASSWORD("password") where User='root';
  7. flush privileges;
  8. quit
  9.  
  10. \\>MySQLOwnCloudBenutzer&OwnCloudDatenbankAnlegen
  11. sudo mysql –uroot -p
  12. Enter password:password
  13. CREATE USER 'owncloud'@'localhost' IDENTIFIED BY '12345678';
  14. GRANT USAGE ON * . * TO 'owncloud'@'localhost' IDENTIFIED BY '12345678' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
  15. CREATE DATABASE IF NOT EXISTS `owncloud` ;
  16. GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud'@'localhost';
  17. exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement