Advertisement
Guest User

Untitled

a guest
Dec 9th, 2018
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. apt-get -y install mariadb-server
  2.  
  3. mysql -u root -p12345 -e "USE mysql;"
  4. mysql -u root -p12345 -e "GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY '12345';"
  5. mysql -u root -p12345 -e "UPDATE mysql.user SET Password = PASSWORD ('12345') WHERE User = 'root';"
  6. mysql -u root -p12345 -e "CREATE DATABASE phpmyadmin;"
  7. mysql -u root -p12345 -e "USE phpmyadmin;"
  8. mysql -u root -p12345 -e "GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' IDENTIFIED BY '54321';"
  9. mysql -u root -p12345 -e "FLUSH PRIVILEGES;"
  10. service mysql restart && systemctl restart apache2
  11.  
  12. Po utworzeniu userów, gdy instaluję usługę phpmyadmin i wpisuję hasło do usera phpmyadmin jakie ustawiłem w zapytaniu to wywala mi:
  13. Access denied for user 'root'@'localhost' (using password: NO)
  14. Tak samo jest nawet w sytuacji gdy zamiast hasła do usera phpmyadmin, podam do usera root to i tak jest ten błąd.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement