3/5/2020 - 12:02 AM

MySQL Server Useful Commands

# Install MySQL Server
sudo apt-get update
sudo apt-get install mysql-server

# Launch the MySQL Secure Installation
# This utility prompts you to define the mysql root password and other 
# security-related options, including removing remote access to the root user
# and setting the root password.
sudo mysql_secure_installation utility

# Start MySQL Service
sudo systemctl start mysql

# Launch and reboot MySQL Service
sudo systemctl enable mysql

# Restart MySQL Service
sudo systemctl restart mysql

# Making a link to phpMyAdmin directory
sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin