MariaDB - First use
Posted: Sun Aug 18, 2013 2:34 pm
Hi,
I need to practice on SQL, thus I've installed MariaDB (mariadb-server through Ubuntu repository) on my laptop.
Can anybody share with me a Beginners Guide on how to set up everything and getting started?
I have a basic knowledge of the SQL language (I'm using it at work via MS SQL Server 2008) but never set up the server and client.
To practice I've downloaded a .sql database offered by Microsoft and saved it on this path:
/usr/bin/northwind_mysql.sql
The issue is that I don't know how to start and import the database. I've never really used it through command line.
To start MariaDB I use this command, although I'm not really sure is the best practice (I don't like to run any program as root)
Thank you,
Gianluca
I need to practice on SQL, thus I've installed MariaDB (mariadb-server through Ubuntu repository) on my laptop.
Can anybody share with me a Beginners Guide on how to set up everything and getting started?
I have a basic knowledge of the SQL language (I'm using it at work via MS SQL Server 2008) but never set up the server and client.
To practice I've downloaded a .sql database offered by Microsoft and saved it on this path:
/usr/bin/northwind_mysql.sql
The issue is that I don't know how to start and import the database. I've never really used it through command line.
To start MariaDB I use this command, although I'm not really sure is the best practice (I don't like to run any program as root)
Code: Select all
gianluca@gianluca-Aspire-S3-391 ~ $ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 37
Server version: 5.5.32-MariaDB-1~raring-log mariadb.org binary distribution
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Gianluca