Nextelco:DB

From its-wiki.no
Jump to: navigation, search

DB

The data base will be used to store all the necessary information for the AAA server. For this installation MySQL will be used. It's free and powerful enough for the type of installation that we are dealing with. MySQL is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MySQL are speed, robustness and ease of use.

Currently, the mysql-server version available at Debian 7.5 repositories is 5.5.37.


Installation

In order to install the mysql server we just need to invoque the next command:

# apt-get install mysql-server

During the installation of the server it will ask us about a password for the root user. Just answer with a new password and the installation will be completed.


Test

In order to test our installation we just need to login as root.

# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.5.37-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>quit;
Bye

If everything goes fine, we will be able to connect, query databases and quit.


Return to Application Server page.

Return to Technology page.