Menú Cerrar
servidor de base de datos

En las entradas anteriores vimos una introducción a las bases de datos en la cual te expliqué lo que es una base de datos, cómo se construye y los tipos que existen, si no lo has leído te sugiero que lo hagas haciendo click aquí. Te expliqué en una segunda entrada qué son las llaves y su importancia en una base de de datos. Ahora, vamos a ver qué es un servidor de base de datos, su importancia y cuál deberías usar dependiendo de tu sistema operativo.

Servidor de base de datos

De las aplicaciones que vimos en la primera entrada, y de las otras millones que existen, ya estamos de acuerdo que implica la existencia de una base de datos. ¿Te has preguntado dónde están estas bases de datos? Bueno, todas están en un servidor de base de datos.

Un servidor de base de datos o Sistema de Gestión de Base de Datos Relacionales (RDBMS) es un software de servidor que permite la organización de la información mediante el uso de tablas, índices y registros. Para acceder al servidor, RDBMS como MySQL usa un modelo cliente-servidor.

A continuación, vamos a ver los más comunes y sobretodo gratis para instalar dependiendo de tu sistema operativo.

servidor de base de datos WAMP

Las siglas significan Windows Apache MySQL y PHP, es el RDBMS que se utiliza en plataformas Windows. Viene completo, el acceso a las bases de datos se puede hacer de dos formas: usando la consola de MySQL o a través de phpMyAdmin.

Servidor de base de datos WAMP
Logo de WAMP

Su instalación es bastante sencilla, dirígete a la página oficial y descarga la versión de 32 o 64 bits dependiendo de la arquitectura de tu equipo. Ejecuta el .exe y en la opción para el cliente puedes elegir MySQL o MariaDB, te aconsejo MySQL. Si todo va bien, el ícono debe aparecer en verde, cualquier otro color (naranja o rojo) significa que algo anda mal. Si es así deja un comentario y te ayudo.

Para acceder, haz click en el ícono y elige la consola de MySQL, si tienes contraseña hay que ingresarla y listo. Como no has creado ninguna base datos, están las que vienen por defecto. Ejecuta el comando show databases; y podrás ver la lista.

LAMP

Linux Apache MySQL/MariaDB PHP es el RDBMS para sistemas Linux. Si tienes Windows o MAC, puedes saltarte esta parte.

servidor de base de datos LAMP

La instalación es más complicada, aunque para un usuario de Linux es el pan de cada día siempre que se trata de instalaciones.

Para hacerlo, sigue los pasos que vienen a continuación:

Abre una terminal e ingresa sudo apt-get install seguido de:

  1. apache2
  2. php
  3. php-mysql
  4. mysql-server

Se te solicitará establecer una contraseña para el usuario raíz de MySQL. Una vez hecho esto, continúa con la instalación ingresando los siguientes comandos después de sudo apt-get install:

  1. libapache2-mod-php
  2. php-mcrypt
  3. phpmyadmin

Deberás elegir qué servidor quieres utilizar. Selecciona Apache presionando la tecla enter. Selecciona no para configuración avanzada del servidor.

Cambiando permisos al directorio /var/www/html

Para que los scripts y archivos PHP puedan ser ejecutados por el servidor LAMP deberán ser almacenados en el directorio /var/www/html. Esta es la ubicación de tu servidor local.

Tendrás que cambiar los permisos de este directorio para que se te permita hacer cambios en él. Hazlo ingresando este comando en la terminal:

sudo chown {tu_usuario_ubuntu} /var/www/html

Creando un enlace simbólico a phpMyAdmin

De manera predeterminada, phpMyAdmin se instala en el directorio /usr/share. Necesitas enlazarlo al directorio de tu servidor local.

Dirígete al directorio del servidor en donde quieres el enlace con este comando: cd /var/www/html

Crea el enlace simbólico ingresando el comando ln -s /usr/share/phpmyadmin phpmyadmin.

Reiniciando Apache y probando

Ejecuta el siguiente comando para reiniciar Apache, estableciendo los cambios que has realizado:

sudo systemctl restart apache2

MAMP

Mac Apache Mysql PHP es el RDBMS para sistemas Mac.

Su instalación también es muy sencilla, sigues estas instrucciones que vienen a continuación para hacer.

  1. Descarga “MAMP & MAMP PRO” en este enlace.
  2. Doble click en el archivo descargado y el sistema te guiará a la instalación.

Resumen

En esta entrada dimos el primer paso hacia nuestro objetivo: crear y gestionar bases de datos. En la próxima entrada te explicaré algo muy importante: Las relaciones en una base de datos, los tipos y para qué sirven.

Revisa las entradas relacionadas y no olvides dejar un “Me gusta” si el artículo te gustó. ¿Quieres ponerte a prueba? Responde mi trivia sobre base de datos aquí.

Acerca del autor

Saintus Zephir

Ingeniero en Sistemas Computacionales y estudiante de Maestría en Ciencias en Ingeniería y Tecnologías Computacionales en el Centro de Investigación y de Estudios Avanzados del IPN (CINVESTAV-IPN).

Comparte el artículo en tus redes sociales

Artículos relacionados

39 comentarios

  1. Edmundo

    Hello, I enjoy reading through your article post. I wanted to write
    a little comment to support you.

  2. Antwan

    Very soon this site will be famous amid all blog people, due to it’s nice posts

  3. Gay

    What i don’t understood is in truth how you’re now not
    really much more well-preferred than you might be now.
    You’re so intelligent. You know therefore considerably in relation to this matter,
    produced me individually consider it from numerous varied angles.
    Its like men and women don’t seem to be involved unless it is something to accomplish
    with Lady gaga! Your individual stuffs nice.

    All the time handle it up!

  4. tinyurl.com

    Hmm it looks like your site ate my first comment (it
    was super long) so I guess I’ll just sum it up what
    I had written and say, I’m thoroughly enjoying your blog.
    I as well am an aspiring blog writer but I’m still new to the whole thing.
    Do you have any tips and hints for inexperienced blog writers?
    I’d definitely appreciate it.

  5. tinyurl.com

    Hello, this weekend is good designed for me, since this
    time i am reading this enormous informative post here at my residence.

  6. tinyurl.com

    It’s awesome to pay a visit this web page and reading the views of all friends regarding this paragraph, while I am also
    eager of getting familiarity.

  7. http://tinyurl.com/y8pdvmlm

    Hello! I know this is kind of off topic but I
    was wondering if you knew where I could get a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having problems
    finding one? Thanks a lot!

  8. http://tinyurl.com

    Nice post. I used to be checking constantly this blog and I’m
    inspired! Very useful information specifically the
    closing phase 🙂 I deal with such information much. I used to be seeking this particular information for a very long time.

    Thanks and best of luck.

  9. how to find the cheapest flights

    Magnificent beat ! I wish to apprentice while you amend
    your site, how could i subscribe for a blog
    site? The account helped me a acceptable deal. I had been tiny bit acquainted
    of this your broadcast provided bright clear idea

  10. cheap flight tickets

    Hmm it seems like your website ate my first comment (it was super long)
    so I guess I’ll just sum it up what I had written and say,
    I’m thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to everything.
    Do you have any helpful hints for novice blog writers?
    I’d genuinely appreciate it.

  11. insanely cheap flights

    Right here is the perfect website for anyone who wishes to understand
    this topic. You know so much its almost tough to argue with you (not that I really will
    need to…HaHa). You certainly put a fresh spin on a topic which has been written about for ages.
    Wonderful stuff, just great!

  12. cheap flights domestic

    Very nice post. I just stumbled upon your blog and wished to say that I’ve truly enjoyed surfing
    around your blog posts. In any case I’ll be subscribing to your rss feed and I hope you write again soon!

  13. cheap flights now

    Hello just wanted to give you a quick heads up. The text in your content seem
    to be running off the screen in Firefox. I’m not sure if
    this is a format issue or something to do with browser compatibility
    but I figured I’d post to let you know. The design look great though!
    Hope you get the problem resolved soon. Many thanks

  14. gamefly

    I like the helpful info you provide in your articles. I will bookmark your blog
    and check again right here frequently. I’m
    relatively certain I will be told lots of new stuff right right here!

    Best of luck for the next!

  15. gamefly

    Hi there just wanted to give you a quick heads up. The words in your content seem to be
    running off the screen in Internet explorer. I’m not sure if this is a formatting issue or something to do with
    browser compatibility but I figured I’d post to let you know.
    The style and design look great though! Hope you get the
    issue resolved soon. Kudos

  16. tinyurl.com

    This website was… how do I say it? Relevant!!
    Finally I’ve found something which helped me. Thanks!

  17. bit.ly

    What’s up all, here every one is sharing these knowledge, so it’s good to read this blog, and I used to pay a visit this web site every day.

  18. http://t.co/z80GvGJTCG

    Howdy! Quick question that’s entirely off topic.
    Do you know how to make your site mobile friendly?
    My web site looks weird when viewing from my iphone. I’m trying to find a template or plugin that might
    be able to fix this problem. If you have any recommendations, please share.
    With thanks!

  19. tinyurl.com

    Thanks for another magnificent post. The place else may just anybody get that kind of info in such an ideal way of writing?
    I have a presentation next week, and I am at the look for such info.

  20. tinyurl.com

    Hello i am kavin, its my first time to commenting anywhere,
    when i read this article i thought i could also make comment due to this brilliant article.

  21. http://tinyurl.com/4javwvhk

    Somebody essentially help to make seriously posts I’d state.
    This is the first time I frequented your website page and
    so far? I surprised with the research you made to create this particular post incredible.

    Great activity!

  22. tinyurl.com

    Have you ever thought about writing an e-book or guest authoring on other
    blogs? I have a blog based upon on the same topics you
    discuss and would love to have you share some
    stories/information. I know my visitors would appreciate your work.
    If you are even remotely interested, feel free to shoot
    me an e-mail.

  23. http://tinyurl.com/27ycppf9

    Hey there! This is my first comment here
    so I just wanted to give a quick shout out and say I really enjoy reading your posts.
    Can you suggest any other blogs/websites/forums that cover the same subjects?
    Thanks for your time!

  24. http://tinyurl.com

    Currently it appears like Movable Type is the preferred blogging platform available right now.
    (from what I’ve read) Is that what you are using on your
    blog?

  25. tinyurl.com

    Why viewers still make use of to read news papers when in this technological globe everything is presented on web?

  26. http://tinyurl.com/2oh7zxsw

    It’s actually a great and helpful piece of information. I
    am satisfied that you just shared this useful info with us.

    Please stay us informed like this. Thank you for sharing.

  27. http://bit.ly/3ADfdAb

    Link exchange is nothing else except it is
    only placing the other person’s weblog link on your page at proper
    place and other person will also do similar for you.

  28. tinyurl.com

    Howdy! Quick question that’s totally off topic.
    Do you know how to make your site mobile friendly?

    My site looks weird when browsing from my apple iphone.
    I’m trying to find a template or plugin that might be able to
    resolve this issue. If you have any suggestions, please share.
    Thank you!

  29. t.co

    It’s remarkable for me to have a website, which is helpful in favor of
    my knowledge. thanks admin

  30. tinyurl.com

    What i don’t realize is in reality how you are now not actually
    much more well-preferred than you might be now. You are very intelligent.
    You already know thus considerably in the case of this matter, produced
    me for my part imagine it from numerous various angles.
    Its like women and men aren’t fascinated except it is something to accomplish with
    Lady gaga! Your individual stuffs outstanding. All the time deal with it
    up!

  31. tinyurl.com

    Hello to all, the contents existing at this web site are truly amazing for people experience, well,
    keep up the good work fellows.

  32. shadowaccord.nwlarpers.org

    Hey There. I found your blog using msn. This
    is a really well written article. I’ll be sure to bookmark it and come back to read
    more of your useful information. Thanks for the post.
    I will certainly return.

  33. tinyurl.com

    First of all I would like to say awesome blog! I had a quick question that I’d like to ask if you do not mind.

    I was interested to know how you center yourself and clear your mind before
    writing. I’ve had a hard time clearing my mind in getting
    my ideas out there. I do take pleasure in writing however it
    just seems like the first 10 to 15 minutes are wasted just trying to figure
    out how to begin. Any ideas or hints? Many thanks!

  34. tinyurl.com

    Excellent beat ! I wish to apprentice whilst you amend your
    site, how can i subscribe for a blog site?

    The account helped me a appropriate deal. I were a
    little bit acquainted of this your broadcast offered bright transparent
    concept

  35. http://tinyurl.com

    Do you mind if I quote a few of your articles as long as I provide credit and sources back to your weblog?

    My blog site is in the very same area of interest as yours and my users would
    truly benefit from some of the information you present
    here. Please let me know if this alright with you.
    Many thanks!

Deja una respuesta

Tu dirección de correo electrónico no será publicada.

× ¿Cómo puedo ayudarte?