manjaro tricks - installing mariadb mysql and basic setup

Channel:
Singapore Theo Ong Science and Engineering
Subscribers:
9,750
Published on ● Video Link: https://www.youtube.com/watch?v=FIcDCDayD10


Duration: 9:21
470 views
12

Steps after installing mariadb from app store (pamac/pacman):

remove any remaining mysql data
1) sudo rm -rf /var/lib/mysql

configure the default user, user directory and data directory
2) sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

start the mariadb service
3) sudo systemctl start mariadb

enable the mariadb service (if you want it to start on startup)
4) sudo systemctl enable mariadb

start mariadb to test
5a) sudo mariadb
5b) sudo mysql

------------------ Useful Links ------------------------------------
Arch linux wiki Mariadb installation
https://wiki.archlinux.org/title/MariaDB#Installation

Mariadb website
https://go.mariadb.com/download-mariadb-server-community107.html

Mariadb vs mysql
https://www.guru99.com/mariadb-vs-mysql.html

mariadb wiki
https://en.wikipedia.org/wiki/MariaDB

mysql wiki
https://en.wikipedia.org/wiki/MySQL

------------------ Video Sections --------------------------------
Chapters:
0:00 introduction
0:26 comparing mariaDB with MySql
1:48 installing mariaDB with pamac GUI
3:07 trying mariadb, failed to connect to local server
3:35 mariadb service fails also...
3:50 configure the mariaDB to set it up!
4:28 step 1 clean up the mariadb or mysql folder
4:54 step 2 use mariadb-install, make a new user and new directory
7:18 step 3 start the mariaDB service with systemctl
7:25 step 4 sudo mysql or sudo mariadb to start a command line interface


---------------------[Playlists and Relevant Github Repositories]----------------------------------------------

Fluid Mechanics and Git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSmdAXc6J0XOSQ1b27qsMGt
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Petroleum Downstream Crash Course Playlist:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQ13CnhacUqEVk-tZlU4ISE

OpenFOAM for Windows 10 Beginner Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YRhBU4IqSaToQ8_X543YQsZ
https://github.com/theodoreOnzGit/laminar_BL_OpenFOAM

OpenFOAM Intermediate Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSpWX6mSOlwWEOKVa6i_iuE
https://github.com/theodoreOnzGit/thin_pipeflow_snappyHexMesh

OpenFOAM Heat Transfer Playlist and GitHub Repo
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR2Qa3Q9-AzNSF2J9Dc4_qT
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Radiation Heat Transfer Learning Journal and Git Repos:
https://www.youtube.com/watch?v=uUzh9kh-WTo&list=PLhPfNw4V4_YRUUVUydQp-n6U-7uu1kJof
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Convection Boundary Layer and git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR9pRBpp101Mkuds49vjQ63
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Turbulence Modelling Playlist
https://www.youtube.com/watch?v=F_Rxv9uMM3g&list=PLhPfNw4V4_YSnbYkJIBQ1kRN06Mmxe2Be
https://github.com/theodoreOnzGit/turbulenceModelling

LabView Frequency Analysis and Fun (playlist and git repo)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQYE7XqTisMBkpm7gqNS_nl
https://github.com/theodoreOnzGit/Ted_labview_YouTube

Control Systems and Frequency Response
https://www.youtube.com/watch?v=qHY6y7JmB2U&list=PLhPfNw4V4_YRUuWnrtClovPKxU_gJOXH-
https://github.com/theodoreOnzGit/matlabFrequencyResponse.git

OpenFOAM C++
https://github.com/theodoreOnzGit/C-_YouTube_OpenFoam
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT9OgqS7ZPlot_Ucxzc6pQJ

OpenFOAM Bash
https://github.com/theodoreOnzGit/Bash_OpenFOAM_YouTube
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT5zjBhfj5Hj4r4D5eXilcU

Basic Samba
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuWJLufBUpNplitReZX0fB
https://github.com/theodoreOnzGit/sambaVideos

Manjaro Tips and Tricks
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuyXBfJxAvzHJTl0UiWx3h

lammps and Discrete Element Modelling (DEM)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YTdRlnLiu2OUXeTf5ZNVQ9E

playing with dotnet core
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQSTR8sqz0aRVzWlQBq3QUw
dotnet core github repo
https://github.com/theodoreOnzGit/dotnetCoreYoutube



Other Videos By Theo Ong Science and Engineering


2022-04-05playing with dotnet core 34 - dataStorage1 roadmap to learning asp dotnet core databases and entity
2022-04-05playing with dotnet core 33 - databases part 5 add user, drop user and grant privileges on mariadb
2022-03-31manjaro tricks - stream video from one pc to another using obs ndi
2022-03-31manjaro tricks - testing out vim nerdtree
2022-03-30manjaro tricks - add line numbering to vim
2022-03-28playing with dotnet core 32 - using dotnet cli to install remove and list packages in linux
2022-03-22playing with dotnet core 31 - databases part 4 messing around with table row insert and delete
2022-03-22playing with dotnet core 30 - databases part 3 messing around with table creation and deletion
2022-03-11playing with dotnet core 29 - databases part 2 create, delete and import databases
2022-03-11playing with dotnet core 28 - databases part 1 installing mariadb and navigating databases & tables
2022-03-11manjaro tricks - installing mariadb mysql and basic setup
2022-03-10playing with dotnet core 27 - transient vs scoped vs singleton part 2
2022-03-10playing with dotnet core 26 - transient vs scoped vs singleton part 1
2022-03-09playing with dotnet core 25 - power converter example with dependency injection and form validation
2022-03-09manjaro tricks - kde plasma 2022 start menu key not working
2022-03-08playing with dotnet core 24 - dependency injection part 5 common ways to do dependency injection
2022-03-07playing with dotnet core 23 - dependency injection part 4 using interfaces, inheritance and Construc
2022-03-07playing with dotnet core 22 - dependency injection part 3 swapping out dependencies
2022-03-07playing with dotnet core 21 - dependency injection part 2 making a class with some dependencies
2022-03-07playing with dotnet core 20 - dependency injection part 1 background knowledge
2022-03-07manjaro tricks - split screens with vim


Tags:
Engineering
Math
Science
Thermodynamics
Fluid Mechanics
Chemical
Nuclear
Chemical Potential
Fugacity
Enthalpy
Internal Energy
Entropy
First Law
Second law
Gibbs Free Energy
Hemholtz free energy
heat capacity
constant volume
constant pressure
tutorial
petroleum
oil
refinery
downstream
crude
jet
gasoline
gasoil
diesel
computational fluid dynamics
CFD
OpenFoam
Open
Foam
Fluid mechanics
heat transfer
turbulence
conduction
convection
radiation
Linux
Mint
Ubuntu
Manjaro