MariaDB - First use

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
I am Gianluca
Level 1
Level 1
Posts: 14
Joined: Sun Aug 18, 2013 2:22 pm

MariaDB - First use

Post by I am Gianluca »

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)

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)]> 
Thank you,

Gianluca
User avatar
z1p101
Level 1
Level 1
Posts: 31
Joined: Tue Jul 24, 2012 7:29 pm

Re: MariaDB - First use

Post by z1p101 »

You could install MySQL Workbench using the package installer. It is a good and fairly straight forward GUI front end that works fine with MariaDB and could help you. Or if you just need to practice with SQL, Netbeans and Java DB/Derby make a good pair. [url=http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html]Or you could start with the instructions here.[/url] A .sql file is just a text file that contains SQL commands like CREATE DATABASE/INSERT INTO TABLE/etc. so you don't have to type it all yourself.
Post Reply

Return to “Software & Applications”