Advertisement
Guest User

Untitled

a guest
Apr 30th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. 1 # download
  2. $ sudo pacman -S mariadb
  3.  
  4.  
  5. 2 # config
  6. $ sudo mysql_install_db --user=mysql --basedir=/usr --datadi
  7. r=/var/lib/mysql
  8.  
  9.  
  10. ## status
  11. $ sudo systemctl status mariadb
  12.  
  13.  
  14. 4 # start service
  15. $ sudo systemctl start mariadb
  16.  
  17.  
  18. 5 # login
  19. $ mysql -u root -p
  20.  
  21.  
  22. ? # create user and set privileges
  23. $ CREATE USER 'eddno'@'%';
  24. $ GRANT ALL PRIVILEGES ON *.* To 'eddno'@'%' IDENTIFIED BY 'root';
  25.  
  26.  
  27. ? # change password
  28. $ UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
  29. $ FLUSH PRIVILEGES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement