Προσθήκη ή Διαγραφή βάσεων δεδομένων MySQL χρησιμοποιώντας Terminal - VPS ADMIN # 4
Διατηρείται Unmanaged VPS - Μέρος 4: Δημιουργία ή Bin MySQL DBS χρησιμοποιώντας το Terminal
Αυτό πώς-με οδηγό χάρτες επισημάνω δύο πολύ βασικά αλλά εύχρηστο MySQL επιχειρήσεις, δημιουργία και Binning μιας βάσης δεδομένων, χρησιμοποιώντας τη διασύνδεση των τερματικών.
Σίγουρα, μπορείτε να κάνετε με αυτά, ας πούμε, phpMyAdmin, αλλά είναι τρόπος γρηγορότερα για να εκτελεί τα καθήκοντα που χρησιμοποιούν το CLI.
Αναπληρωτής "db_username", "db_password", "db_password" και "db_name" με εκείνες της δικής σας.
Εγκατάσταση Unmanaged VPS (4 Newbies) .. Η VPS Bible
Σε 20 copy / paste βήματα .. από το μηδέν σε ήρωα, κενό το πλαίσιο για την χαριτωμένη-ως server Linux.
Μετακινηθείτε προς τα κάτω για το πλήρες ευρετήριο σειρά.
Έτσι, hey, υπόστεγο κοινές & εικονικής ζήτω! Hope it helps. The_guv
Προσθέστε δεδομένων MySQL
Από το περιβάλλον γραμμής ε ÎÏÏ Ïο ÏεÏιβάλλον γÏÎ±Î¼Î¼Î®Ï ÎµÎ½ÏολÏν, θα ÏÏÎÏει ÏÏÏÏα να ÎÏει ÏÏÏÏβαÏη ÏÏον 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 [...]