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
Install Proxmox VE 7 on Debian 11 (Bullseye) December 16, 2021 In this guide, we will cover a step-by-step installation of Proxmox VE 7 virtualization software on Debian 11 (Bullseye) Linux system. It’s recommended to deploy Proxmox VE server from a Bare-metal_ISO_Installer, but it’s sometimes inevitable to deploy it on a running instance of Debian 11 (Bullseye) server. Setup Pre-requisites For… Read More
Install Openmediavault on Debian Wheezy/7 October 3, 2015April 27, 2018 First Install Debian minimal Configure your Debian repositories Update the repository sources and add the contrib and non-free repositories. nano /etc/apt/sources.list It should look something like this: deb http://ftp.us.debian.org/debian/ wheezy main contrib non-free deb-src http://ftp.us.debian.org/debian/ wheezy main contrib non-free deb http://security.debian.org/ wheezy/updates main contrib non-free deb-src http://security.debian.org/ wheezy/updates main contrib… Read More
Essential Openvz commands May 31, 2017 1. Command to list the running VPSs in a node # vzlist Example: # vzlist CTID NPROC STATUS IP_ADDR HOSTNAME 106 104 running xx.xx.xx.xx server1.test.com 107 46 running xx.xx.xx.xx server2.test.com 108 83 running xx.xx.xx.xx server3.test.com 109 86 running xx.xx.xx.xx server4.test.com 2. This command lists all (running and stopped) the VPSs… Read More