How Install MySQL server on Ubuntu 24, Debian 12, Linux Mint 22
#!/bin/bash
# Exit immediately if a command exits with a non-zero status
set -e
# Define MySQL APT Config package URL and file
MYSQL_APT_CONFIG_URL=”
MYSQL_APT_CONFIG_DEB=”mysql-apt-config_0.8.33-1_all.deb”
# Update the package index
echo “Updating package index…”
sudo apt update -y
# Download MySQL APT Config package
if [[ ! -f “$MYSQL_APT_CONFIG_DEB” ]]; then
echo “Downloading MySQL APT Config package…”
wget “$MYSQL_APT_CONFIG_URL” -O “$MYSQL_APT_CONFIG_DEB”
fi
# Install the MySQL APT Config package
echo “Installing MySQL APT Config package…”
sudo dpkg -i “$MYSQL_APT_CONFIG_DEB”
# Fix missing GPG keys (if any)
echo “Updating package index again and fixing missing keys…”
sudo apt-key adv –fetch-keys ‘
sudo apt update -y
# Install MySQL Server
echo “Installing MySQL Server…”
sudo apt install mysql-server -y
# Fix MySQL Configuration Issues
echo “Fixing potential configuration issues…”
# Ensure /etc/mysql/conf.d/ directory exists
if [[ ! -d “/etc/mysql/conf.d/” ]]; then
echo “Creating missing /etc/mysql/conf.d/ directory…”
sudo mkdir -p /etc/mysql/conf.d/
fi
# Set correct permissions
echo “Setting permissions for /etc/mysql…”
sudo chown -R mysql:mysql /etc/mysql/
sudo chmod -R 755 /etc/mysql/
# Disable AppArmor for MySQL (optional)
echo “Disabling AppArmor for MySQL…”
if [[ -f “/etc/apparmor.d/usr.sbin.mysqld” ]]; then
sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/ || true
sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld || true
fi
# Restart AppArmor and MySQL
echo “Restarting AppArmor and MySQL services…”
sudo systemctl restart apparmor || true
sudo systemctl restart mysql
# Check MySQL status
echo “Checking MySQL service status…”
sudo systemctl status mysql
echo “MySQL installation and configuration completed successfully!”
sudo mysql
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
FLUSH PRIVILEGES;
exit;
[ad_2]
source
