The fix was by reconfiguring phpmyadmin, and by answering some interactive questions. Ok, now, if you follow Rael's instructions, you'll be able to login into phpmyadmin, but, at least for me, I wasn't able to create new databases, as a red message came up: No privileges (or some similar message) MySQL application password for phpmyadmin: ģ) In apache2, create a symbolic link to phpmyadmin sudo ln -s /etc/phpmyadmin/nf /etc/apache2/conf-available/nf Web server to reconfigure automatically: apache2Ĭonfigure database for phpmyadmin with dbconfig-common: Yes This would display privileges that were assigned to the. If you want to uninstall mariaDB: sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.5 mysql-client-core-5.5Ģ) Install phpmyadmin sudo apt-get -y install phpmyadmin (and answer some interactive questions) Answer: In MySQL, you can use the SHOW GRANTS command to display all grant information for a user. Sudo mysql_secure_installation (answer to some interactive questions):Įnter current password for root (enter for none): I was facing the same problem when using mariaDB with phpmyadmin (Ubuntu 16.04LTS).ġ) Install MariaDB sudo apt-get -y install mariadb-server mariadb-client # the password to use with the above username when connecting # the name of the user who we will use to connect to the database. Using sudo, edit /etc/dbconfig-common/nf file updating user/password values in the following sections (replacing by the password used in Step #2): # dbc_dbuser: database user With this in mind, if you want this user to have the same privileges during remote connections, additionally run (replacing by the password used in Step #2): CREATE USER IDENTIFIED BY '' Remember: allow a remote user to have all privileges is a security concern and this is not required in most of cases. Optional and unsafe: allow remote connections If your phpMyAdmin is connecting to localhost, this should be enough. GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Run the following commands (replacing by the desired password): CREATE USER IDENTIFIED BY '' PLEASE, REPLACE IT BY YOUR PASSWORD! DON'T USE AS PASSWORD! 3. In the below steps I'll use as a sample password. Connect to mysql sudo mysql -user=root mysql The simplest, safest and permanent solution will be create a new user and grant required privileges. I.e., phpMyAdmin will be not able to use root credentials. MySQL 5.7 changed the secure model: now MySQL root login requires a sudo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |