Advertisement
Guest User

Untitled

a guest
Apr 28th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. #1698 - Access denied for user 'root'@'localhost'
  2.  
  3. sudo mysql --user=root mysql
  4.  
  5. CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
  6. GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
  7. FLUSH PRIVILEGES;
  8.  
  9. CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'some_pass';
  10. GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%' WITH GRANT OPTION;
  11. FLUSH PRIVILEGES;
  12.  
  13. # dbc_dbuser: database user
  14. # the name of the user who we will use to connect to the database.
  15. dbc_dbuser='phpmyadmin'
  16.  
  17. # dbc_dbpass: database user password
  18. # the password to use with the above username when connecting
  19. # to a database, if one is required
  20. dbc_dbpass=''
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement