添加或刪除MySQL數據庫使用終端-車輛定位系統後台管理＃4
保持非託管車輛定位系統-第4部分：創建或本MySQL的使用終端區議會
這種操作方法，以指導映射出兩個非常方便，但MySQL的基本操作，創建和裝倉數據庫，使用終端接口。
當然，你可以做的，比如說，phpMyAdmin的，但它的方法更快地履行這些職能的使用CLI。
以“db_username”，“db_password”，“db_password”和“db_name”與那些你自己的。
成立了一個非託管車輛定位系統（4新成員）.. 聖經的車輛定位系統
在20個複製/粘貼操作.. 從零到英雄，空白方塊可愛的Linux服務器。
所以，嘿，下跌共享與虛擬萬歲！希望有所幫助。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 [...]