AÑADIR O ELIMINAR base de datos MySQL utilizando Terminal - VPS ADMIN # 4
Mantener VPS administrado - Parte 4: Crear o bin de MySQL DBs usar la terminal
Esta guía de instrucciones mapas a cabo dos operaciones de MySQL bastante básico, pero práctico, la creación y hurgar en la basura una base de datos, utilizando la interfaz del terminal.
Claro, usted puede hacer los que tienen, por ejemplo, phpMyAdmin, pero es la manera más rápida de realizar estas funciones mediante la CLI.
"Suplente db_username", "password", "password" y "db_name" con los de su cuenta.
Configurar una VPS no administrado (4 principiantes) .. La Biblia VPS
En 20 de copiar / pegar pasos .. de cero a héroe, el cuadro en blanco a cute-como servidor de Linux.
Desplácese hacia abajo para el índice de la serie completa.
Así que, hey, cobertizo compartida y viva virtual! Espero que ayuda. The_guv
Añadir una base de datos MySQL
Desde la interfaz de línea de comandos, primero tenemos que acceder a la shell de MySQL: --
mysql -u root -p
And before actually creating the db, you need to set up the database user and password.
grant all privileges on *.* to db_username@localhost identified by "db_password";
Now create the db:-
create database db_name;
And exit the MySQL shell:-
quit
Delete a MySQL Database
Easy tiger! From the command line interface, we need first to access mysql:-
mysql -u root -p
And delete the sucker:-
delete database db_name;
And here's an alternative way to exit the MySQL shell:-
\q
SETUP an Unmanaged VPS (4 Newbies) .. The V-P-S Bible
Serve multi sites & blogs on a budget .. at the fastest possible speed .. with the least downtime .. in the most secure environment .. and future-proofed for easy admin.
That's what the VPS Bible is about, stepped out in simple copy & paste guides.
From high traffic WordPress blogs to startup web hosts, here's what you need.
Set it up? Click here for the 21 part follow-up .. V-P-S Admin
- VPS (Virtual Private Server) vs Shared vs Dedicated
- Set Up a VPS Linux Distribution *
- Set Up the Command Line Interface (CLI) using PuTTY *
- Create a Linux User & Set Permissions *
- Encrypt Data with OpenSSH & Auto-Login with PuTTY *
- Harden the Secure Shell (SSH) & Create a Firewall *
- Edit bashrc for User-Friendly Linux, plus System Updates *
- PHP5, MySQL, Xcache, Subversion (for Platforms like WordPress) *
- Add a Domain Zone to Your VPS *
- Prepare Linux Server for Email with Postfix *
- Nginx (better than Apache) Web Server *
- Setup FileZilla for Secure FTP (SFTP) *
- Serve Multiple Sites & Blogs with Virtual Hosts *
- Set up WordPress on Nginx with Pretty URLs & WP Super Cache *
- WordPress Setup & Updates from the Command Line *
- Nginx Control Panel
- Nginx Control Panel Workarounds
- Google Apps for Domain-Specific Email *
- Moving Day! How to Move Your Blog or Site
- Blogroll, Links, Credits, Resources
- * Includes video tutorial.
- Not linked = not published. Won't be long. Fix a feed for updates.
If you liked that ...
-
Maintain Unmanaged VPS - Part 6: Backup a MySQL Database from the Terminal
This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure. Just replace the db name, username and password and paste the code into your [...] -
Maintain Unmanaged VPS - Part 7: Reinstate MySQL DBs with Terminal Shell
This guide provides the syntax for uploading data to a MySQL database. For instance, you've changed Linux server, have added a blank database and now want to add your previously backed up data. Just replace the db [...] -
Maintain Unmanaged VPS - Part 8: Update (Replace or Delete) MySQL Data
Change repetitive db data with one single syntax command. Rather than manually find & alter each instance, isolate the lot & update multiple content. This is handy when you want to swap or lose an identical [...] -
Maintain Unmanaged VPS - Part 9: Reset a Lost MySQL Password
So you've gone and locked yourself out of MySQL? Feels a bit like leaving the car keys in the trunk, huh? :D Sorry to laugh! But I can, 'cos I'm gonna show you how to get back in. It's really not so tough. Using [...] -
Set Up Unmanaged VPS (4 Newbies) - Part 4: Create a Linux User & Set Permissions
This tutorial steps out how to create a Linux user and set permissions. It can be used as part of the VPS Bible 20-Part series, else as a standalone guide. Just thought I'd clear that up. Before carrying on [...] -
NGINX VPS ADMIN SERIES UNDERWAY - And I Thought It Was Beer-O-Clock!
When I started this series I figured I'd cover it in maybe 7 or 8 posts. I had more hair in those days, and you were younger too. Apart from underestimating the subject, fact is, with the intended audience for the [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : hostingwebsitereviews.com July 20th, 2009 at 1:56 pm
[...] Read more from the original source: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : websiteshostingreviews.com July 20th, 2009 at 1:58 pm
[...] Continue reading here: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : Best Web Hosting Review Website July 20th, 2009 at 3:16 pm
[...] More here: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : tntwebhostings.com July 20th, 2009 at 3:27 pm
[...] Continue reading here: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR | Green Web hosting July 20th, 2009 at 3:40 pm
[...] from: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR Top 5 Green Web Hosting Companies, Click [...]
ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : hostwebsitereview.com July 20th, 2009 at 3:43 pm
[...] Read the original: ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR [...]