Difference between revisions of "Databases"
Adelo Vieira (talk | contribs) (→MySQL) |
Adelo Vieira (talk | contribs) (→Instalación de MySQL) |
||
| Line 20: | Line 20: | ||
sudo mysql_secure_installation | sudo mysql_secure_installation | ||
| − | To initialize the MySQL data directory, you would use mysql_install_db for versions before 5.7.6 | + | To initialize the MySQL data directory, you would use: |
| + | mysql_install_db (for versions before 5.7.6) | ||
| + | mysqld --initialize (for 5.7.6 and later) | ||
| + | |||
| + | However, if you installed MySQL from the Debian distribution, like in Step 1, the data directory was initialized automatically; you don't have to do anything. If you try running the command anyway, you'll see the following error: | ||
'''Step 3 — Testing MySQL:''' | '''Step 3 — Testing MySQL:''' | ||
| Line 33: | Line 37: | ||
For an additional check, you can try connecting to the database using the mysqladmin tool: | For an additional check, you can try connecting to the database using the mysqladmin tool: | ||
mysqladmin -p -u root version | mysqladmin -p -u root version | ||
| − | |||
| − | |||
===PhpMyAdmin=== | ===PhpMyAdmin=== | ||
Revision as of 15:40, 19 September 2017
A database is an organized collection of data.[1] It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database
Contents
SQL
SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). https://en.wikipedia.org/wiki/SQL
Database management system
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. https://en.wikipedia.org/wiki/Database
MySQL
MySQL est un système de gestion de bases de données relationnelles (SGBDR). Il fait partie des logiciels de gestion de base de données les plus utilisés au monde. En informatique, un système de gestion de base de données (abr. SGBD) est un logiciel système destiné à stocker et à partager des informations dans une base de données. SQL fait référence au Structured Query Language, le langage de requête utilisé. SQL (sigle de Structured Query Language, en français langage de requête structurée) est un langage informatique normalisé servant à exploiter des bases de données relationnelles.
Instalación de MySQL
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04
Step 1 — Installing MySQL:
sudo apt-get update sudo apt-get install mysql-server
Step 2 — Configuring MySQL:
sudo mysql_secure_installation
To initialize the MySQL data directory, you would use:
mysql_install_db (for versions before 5.7.6) mysqld --initialize (for 5.7.6 and later)
However, if you installed MySQL from the Debian distribution, like in Step 1, the data directory was initialized automatically; you don't have to do anything. If you try running the command anyway, you'll see the following error:
Step 3 — Testing MySQL:
Regardless of how you installed it, MySQL should have started running automatically. To test this, check its status:
systemctl status mysql.service
If MySQL isn't running, you can start it with:
sudo systemctl start mysql.
For an additional check, you can try connecting to the database using the mysqladmin tool:
mysqladmin -p -u root version
PhpMyAdmin
PMA est une application Web de gestion pour les systèmes de gestion de base de données MySQL réalisée en PHP et distribuée sous licence GNU GPL.
MySQL shell
A través de la línea de comando
Oracle Database
C'est un système de gestion de base de données relationnelle (SGBDR)
Oracle SQL Developer
C'est un environnement de développement intégré (EDI) multi-plateforme, fourni gratuitement par Oracle Corporation et utilisant la technologie Java (Java Development Kit). C'est un outil graphique permettant d'interroger des bases de données Oracle à l'aide du langage SQL.
