NVIDIA GTX Graphics Cards | eBay
Buy best selling Linux books

<< View All Computer Tips

Added On: 26/05/18   |    Category: Ubuntu    |    Number of Views: 798

Install MariaDB Database in Ubuntu and other Ubuntu based distributions (Part 1)   

Part 1: Install MariaDB in Ubuntu
Part 2: Create a new user

To install MariaDB Database server in Ubuntu and other Ubuntu based distributions enter the following command in your terminal

sudo apt-get install mariadb-server

When MariaDB Database installs it will ask you to set a root password. If you plan to host your own MariaDB Database(s) online it is advisable to set a root password. If your just planning on hosting a local database to practice on, you can skip the root password.



After MariaDB Database has installed you need to login via the Terminal.

To login to MariaDB enter the following command in the terminal
mysql -u root -p


You will be asked to enter your root password, the one you set up whilst installing MariaDB. If you didn't enter a password just click enter.

If you logged in correctly, the MariaDB prompt will be displayed in the terminal.
From here you can create, insert, update, delete, databases, tables, create new users.

The Linux Foundation

Best selling Unix / Linux books
Nvidia Graphics Cards
Save 15% off .CO.UK domains at 123-Reg
Save 15% off .COM domains at 123-Reg
cPanel Hosting Plans
Xilo Web Hosting Plans