Install MySQL on Linux (2026) - Ubuntu, Service, Access Denied Fix
Install MySQL on Linux with Ubuntu apt, then verify the MySQL service, create an app database, and fix access denied for user root on localhost.
This MySQL Ubuntu setup shows the exact terminal flow: install mysql-server, check systemd, verify mysqld with mysqladmin ping, create appdb, create app_user, grant privileges, understand root auth, and run a first real query.
Commands shown
sudo apt update
sudo apt install -y mysql-server
sudo systemctl status mysql --no-pager
sudo mysqladmin ping
sudo mysql -e "SELECT VERSION();"
CREATE DATABASE appdb;
CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'devpass';
GRANT ALL ON appdb.* TO 'app_user'@'localhost';
mysql -u root -p
sudo mysql -e "SELECT USER(), CURRENT_USER();"
mysql -u app_user -p appdb
Official references
https://ubuntu.com/server/docs/how-to...
https://dev.mysql.com/doc/mysql-apt-r...
https://dev.mysql.com/doc/refman/8.4/...
https://dev.mysql.com/doc/refman/8.4/...
#mysql #linux #ubuntu #database #terminal #installthat