Guest User

Untitled

a guest
Oct 20th, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. # uname -a
  2. Linux improve1 4.4.0-59-generic #80-Ubuntu SMP Fri Jan 6 17:36:54 UTC 2017 i686 i686 i686 GNU/Linux
  3.  
  4. # mysql --version
  5. mysql Ver 14.14 Distrib 5.7.17, for Linux (i686) using EditLine wrapper
  6.  
  7. mysql> CREATE DATABASE bulterm;
  8. ERROR 1044 (42000): Access denied for user 'phpmyadmin'@'localhost' to database 'bulterm'
  9.  
  10. mysql> SHOW GRANTS FOR 'phpmyadmin'@'localhost';
  11. +--------------------------------------------------------------------+
  12. | Grants for phpmyadmin@localhost |
  13. +--------------------------------------------------------------------+
  14. | GRANT USAGE ON *.* TO 'phpmyadmin'@'localhost' |
  15. | GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'phpmyadmin'@'localhost' |
  16. +--------------------------------------------------------------------+
  17. 2 rows in set (0,00 sec)
  18.  
  19. sudo systemctl stop mysql
  20. sudo dpkg-reconfigure mysql-server-5.7
  21. sudo systemctl start mysql
  22.  
  23. sudo gedit /etc/dbconfig-common/phpmyadmin.conf
  24.  
  25. # dbc_dbuser: database user
  26. # the name of the user who we will use to connect to the database.
  27. dbc_dbuser='root'
  28.  
  29. # dbc_dbpass: database user password
  30. # the password to use with the above username when connecting
  31. # to a database, if one is required
  32. dbc_dbpass='12345'
Add Comment
Please, Sign In to add comment