It’s better to have installed development tools and disable NetworkManager for a produciton envrionment. You can optionally follow the steps-
systemctl stop NetworkManager
systemctl disable NetworkManager
Install Development Tools:
yum group install "Development Tools"
Remove MariaDB pre-installed libraries-
yum -y remove mariadb-libs
Enable MySQL Repository
First of all, You need to enable MySQL 5.7 community release yum repository on your system. The rpm packages for yum repository configuration are available on MySQL’s official website.
First of all, import the latest MySQL GPG key to your system.
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
Now, use one of the below commands to configure the Yum repository as per your operating system version. Continue reading “Install MySQL 5.7 on CentOS 7” »
Step 1 – Prerequisites
Login to your Debian 9 system using shell access. For remote systems connect with SSH. Windows users can use Putty or other alternatives applications for SSH connection.
Run below commands to upgrade the current packages to the latest version.
sudo apt update
sudo apt upgrade
Step 2 – Configure MySQL PPA
MySQL team provides official MySQL PPA for Debian Linux. You can download and install the package on your Debian system, which will add PPA file to your system. Run below command to enable PPA.
sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb
During the installation of MySQL apt config package, It will prompt to select MySQL version to install. Select the MySQL 5.7 or 5.6 option to install on your system. Continue reading “Installing MySQL on Debian” »
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;
If your phpMyAdmin is connecting to localhost, this should be enough. Continue reading “Fixing phpmyadmin login on MySQL 5.7 and Debian 9” »