How to install and configure MariaDB 11 on Ubuntu 22.04 | How to install MariaDB 11.3 on Ubuntu|2024

hello guys in this video we will see how to install and configure marp latest version that is 11.3 or 11 on 22204 LDS version then we will see how to connect to marad DB first verify whether Maria DB any default Maria DB version is installed on Ubuntu sudo system CTL status Maria DB see there is no service with marad okay now open file for go to maria.org hit enter click on download on okay select marad DB server repositories then select the distribution so select UB to version if you are on 23 select 23 I'm on 22.4 select it then select the Marb version see the latest version at the time of making this video is 11.3 you can select any one of them okay click on it and we have to run these commments one by one copy the first one I will keep this link in the video description okay copy one by one goo terminal paste it it enter it is done now next next make directory okay it is going to create directory paste it crl l paste it it is done now it is going to copy this one copy signing key cop copy it copy paste it it enter it is also done next see once key is imported copy and paste file into this directory so so copy all these into this file so sudo VI paste it hit enter I2 insert mode then copy all this text rightly copy paste it save the file the that's Sol okay now we have to run the sudo a get update is Success control L to clear screen now install marad DB server by copying this command you can type manually also hit enter typy for confirmation and hit enter see it is installing 11.3 okay we have successfully installed Marb latest version on open2 22.4 let us verify control L to clear screen sudo system CTL status Mar DB see Maria DB service is running before we don't have the mar DB server Marb service also see here service is enabled okay you to fit now we will see how to connect to Maria now connect to Maria sudo marad DB and hit enter see we have successfully connected now verify the list of the databases see these are the list of the databases or schemas comes with Marb installation let us verify the version of the Marb that we have installed select version put semicolon see we have installed MB 11.3 after installation we have to set the password for root user that is Alter user root identified by provide the password okay we have to give like in quotations at theate again quotation Local Host then hit enter have successfully set the password exit then Maria DB control L Maria DB hyphen U root hyphen P then provide the new password see we have successfully connected let us create a database in this Mar command is create database R schools we have successfully created verifi show data databases see new database is there okay now switch to AR School see here it is showing none means no database selected R2 schools see now we have the R2 schools database suppose if you want to create a table in this database create table let me clear the screen control L create table student SN int s name whereare put semicolon successfully created verify the tables in this database so tables see we have one table also verify the data in this table we throw Zero Records because it's a this new table see empty set let us insert some data into this table insert into student values this type we have to give the same quotations hit enter and insert one more row control ly data select star from student see we have the two rows if we want to see the list of the users select use user from MySQL do user see we have the these users let us create a user control n create user J identify ified by password we have to give the password here I'm giving always give the strong password see we have successfully created again ify the user is created up see user is there okay now exit and try to connect to this Maria DB with the new user to exit from Maria DB you have to use the exit so contrl L Maria DB hyph new new username hyph P then see I have connected but you are but we are unable to switch to after school because I haven't granted the permission see in the upcoming videos I will show you how to Grant privileges to user okay also verify the current user current user see I I have connected with this James user okay even we are unable to create table or database create database James DB see we don't have the permission okay exit now we will see how to stop start and restart the Marb service on open to sudo system CTL stop Maria DB now try to connect to Maria DB see we are unable to because Mar server is stopped let us start it just replace the stop with start and hit enter now try to connect marad see we will be able to connect okay exit verify the status replace this stop with status see we have successfully restarted 15 seconds ago qu to quit control L to clear screen you want to restart the Marb service sudo system CTL restart Mar okay so in this video we have seen how to install and configure marad B 11 version on 22204 but the process is same for all open to versions and Marb versions for more my skill Marb or Linux tutorials please subscribe my channel thank you

Channel: r2schools

Views: 91

Keywords: Install MariaDB 11 on Ubuntu 20.04, MariaDB Install on Ubuntu 20.04, MariaDB install in Ubuntu 22.04, MariaDB installation on Ubuntu 22.04, Install MariaDB 11 on Ubuntu Linux, MariaDB Install on Ubuntu Linux, MariaDB install in Ubuntu Linux, MariaDB installation on Ubuntu Linux, MariaDB Tutorials, MariaDB 11.3 Install on Ubuntu Linux, MariaDB 11 install Ubuntu Linux, MariaDB 11 install Ubuntu 20.04, MariaDB 11 install Ubuntu 22.04, Install MariaDB on Ubuntu 22.04, mariadb ubuntu

Id: 7Hp742eMdCU

Length: 10min 2sec (602 seconds)

Published: Mon Apr 15 2024