ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4
Maintain Unmanaged VPS - Part 4: Create or Bin MySQL DBs using the Terminal
This how-to guide maps out two pretty basic but handy MySQL operations, creating and binning a database, using the terminal interface.
Sure, you can do those with, say, phpMyAdmin, but it's way quicker to perform such functions using the CLI.
Substitute "db_username", "db_password", "db_password" and "db_name" with those of your own.
Set Up an Unmanaged VPS (4 Newbies) .. The V-P-S Bible
In 20 copy/paste steps .. from zero to hero, blank box to cute-as Linux server.
Scroll down for the full series index.
So, hey, shed shared & viva virtual! Hope it helps. the_guv
Add a MySQL Database
From the command line interface, we need first to access the mysql shell:-
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 [...]