.

Lägga till eller radera MySQL-databas med hjälp av Terminal - VPS ADMIN # 4

English

Engelska (change)

English

Italian

Korean

Chinese (Simplified)

Chinese (Traditional)

Portuguese

German

French

Spanish

Japanese

Arabic

Russian

Greek

Dutch

Bulgarian

Czech

Croatian

Danish

Finnish

Polish

Swedish

Norwegian

Hebrew

Serbian

Slovak

Thai

Turkish

Hungarian

Romanian

Bens Translator

Upprätthålla unmanaged VPS - Del 4: Skapa eller Bin MySQL DBs använda Terminal

20 juli

Den här handledningen visar upp två ganska grundläggande men händig MySQL verksamhet, skapa och Binning en databas med hjälp av terminalen gränssnitt.

Visst, du kan göra dem med, säg, phpMyAdmin, men det är sättet snabbare att utföra dessa funktioner via CLI.

Substitute "DB_Username", "DB_PASSWORD", "DB_PASSWORD" och "db_name" med de egna.

Inrätta en unmanaged VPS (4 Newbies) .. VPS Bibeln

I 20 copy / paste steg .. från noll till hjälte, tomma rutan för söt-som Linux-server.

Bläddra nedåt för hela serien index.

Så, hey, skjul delade & viva virtuellt! Hoppas det hjälper. The_guv

Lägg till en MySQL databas

Från kommandoraden gränssnittet, måste vi först få tillgång till 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

Intro: Set Up an Unmanaged VPS (4 Newbies) .. The V-P-S Bible

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 *
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.

MAINTAIN an Unmanaged VPS (4 Newbies) .. V-P-S ADMIN

Congratulations! You have one humdinger of a web server! If you followed the Bible to a T, it's speedy, solid & secure.

But. As explained in Part 16 , the Nginx web server has no compatible control panel .. yet. Then again, even if it did, do you really want the resource drain?

In the VPS Admin series is every maintenance procedure you'll need to know. And, hey, using these is a darn sight faster than using a control panel anyhow.

Set it up? Click here for the 21 part follow-up .. V-P-S Admin

Go back? Click here for the original series .. The V-P-S Bible
1. Intro: Set Up an Unmanaged VPS (4 Newbies) .. The V-P-S Bible
1. Intro: Maintain Unmanaged VPS (4 Newbies) .. V-P-S Admin
1. Add Web Sites Nginx Cheatsheet
2. Adding Sub-Domains with Nginx
3. MySQL Database Maintenance - Terminal Tips
4. Add/Delete MySQL Database from Command Line
5. phpMyAdmin & Nginx to Maintain Databases
6. Backup/Export MySQL DB with CLI & mysqldump
7. Import Data to MySQL Database from Terminal
8. Batch Replace/Delete Data in MySQL Database
9. Reset a Lost MySQL Password
10. Backup or Upload with Secure Copy SCP (Linux/Linux)
11. Backup or Upload with PuTTY PSFTP (Windows/Linux)
12. Gain Benefit From Parked Domains
13. Password Protect Nginx Web Files/Directories
14. Redirect Web Pages with Nginx Rewrite Rule
15. Create Custom Website Error Page
16. Access Web Site Error Logs
17. Set up Cron Jobs
18. Using Network Tools
19. Hotlink Protect (Bandwidth)
20. IP Deny to Block Access with Nginx
21. Subversion vs Fantastico - Platform Update
1. Something missing? Crack out a comment and let me know.
1. * Includes video tutorial.
2. 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 [...]
... maybe you'll like these?

Posted on Monday, July 20th, 2009

Tags: Guvnr-news , web-design

Subscribe to Comments by RSS Trackback from your blog

THE_GUV NEEDS YOU!!

.. to improve this post ..

Please clue me in. What's wrong or missing?

Or, hey, just pile on the praise ;) Ah, yup, and fix a feed, fella.

Or link the page to your social network!

thank you, thanx, tx, ta, t, tsst, twaddle, cheek, cheers, cheerio

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 [...]

Say Something

.