Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # uname -a
- Linux improve1 4.4.0-59-generic #80-Ubuntu SMP Fri Jan 6 17:36:54 UTC 2017 i686 i686 i686 GNU/Linux
- # mysql --version
- mysql Ver 14.14 Distrib 5.7.17, for Linux (i686) using EditLine wrapper
- mysql> CREATE DATABASE bulterm;
- ERROR 1044 (42000): Access denied for user 'phpmyadmin'@'localhost' to database 'bulterm'
- mysql> SHOW GRANTS FOR 'phpmyadmin'@'localhost';
- +--------------------------------------------------------------------+
- | Grants for phpmyadmin@localhost |
- +--------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'phpmyadmin'@'localhost' |
- | GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'phpmyadmin'@'localhost' |
- +--------------------------------------------------------------------+
- 2 rows in set (0,00 sec)
- sudo systemctl stop mysql
- sudo dpkg-reconfigure mysql-server-5.7
- sudo systemctl start mysql
- sudo gedit /etc/dbconfig-common/phpmyadmin.conf
- # dbc_dbuser: database user
- # the name of the user who we will use to connect to the database.
- dbc_dbuser='root'
- # dbc_dbpass: database user password
- # the password to use with the above username when connecting
- # to a database, if one is required
- dbc_dbpass='12345'
Add Comment
Please, Sign In to add comment