DEV Community: LAKSHMI G

How to Install MySQL and MySQL Workbench in Linux (Simple Explanation)

LAKSHMI G — Mon, 16 Mar 2026 06:20:28 +0000

step 1

First, update your Linux system by running the command sudo apt update.
After updating, install the MySQL server using sudo apt install mysql-server.
This installs the main database system called MySQL. Once the installation is finished, start the MySQL server using sudo systemctl start mysql.
To check whether MySQL is running properly, run sudo systemctl status mysql.
If it shows active (running), it means the MySQL server is working correctly.
You can also confirm it by opening the MySQL terminal with sudo mysql.
If the terminal shows mysql>, the database server is successfully installed.

step 2
Next, install MySQL Workbench, which is a graphical tool used to manage databases easily.
Go to your Downloads folder by running cd Downloads, then install the Workbench package using sudo dpkg -i mysql-workbench-community_8.0.46-1ubuntu24.04_amd64.deb.
If any dependency errors appear during installation, fix them using sudo apt --fix-broken install.
After the installation is completed, open MySQL Workbench by typing mysql-workbench in the terminal or by opening it from the Applications menu.

step 3

When MySQL Workbench opens, create a new connection by entering the hostname 127.0.0.1, port 3306, and username root.
Then click Store in Keychain to save your password.
After entering the password, click Test Connection to check if the connection is successful.
If the test is successful, save the connection.
Now you can start using MySQL Workbench to create databases, tables, and run SQL queries easily.

Commands

- sudo apt update
- sudo apt install mysql-server(Press Y if asked.)
- sudo systemctl start mysql (you should see active (running))
- sudo systemctl status mysql
- sudo mysql (If it opens like:mysql>
- then MySQL server is working. command-exit;
- cd Downloads
- sudo dpkg -i mysql-workbench-community_8.0.461ubuntu24.04_amd64.deb
- Fix dependency if needed:sudo apt --fix-broken install
- mysql-workbench
- Create Connection

My Interview Experience & Questions Faced (Frontend + JavaScript + SQL)

LAKSHMI G — Wed, 07 Jan 2026 07:14:29 +0000

Yesterday, I attended an interview for a Fresher React Developer role. It was a great learning experience. The interview included questions from JavaScript, CSS, SQL, and Web fundamentals. They also gave me a task to clone a webpage using HTML and CSS.

Below are the questions I faced and my overall experience:

Given [2,3,1,4] — Find the sum of the array?
Remove duplicates from an array?
Split the string "Hello"?
Difference between == and === in JavaScript?
What is inline vs inline-block in CSS?
SQL query to find salary between 50,000 and 80,000?
SQL query to split salary category above or below 60,000?
Find the second highest salary in SQL?
Find employee name and department with highest salary?

** Frontend Task Given:**

Clone a webpage UI using HTML and CSS only with a clean layout.

What I Learned

Confidence matters even if you don’t answer everything perfectly
Logic questions in JavaScript require knowledge of array methods and string handling
CSS layout concepts are important for UI cloning tasks

This interview helped me understand where I need to improve.

Java Variable

LAKSHMI G — Thu, 18 Dec 2025 05:45:39 +0000

A variable in Java is a named memory location used to store data that can change during program execution.

Variable = name + memory + value

Why use variables

Store data temporarily in memory
Reuse values multiple times
Perform calculations
Make programs dynamic and flexible
Improve code readability and maintenance

How is a variable created in Java

variable is created in two steps:

1.Declaration (Memory allocation)

- int age;
- Tells Java what type of data to store
- Reserves memory

2.Initialization (Assign value)

  Stores the value in allocated memory
  int age = 25

When is a variable created?
It depends on the type of variable
Java has 4 main types of variables based on where and when
memory is allocated.

1. Local Variable

** Where created?**
Inside a method, constructor, or block

When created?
When the method is called

When destroyed?
When the method execution ends

Memory location: Stack

void show() {
    int x = 10; // local variable
}

Must be initialized before use
No default value

2.Instance Variable (Non-static)

Where created?
Inside class but outside methods

When created?
When an object is created using new

** When destroyed?**
When object is destroyed (GC)

Memory location: Heap

class Student {
    int id; // instance variable
}

Student s = new Student(); // instance variable created here

Gets default value
One copy per object

3.Static Variable (Class Variable)

Where created?
Inside class with static keyword

** When created?**
When class is loaded into JVM

When destroyed?
When class is unloaded

Memory location: Method Area (Class Area)


class College {
    static String collegeName = "ABC College";
}

Single copy shared by all objects
Access using class name

4.Parameter Variable

Where created?
In method parameter list

When created?
When method is called

Memory location: Stack

void add(int a, int b) {
    int sum = a + b;
}

Java built-in classes

LAKSHMI G — Sat, 13 Dec 2025 06:21:17 +0000

Java contains thousands of built-in classes (around 4,500+), organized into different packages.

we mainly use classes from java.lang, java.util, java.io, java.time, java.sql, and java.net packages.

java.lang (Auto-imported – MOST IMPORTANT):

Class-----> Use
Object-> Parent of all classes
StringText-> handling
StringBuilder-> Mutable strings
StringBuffer-> Thread-safe strings
System-> I/O, GC
Math-> Math operations
Thread-> Multithreading
Exception-> Error handling
Runtime-> JVM interaction

java.lang is imported by default.

java.util (Collections & Utilities)

Class-----> Use
ArrayList-> Dynamic array
LinkedList-> Linked list
HashMap-> Key-value storage
HashSet-> Unique elements
Scanner-> Input
Collections-> Utility methods
Date-> Date (legacy)
Optional-> Avoid null

java.io (File & Stream Handling)

Class----> Use
File-> File handling
FileInputStream-> Read binary data
FileOutputStream-> Write binary data
BufferedReader-> Read text
InputStreamReader-> Stream → Reader

java.time (Modern Date & Time – Java 8+)
Class-----> Use
LocalDate-> Date
LocalTime-> Time
LocalDateTime-> Date + Time
Period-> Date difference
Duration-> Time difference

java.sql (Database – JDBC)
Class-----> Use
Connection-> DB connection
Statement-> SQL execution
PreparedStatement> Secure SQL
ResultSet> Query result

java.net (Networking)

Class-----> Use
URL-> Web address
Socket-> Client connection
ServerSocket-> Server connection

Java Packages

LAKSHMI G — Sat, 13 Dec 2025 06:13:46 +0000

commonly asked packages

java.lang
java.util
java.io
java.net
java.sql
java.math
java.time
java.nio
java.applet
java.security
java.text
java.awt
javax.sql
javax.net
javax.servlet (in Java EE)

Java Keywords

LAKSHMI G — Sat, 13 Dec 2025 06:10:32 +0000

abstract , assert , boolean , break , byte
case , catch , char , class , const*
continue , default , do , double , else
enum , extends , final , finally , float
for , goto* , if , implements , import
instanceof , int , interface , long , native
new , package , private , protected , public
return , short , static , strictfp , super
switch , synchronized, this , throw , throws
transient , try , void , volatile , while

Java Literals (Not keywords, but important)

true
false
null

Java Exception Handling

LAKSHMI G — Fri, 12 Dec 2025 07:52:32 +0000

Think of a Java program like a machine that performs steps one after another.
Each step assumes everything is fine — inputs are correct, files exist, and resources are available.
But in real life, things don’t always work perfectly.

At any time:

A user may enter the wrong input
A file you need might be missing
An internet resource may stop responding
A calculation might produce an invalid result

These unexpected problems are called exceptions.

Now imagine there is no exception handling.

If even one small error happens, the entire program would stop suddenly and show a messy error message.
This is like stopping a whole factory just because one small machine had a minor issue.
To avoid this complete shutdown, Java provides a system called exception handling.

Exception handling Keywords

try block( watches the part of code where an error might happen.)

catch block (catches the error, understands what went wrong, and handles it safely.)

finally block (runs important cleanup work (like closing files), no matter what happens.)

throw (lets you create your own error intentionally.)

throws (tells other parts of the program that this method might produce an error.)

Instead of stopping the whole program, Java isolates the error, fixes or handles it, and allows the program to continue.

What Is an Exception?
An exception is an event, which occurs during the execution of a program, that disrupts the normal flow of the program's instructions.

What is System.out.println() in Java?

LAKSHMI G — Thu, 11 Dec 2025 07:42:44 +0000

When beginners see System.out.println(), it looks long and confusing. But every part of it has a purpose
This line is not magic — it is simply Java’s way of connecting your program to the standard output system.

println()is a method:

In this print method has inside printStream class this class it takes an OutputStream as arugment in its constructor
PrintStream(OutputStream out)this OutputStream is abstract class.

it is abstract, you cannot create an object directly from it (new OutputStream()).

The System class provides a PrintStream object named out.
It is declared as static, so we access it using the class nameis ( System.out)

Java Data Types

LAKSHMI G — Thu, 16 Oct 2025 09:06:20 +0000

Java, data types define the type of data a variable can hold. They are divided into two main categories:

Primitive Data Types
Non-Primitive (Reference) Data Types

1. Primitive Data Types:

Primitive data types are the most basic building blocks of Java programs. They store simple values directly in memory and are used for efficient computation.

What are Primitive Data Types?
Java provides 8 primitive data types.
byte
short
int
long
float
double
char
boolean

Byte Data Type in Java

size of 1 byte- 8 bits
Stores very small integers values
byte range (-127 to 128)

Short Data Type in Java

Size of 2 byte- 16 bits
Stores small integer values larger than byte
Range of short -32,768 to 32,767
useage:Useful when you need to save memory but need to store slightly larger numbers than byte
int Data Type in Java
Size of 4 byte- 32 bits
Stores standard integer values and is the most commonly used
numeric type
Range of int Standard integer
Usage: Ideal for counting, loops, arithmetic operations, and general-purpose integer storage.

long Data Type in Java

Size of 8 byte- 64 bits
Default value is 6L.(100000L)
Stores large integer values that exceed the range of int
Usage: Ideal for calculations involving large numbers, like population counts, financial data, or scientific computations.

Float Data Type in Java

Size of 4 byte- 32 bits
Stores decimal (floating-point) numbers with single precision.
Default value is 0.0f (99.9f)
-** Usage*: Ideal for fractional numbers, like measurements, prices, or scientific calculations where less precision is acceptable.
**Double Data Type in Java*
Size of 8 byte- 64 bitsStores decimal (floating-point) numbers with double precision.
Default value is 0.0d (99.99)
Usage: Ideal for precise fractional calculations, like financial computations, scientific formulas, or large-scale measurements.

char Data Type in Java

Size of 2 byte- 16 bits
Stores a single character or Unicode value.
Range: '\u0000' (0) to '\uffff' (65,535)
Usage: Ideal for storing letters, digits, symbols, or any single character.

Boolean Data Type in Java

Size of 1 bit (internally handled by JVM, size may vary)
Stores true or false values only.
Usage: Ideal for logical operations, conditions, and flags in programs.

Java Features

LAKSHMI G — Thu, 16 Oct 2025 07:42:25 +0000

Java is one of the most widely used programming languages in the world.
It is object-oriented, platform-independent, and secure, making it a top choice for web, mobile, and enterprise applications.
Let’s explore the main features of Java that make it so powerful object oriented programming language

Simple Syntax
Object-Oriented
Platform Independent
Interpreted
Scalable
Portable
Secured and Robust
Memory Management
High Performance 10.Multithreading
Rich Standard Library
Functional Programming Features
Integration with Other Technologies
Support for Mobile and Web Application
Documentation and Community Support

1.Simple Syntax

Java syntax is very straightforward and very easy to learn. Java removes complex features like pointers and multiple inheritance, which makes it a good choice for beginners.

2.Object-Oriented

Java follows Object-Oriented Programming (OOP) principles. Everything is treated as an object, which makes the code modular, reusable, and maintainable. Key OOP concepts in Java include Encapsulation, Inheritance, Polymorphism, and Abstraction

3. Platform Independent

Java follows the principle “Write Once, Run Anywhere” (WORA).
Compiled Java code becomes bytecode, which can run on any operating system with a Java Virtual Machine (JVM), making it highly portable

4.Interpreted

Java code is not directly executed by the computer. It is first compiled into bytecode. This byte code is then understand by the JVM. This enables Java to run on any platform without rewriting code.

5.Scalable
Java can handle both small and large-scale applications. Java provides features like multithreading and distributed computing.
It allows developers to add more features or handle more users without changing the core architecture.

6.Portable

Java Programs can run on any platform without modification.
After compilation, Java produces bytecode (.class files) instead of machine-specific code.
The Java Virtual Machine (JVM) on any system can execute this bytecode, making Java programs highly portable across different operating systems like Windows, macOS, or Linux

7.Secured and Robust

Java is secure because it prevents unauthorized access and ensures safe execution, and it is robust because it handles errors efficiently and manages memory automatically

8. Memory Management

Java provides automatic memory management, which makes programs more reliable and reduces memory leaks.
It has a Garbage Collector (GC) that automatically removes unused objects from memory.
Makes applications more robust and efficient.

9. High Performance

Java provides high performance because the JIT compiler converts bytecode into native code at runtime, and its memory and thread management optimize execution speed.

10. Multithreading

Java supports multithreading, which means it can run multiple tasks simultaneously within a single program.
Each thread runs independently, allowing better CPU utilization and faster execution.
Useful in applications like animations, gaming, file downloads, and handling multiple user requests in web servers.
Java provides built-in support for multithreading through the Thread class and Runnable interface.

11. Rich Standard Library

Java provides various pre-built tools and libraries which is known as Java API.
These libraries cover areas like data structures, networking, file I/O, database access, utilities, GUI,database connectivity (JDBC)
and more.
Developers can reuse pre-written code, which speeds up development and reduces errors.
Popular packages include java.lang, java.util, java.io, java.net, and javax.swing.

12. Functional Programming Features

Java supports functional programming concepts starting from Java 8, making code more concise and readable.
Features include lambda expressions, streams, and functional interfaces.
These allow developers to write declarative code, perform operations on collections easily, and enable parallel processing.
Functional programming helps in reducing boilerplate code and improves productivity

13. Documentation and Community Support

Java has extensive documentation and a large global community, which makes learning and problem-solving much easier.
The official Java API documentation provides detailed explanations of classes, methods, and packages.
A strong developer community contributes tutorials, libraries, frameworks, and answers on platforms like Stack Overflow, GitHub, and forums.
This support helps developers quickly resolve issues, stay updated, and adopt best practices.

What is Java

LAKSHMI G — Thu, 16 Oct 2025 06:43:50 +0000

1.)What is Java?

Java is a high-level, object-oriented, and platform-independent programming language. It’s widely used for developing web, mobile, and enterprise applications because it is reliable, secure, and runs on any platform with the Java Virtual Machine (JVM). Learning Java also provides a strong foundation in object-oriented concepts, which is essential for many software roles

2.)Why do you prefer Java over other languages?

Java is stable, secure, and has strong memory management.
Its syntax is clean and beginner-friendly, and it has a large community and industry demand, making it easier to learn, build, and maintain applications

3.)Where is Java used?

Java is used in Android app development, enterprise software, banking and financial systems, and backend web applications using frameworks like Spring and Hibernate .

4.) What is the main feature of Java?

Java is platform independence. With the Java Virtual Machine (JVM),
we can write code once and run it anywhere without modification

Java Syntax Rules

LAKSHMI G — Tue, 14 Oct 2025 07:29:46 +0000

- File name should be class name.
- Case sensitive.
- Semi-colon is most compulsory.
- Main function is compulsory.
- Class is compulsory.
- Curly braces is most important start and {}.
- Main function should is proper case.
- Extension most be in lowercase.
- String most be in "" double quotation
- Without Public main function not run.(show of run time error)