{"id":21,"date":"2026-10-08T15:54:11","date_gmt":"2026-10-08T15:54:11","guid":{"rendered":"https:\/\/boot-code.com\/?p=21"},"modified":"2026-10-08T15:54:12","modified_gmt":"2026-10-08T15:54:12","slug":"mysql-database-setup-in-ubuntu","status":"publish","type":"post","link":"https:\/\/boot-code.com\/?p=21","title":{"rendered":"MySQL Database Setup In Ubuntu"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Absolutely. Here is a practical <strong>MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu<\/strong>, using the Bash terminal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Update Ubuntu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Open Terminal:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update\nsudo apt upgrade -y<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2. Install MySQL Server<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install mysql-server -y<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check installation:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --version<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You should see something similar to:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql  Ver 8.0.x for Linux on x86_64<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3. Check MySQL service<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl status mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If it isn&#8217;t running:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl start mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Enable MySQL to start automatically when Ubuntu boots:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl enable mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Useful commands:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl start mysql\nsudo systemctl stop mysql\nsudo systemctl restart mysql\nsudo systemctl status mysql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">4. Secure MySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql_secure_installation<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">For a beginner\/local development machine, you can generally follow the prompts and remove anonymous users, disallow remote root login, and remove the test database.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">5. Login to MySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">On Ubuntu, you can usually enter MySQL with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You&#8217;ll see:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is the <strong>MySQL shell<\/strong>, not the normal Bash shell.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To exit:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>exit;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">6. Understand Bash vs MySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">There are two different environments:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Bash:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo systemctl status mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL shell:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; SHOW DATABASES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Don&#8217;t type the <code>$<\/code> or <code>mysql&gt;<\/code> prompt yourself.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">7. Create a Database \u2014 DDL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\ue200genui\ue202{&#8220;learning_viz&#8221;:{&#8220;type_id&#8221;:&#8221;SQL_DDL_VS_DML&#8221;}}\ue201<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter MySQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Create a database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE college;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">See databases:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Select the database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE college;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check the current database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DATABASE();<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">8. Create a Table<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">This is also <strong>DDL \u2014 Data Definition Language<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE students (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(100) NOT NULL,\n    age INT,\n    email VARCHAR(150),\n    course VARCHAR(100)\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check tables:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW TABLES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">See table structure:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DESCRIBE students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">or:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DESC students;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">9. DML \u2014 Insert Data<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">DML means <strong>Data Manipulation Language<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Insert one student:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO students (name, age, email, course)\nVALUES ('Rahul', 21, 'rahul@example.com', 'Java');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Insert multiple students:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO students (name, age, email, course)\nVALUES\n('Amit', 22, 'amit@example.com', 'Python'),\n('Priya', 20, 'priya@example.com', 'Java'),\n('Neha', 21, 'neha@example.com', 'SQL');<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">10. Read Data \u2014 SELECT<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Display everything:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Select specific columns:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT name, course\nFROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Find students studying Java:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM students\nWHERE course = 'Java';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Find students older than 20:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM students\nWHERE age &gt; 20;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">11. UPDATE Data<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Change a student&#8217;s course:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE students\nSET course = 'Spring Boot'\nWHERE name = 'Rahul';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Verify:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Important:<\/strong> Always be careful with <code>UPDATE<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE students\nSET course = 'Java';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">updates <strong>every row<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Usually you want:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE students\nSET course = 'Java'\nWHERE id = 1;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">12. DELETE Data<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Delete one student:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM students\nWHERE id = 2;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Again, be careful.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">deletes <strong>all rows<\/strong> from the table.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">13. More Important DDL Commands<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TABLE \u2014 Add column<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE students\nADD phone VARCHAR(20);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DESC students;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Modify column<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE students\nMODIFY age SMALLINT;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Rename column<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For MySQL 8:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE students\nRENAME COLUMN phone TO mobile;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Drop column<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE students\nDROP COLUMN mobile;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Rename table<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>RENAME TABLE students TO student;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Drop table<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP TABLE student;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Warning:<\/strong> <code>DROP TABLE<\/code> removes the table itself.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">14. DROP vs DELETE vs TRUNCATE<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">This distinction is very important:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Command<\/th><th>What happens<\/th><\/tr><\/thead><tbody><tr><td><code>DELETE<\/code><\/td><td>Deletes rows<\/td><\/tr><tr><td><code>TRUNCATE<\/code><\/td><td>Removes all rows, keeps table<\/td><\/tr><tr><td><code>DROP<\/code><\/td><td>Removes table itself<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM students WHERE id = 1;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Delete all rows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">or:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TRUNCATE TABLE students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Remove the entire table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP TABLE students;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">15. Useful SQL Commands<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Show databases:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Select database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE college;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Show tables:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW TABLES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Describe table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DESC students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Show table creation SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW CREATE TABLE students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Current database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DATABASE();<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Exit:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXIT;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">16. Complete Practice Session<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">You can copy this entire block into the MySQL terminal:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE college;\n\nUSE college;\n\nCREATE TABLE students (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(100) NOT NULL,\n    age INT,\n    email VARCHAR(150),\n    course VARCHAR(100)\n);\n\nINSERT INTO students (name, age, email, course)\nVALUES\n('Rahul', 21, 'rahul@example.com', 'Java'),\n('Amit', 22, 'amit@example.com', 'Python'),\n('Priya', 20, 'priya@example.com', 'Java'),\n('Neha', 21, 'neha@example.com', 'SQL');\n\nSELECT * FROM students;\n\nSELECT name, course\nFROM students\nWHERE course = 'Java';\n\nUPDATE students\nSET course = 'Spring Boot'\nWHERE name = 'Rahul';\n\nSELECT * FROM students;\n\nDELETE FROM students\nWHERE name = 'Amit';\n\nSELECT * FROM students;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">17. Running MySQL Directly from Bash<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">You don&#8217;t always have to enter the MySQL shell.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -e \"SHOW DATABASES;\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Run a query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -e \"USE college; SELECT * FROM students;\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can also execute a SQL file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create a file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nano college.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Put SQL inside:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE IF NOT EXISTS college;\n\nUSE college;\n\nCREATE TABLE IF NOT EXISTS students (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(100) NOT NULL,\n    age INT,\n    course VARCHAR(100)\n);\n\nINSERT INTO students (name, age, course)\nVALUES\n('Rahul', 21, 'Java'),\n('Priya', 20, 'SQL');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Save with:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ctrl + O \u2192 Enter \u2192 Ctrl + X<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql &lt; college.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Verify:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -e \"USE college; SELECT * FROM students;\"<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">18. DDL vs DML Cheat Sheet<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">DDL \u2014 structure<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE\nALTER\nDROP\nTRUNCATE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE college;\nCREATE TABLE students (...);\n\nALTER TABLE students ADD phone VARCHAR(20);\n\nTRUNCATE TABLE students;\n\nDROP TABLE students;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DML \u2014 data<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT\nUPDATE\nDELETE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO students (...) VALUES (...);\n\nUPDATE students\nSET age = 22\nWHERE id = 1;\n\nDELETE FROM students\nWHERE id = 1;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DQL \u2014 querying data<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">The basic learning sequence<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Ubuntu\n  \u2193\nBash\n  \u2193\nInstall MySQL\n  \u2193\nStart MySQL service\n  \u2193\nmysql shell\n  \u2193\nCREATE DATABASE\n  \u2193\nCREATE TABLE\n  \u2193\nINSERT\n  \u2193\nSELECT\n  \u2193\nUPDATE\n  \u2193\nDELETE\n  \u2193\nALTER \/ DROP<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;re learning this alongside your <strong>Java + Maven setup<\/strong>, the natural next step is to build a small <strong>Java Maven application that connects to this MySQL database using JDBC<\/strong>, performs <code>INSERT\/SELECT\/UPDATE\/DELETE<\/code>, and runs entirely from the Ubuntu terminal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. <strong>DCL (Data Control Language)<\/strong> is used to control <strong>user permissions and access<\/strong> in MySQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The two main DCL commands you should learn are:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT\nREVOKE<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">1. Login to MySQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">From Ubuntu Bash:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">2. Create a MySQL User<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">First create a database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE college;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Create a user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'student'@'localhost'\nIDENTIFIED BY 'Student@123';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check users:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT User, Host\nFROM mysql.user;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">3. GRANT<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><code>GRANT<\/code> gives privileges to a user.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, give the <code>student<\/code> user permission to read data from the <code>college<\/code> database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT\nON college.*\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now the user can run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">but cannot normally modify the data.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">4. Grant Multiple Permissions<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Give <code>SELECT<\/code>, <code>INSERT<\/code>, <code>UPDATE<\/code>, and <code>DELETE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE, DELETE\nON college.*\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This gives the user CRUD access to tables in the <code>college<\/code> database.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">5. Grant All Privileges<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">For a development user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES\nON college.*\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This gives the user all privileges on the <code>college<\/code> database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Avoid giving <code>ALL PRIVILEGES<\/code> unnecessarily in production.<\/strong> Give users only the permissions they actually need.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">6. Check User Privileges<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Use:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You might see something like:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE, DELETE\nON `college`.* TO `student`@`localhost`<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">7. REVOKE<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><code>REVOKE<\/code> removes privileges.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Suppose we previously granted:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE, DELETE\nON college.*\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Remove <code>DELETE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>REVOKE DELETE\nON college.*\nFROM 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'student'@'localhost';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">8. Remove All Privileges<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">You can revoke all privileges on the database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>REVOKE ALL PRIVILEGES\nON college.*\nFROM 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'student'@'localhost';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">9. Test the User<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Exit MySQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXIT;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">From Bash, login as the new user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u student -p<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Enter:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Student@123<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE college;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Try:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the user has <code>SELECT<\/code> permission, it works.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Try:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO students (name, age, course)\nVALUES ('Test', 22, 'Java');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If <code>INSERT<\/code> wasn&#8217;t granted, MySQL will reject it with a permission error.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">10. Database-Level vs Table-Level Permissions<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">You can give access to the entire database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT\nON college.*\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Or only one table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT\nON college.students\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is useful when a user should access only specific tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT\nON college.students\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The user can insert and read from <code>students<\/code>, but doesn&#8217;t automatically get access to every table in <code>college<\/code>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">11. Column-Level Permissions<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL also allows privileges on specific columns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT (name, course)\nON college.students\nTO 'student'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now the user can query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT name, course\nFROM college.students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">but doesn&#8217;t have general <code>SELECT<\/code> access to every column.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">12. Create a Read-Only User<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">This is a very common real-world setup.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'report_user'@'localhost'\nIDENTIFIED BY 'Report@123';\n\nGRANT SELECT\nON college.*\nTO 'report_user'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'report_user'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The user can read:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM students;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">but shouldn&#8217;t be able to:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT ...\nUPDATE ...\nDELETE ...<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">13. Create an Application User<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">For a Java application, you might create a dedicated user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'college_app'@'localhost'\nIDENTIFIED BY 'CollegeApp@123';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE, DELETE\nON college.*\nTO 'college_app'@'localhost';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Your Java application can then connect using:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>username = college_app\npassword = CollegeApp@123\ndatabase = college<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is better than having your Java application connect as <code>root<\/code>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">14. DCL Cheat Sheet<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Command<\/th><th>Purpose<\/th><\/tr><\/thead><tbody><tr><td><code>CREATE USER<\/code><\/td><td>Create database user<\/td><\/tr><tr><td><code>GRANT<\/code><\/td><td>Give permissions<\/td><\/tr><tr><td><code>REVOKE<\/code><\/td><td>Remove permissions<\/td><\/tr><tr><td><code>SHOW GRANTS<\/code><\/td><td>View permissions<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Common privileges:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\nINSERT\nUPDATE\nDELETE\nCREATE\nALTER\nDROP\nINDEX\nEXECUTE\nALL PRIVILEGES<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'student'@'localhost'\nIDENTIFIED BY 'Student@123';\n\nGRANT SELECT, INSERT, UPDATE, DELETE\nON college.*\nTO 'student'@'localhost';\n\nSHOW GRANTS FOR 'student'@'localhost';\n\nREVOKE DELETE\nON college.*\nFROM 'student'@'localhost';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">The complete SQL learning picture<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL\n\u2502\n\u251c\u2500\u2500 DDL \u2192 Database\/Table structure\n\u2502   \u251c\u2500\u2500 CREATE\n\u2502   \u251c\u2500\u2500 ALTER\n\u2502   \u251c\u2500\u2500 TRUNCATE\n\u2502   \u2514\u2500\u2500 DROP\n\u2502\n\u251c\u2500\u2500 DML \u2192 Data modification\n\u2502   \u251c\u2500\u2500 INSERT\n\u2502   \u251c\u2500\u2500 UPDATE\n\u2502   \u2514\u2500\u2500 DELETE\n\u2502\n\u251c\u2500\u2500 DQL \u2192 Data retrieval\n\u2502   \u2514\u2500\u2500 SELECT\n\u2502\n\u251c\u2500\u2500 DCL \u2192 Access control\n\u2502   \u251c\u2500\u2500 GRANT\n\u2502   \u2514\u2500\u2500 REVOKE\n\u2502\n\u2514\u2500\u2500 TCL \u2192 Transactions\n    \u251c\u2500\u2500 COMMIT\n    \u251c\u2500\u2500 ROLLBACK\n    \u2514\u2500\u2500 SAVEPOINT<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The next important topic after <strong>DDL + DML + DCL<\/strong> is <strong>TCL (<code>COMMIT<\/code>, <code>ROLLBACK<\/code>, <code>SAVEPOINT<\/code>)<\/strong>, especially because you&#8217;ll need it when working with Java\/JDBC and Maven.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: 2. Install MySQL Server Check installation: You should see something similar to: 3. Check MySQL service&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[26,22,25,23],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-database","tag-linux","tag-mysql","tag-ubuntu"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"DEVESH\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/boot-code.com\/?p=21\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"boot-code.com - programming tutorials\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL Database Setup In Ubuntu - boot-code.com\" \/>\n\t\t<meta property=\"og:description\" content=\"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/boot-code.com\/?p=21\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-10-08T15:54:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-10-08T15:54:12+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL Database Setup In Ubuntu - boot-code.com\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#blogposting\",\"name\":\"MySQL Database Setup In Ubuntu - boot-code.com\",\"headline\":\"MySQL Database Setup In Ubuntu\",\"author\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/#organization\"},\"datePublished\":\"2026-10-08T15:54:11+00:00\",\"dateModified\":\"2026-10-08T15:54:12+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#webpage\"},\"articleSection\":\"MySQL, Database, LINUX, MySql, UBUNTU\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/boot-code.com\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?cat=24#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?cat=24#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/boot-code.com\\\/?cat=24\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#listItem\",\"name\":\"MySQL Database Setup In Ubuntu\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#listItem\",\"position\":3,\"name\":\"MySQL Database Setup In Ubuntu\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?cat=24#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/#organization\",\"name\":\"boot-code.com boot-code.com\",\"description\":\"programming tutorials programming tutorials\",\"url\":\"https:\\\/\\\/boot-code.com\\\/\",\"telephone\":\"+919259571202\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/boot-code.com\\\/?author=1\",\"name\":\"DEVESH\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b4c9a289323b21a01c3e940f150eb9b8c542587f1abfd8f0e1cc1ffc5e475514?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"DEVESH\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#webpage\",\"url\":\"https:\\\/\\\/boot-code.com\\\/?p=21\",\"name\":\"MySQL Database Setup In Ubuntu - boot-code.com\",\"description\":\"Absolutely. Here is a practical MySQL setup + environment + basic DDL\\\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?p=21#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/?author=1#author\"},\"datePublished\":\"2026-10-08T15:54:11+00:00\",\"dateModified\":\"2026-10-08T15:54:12+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/boot-code.com\\\/#website\",\"url\":\"https:\\\/\\\/boot-code.com\\\/\",\"name\":\"boot-code.com\",\"description\":\"programming tutorials\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/boot-code.com\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL Database Setup In Ubuntu - boot-code.com","description":"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux","canonical_url":"https:\/\/boot-code.com\/?p=21","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/boot-code.com\/?p=21#blogposting","name":"MySQL Database Setup In Ubuntu - boot-code.com","headline":"MySQL Database Setup In Ubuntu","author":{"@id":"https:\/\/boot-code.com\/?author=1#author"},"publisher":{"@id":"https:\/\/boot-code.com\/#organization"},"datePublished":"2026-10-08T15:54:11+00:00","dateModified":"2026-10-08T15:54:12+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/boot-code.com\/?p=21#webpage"},"isPartOf":{"@id":"https:\/\/boot-code.com\/?p=21#webpage"},"articleSection":"MySQL, Database, LINUX, MySql, UBUNTU"},{"@type":"BreadcrumbList","@id":"https:\/\/boot-code.com\/?p=21#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/boot-code.com\/#listItem","position":1,"name":"Home","item":"https:\/\/boot-code.com\/","nextItem":{"@type":"ListItem","@id":"https:\/\/boot-code.com\/?cat=24#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/boot-code.com\/?cat=24#listItem","position":2,"name":"MySQL","item":"https:\/\/boot-code.com\/?cat=24","nextItem":{"@type":"ListItem","@id":"https:\/\/boot-code.com\/?p=21#listItem","name":"MySQL Database Setup In Ubuntu"},"previousItem":{"@type":"ListItem","@id":"https:\/\/boot-code.com\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/boot-code.com\/?p=21#listItem","position":3,"name":"MySQL Database Setup In Ubuntu","previousItem":{"@type":"ListItem","@id":"https:\/\/boot-code.com\/?cat=24#listItem","name":"MySQL"}}]},{"@type":"Organization","@id":"https:\/\/boot-code.com\/#organization","name":"boot-code.com boot-code.com","description":"programming tutorials programming tutorials","url":"https:\/\/boot-code.com\/","telephone":"+919259571202"},{"@type":"Person","@id":"https:\/\/boot-code.com\/?author=1#author","url":"https:\/\/boot-code.com\/?author=1","name":"DEVESH","image":{"@type":"ImageObject","@id":"https:\/\/boot-code.com\/?p=21#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/b4c9a289323b21a01c3e940f150eb9b8c542587f1abfd8f0e1cc1ffc5e475514?s=96&d=mm&r=g","width":96,"height":96,"caption":"DEVESH"}},{"@type":"WebPage","@id":"https:\/\/boot-code.com\/?p=21#webpage","url":"https:\/\/boot-code.com\/?p=21","name":"MySQL Database Setup In Ubuntu - boot-code.com","description":"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/boot-code.com\/#website"},"breadcrumb":{"@id":"https:\/\/boot-code.com\/?p=21#breadcrumblist"},"author":{"@id":"https:\/\/boot-code.com\/?author=1#author"},"creator":{"@id":"https:\/\/boot-code.com\/?author=1#author"},"datePublished":"2026-10-08T15:54:11+00:00","dateModified":"2026-10-08T15:54:12+00:00"},{"@type":"WebSite","@id":"https:\/\/boot-code.com\/#website","url":"https:\/\/boot-code.com\/","name":"boot-code.com","description":"programming tutorials","inLanguage":"en-US","publisher":{"@id":"https:\/\/boot-code.com\/#organization"}}]},"og:locale":"en_US","og:site_name":"boot-code.com - programming tutorials","og:type":"article","og:title":"MySQL Database Setup In Ubuntu - boot-code.com","og:description":"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux","og:url":"https:\/\/boot-code.com\/?p=21","article:published_time":"2026-10-08T15:54:11+00:00","article:modified_time":"2026-10-08T15:54:12+00:00","twitter:card":"summary_large_image","twitter:title":"MySQL Database Setup In Ubuntu - boot-code.com","twitter:description":"Absolutely. Here is a practical MySQL setup + environment + basic DDL\/DML tutorial on Ubuntu, using the Bash terminal. 1. Update Ubuntu Open Terminal: sudo apt update sudo apt upgrade -y 2. Install MySQL Server sudo apt install mysql-server -y Check installation: mysql --version You should see something similar to: mysql Ver 8.0.x for Linux"},"aioseo_meta_data":{"post_id":"21","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-10-08 15:54:12","updated":"2026-10-08 16:46:50"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/boot-code.com\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/boot-code.com\/?cat=24\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL Database Setup In Ubuntu\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/boot-code.com\/"},{"label":"MySQL","link":"https:\/\/boot-code.com\/?cat=24"},{"label":"MySQL Database Setup In Ubuntu","link":"https:\/\/boot-code.com\/?p=21"}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/posts\/21","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/boot-code.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21"}],"version-history":[{"count":1,"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":22,"href":"https:\/\/boot-code.com\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions\/22"}],"wp:attachment":[{"href":"https:\/\/boot-code.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/boot-code.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/boot-code.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}