Fixing phpmyadmin login on MySQL 5.7 and Debian 9 Rumi, May 4, 2018 Once setting up the LAMP stack, you must be wondering to see that you no longer been able to login phpmyadmin using root credentials. MySQL 5.7 changed the secure model: now MySQL root login requires a sudo (while the password still can be blank). I.e., phpMyAdmin will be not able to use root credentials. The simplest (and safest) solution will be create a new user and grant required privileges. 1. Connect to mysql sudo mysql --user=root mysql 2. Create a user for phpMyAdmin Run the following commands (replacing some_pass by the desired password): CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; If your phpMyAdmin is connecting to localhost, this should be enough. 3. Optional: allow remote connections Remember: allow a remote user to have all privileges is a security concern. With this in mind, if you want this user to have the same privileges during remote connections, additionally run (replacing some_pass by the password used in Step #2): CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES; 4. Update phpMyAdmin Using sudo, edit /etc/dbconfig-common/phpmyadmin.conf file updating user/password values in the following sections (replacing some_pass by the password used in Step #2): # dbc_dbuser: database user # the name of the user who we will use to connect to the database. dbc_dbuser='phpmyadmin' # dbc_dbpass: database user password # the password to use with the above username when connecting # to a database, if one is required dbc_dbpass='some_pas Related Administrations Configurations (Linux) MySQLMySQL 5.7PHPMyAdmin
Setup Keepalived for VRRP instead of ucarp January 26, 2023 I’ve the following setup: network-0 – 192.168.2.11 (real) network-1 – 192.168.2.12 (real) I want to add “network” as 192.168.2.10 as the floating address. I’ll need to do the following to both network-0 and network-1 Install keepalived Configure keepalived Start keepalived Set keepalived to start at boot. Related Read More
Vesta- How to set up master-slave DNS cluster January 28, 2019January 28, 2019 If you are looking for the options to avoid any DNS-related downtime or the way to manage dns across all server you have, you might consider to set up dns cluster. Create user dns-cluster on a server which will be used as dns slave On the second server (slave) with… Read More
How to check if your server has been hacked November 13, 2017November 13, 2017 Root compromises This means someone has full access to the system, here are the tell tale signs in order of most likely to give you a quick feel for what’s going on. 1. Have a look for system files that have changed recently. This is the first thing I would… Read More