MySql Tutorial: CREATE database, table & INSERT VALUE How to create database and tables in MySql using the terminal on UBUNTU ... mysql -r root -p enter you password SHOW DATABASES; CREATE DATABASE name; USE database_name; CREATE TABLE name (fields and their data types); DESCRIBE table_name; INSERT INTO table_name VALUE(field values); SELECT * FROM table_name:
Here's a bash script to automate the installation of MariaDB Server on Debian. The script handles both installation from the default Debian repository and from the official MariaDB repository if a newer version is required. Install MariaDB on Linux #!/bin/bash # Bash script to install MariaDB Server on Debian # Function to install MariaDB from the default Debian repository install_from_debian_repo() { echo "Updating package list..." sudo apt update -y echo "Installing MariaDB Server and Client from Debian repository..." sudo apt install -y mariadb-server mariadb-client echo "Starting and enabling MariaDB service..." sudo systemctl start mariadb sudo systemctl enable mariadb echo "Securing MariaDB installation..." sudo mysql_secure_installation echo "MariaDB installed from Debian repository successfully!" } # Function to install MariaDB from the official MariaDB repository inst...
Comments
Post a Comment