This page has been translated from English
.

הוספה או מחיקה של מסד הנתונים MySQL באמצעות מסוף - VPS ADMIN # 4

English אנגלית (שינוי)
  • Digg
  • Twitter
  • Technorati
  • del.icio.us
  • Facebook
  • MySpace
  • Reddit
  • StumbleUpon
  • LinkedIn
  • email

לשמור VPS שאינם מנוהלים - חלק 4: צור או סל MySQL DBS באמצעות מסוף

יולי 20
הלוגו של מסד הנתונים MySQL

זה מדריך כיצד לבצע את שתי מפות די בסיסי אבל נוח פעולות MySQL, יצירה binning מסד נתונים, באמצעות ממשק מסוף.

בטח, אתה יכול לעשות עם אלה, אומרים, phpMyAdmin, אבל זה בדרך מהירה יותר כדי לבצע פעולות כאלה באמצעות CLI.

"Substitute db_username", "db_password", "db_password" ו "db_name" עם אלה שלך.

להגדיר VPS שאינם מנוהלים (4 newbies) .. התנ"ך VPS

בעותק 20 / צעדים להדביק .. מאפס לגיבור, התיבה ריקה כדי חמוד-כשרת לינוקס.

גלול מטה על מדד סדרת מלא.

אז, היי, מחסן משותף & Viva וירטואלי! 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

  1. Intro: Set Up an Unmanaged VPS (4 Newbies) .. The V-P-S Bible
  1. VPS (Virtual Private Server) vs Shared vs Dedicated
  2. Set Up a VPS Linux Distribution   *
  3. Set Up the Command Line Interface (CLI) using PuTTY   *
  4. Create a Linux User & Set Permissions   *
  5. Encrypt Data with OpenSSH & Auto-Login with PuTTY   *
  6. Harden the Secure Shell (SSH) & Create a Firewall   *
  7. Edit bashrc for User-Friendly Linux, plus System Updates   *
  8. PHP5, MySQL, Xcache, Subversion (for Platforms like WordPress)   *
  9. Add a Domain Zone to Your VPS   *
  10. Prepare Linux Server for Email with Postfix   *
  11. Nginx (better than Apache) Web Server   *
  12. Setup FileZilla for Secure FTP (SFTP)   *
  13. Serve Multiple Sites & Blogs with Virtual Hosts   *
  14. Set up WordPress on Nginx with Pretty URLs & WP Super Cache   *
  15. WordPress Setup & Updates from the Command Line   *
  16. Nginx Control Panel
  17. Nginx Control Panel Workarounds
  18. Google Apps for Domain-Specific Email   *
  19. Moving Day! How to Move Your Blog or Site
  20. Blogroll, Links, Credits, Resources
Posted on Monday, July 20th, 2009
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



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

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

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

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

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

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


.