{"id":1368,"date":"2021-08-19T21:39:57","date_gmt":"2021-08-19T16:09:57","guid":{"rendered":"https:\/\/myfreeonlinetools.com\/blog\/?p=1368"},"modified":"2021-10-02T10:34:57","modified_gmt":"2021-10-02T05:04:57","slug":"ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database","status":"publish","type":"post","link":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/","title":{"rendered":"SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database"},"content":{"rendered":"

How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH.<\/p>\n

List of all commands used in SSH for creating a new database, insert the record into the selected database, Alter the table column, login database by SSH client (Putty).
\nBelow mention basic and useful commands to maintaining SSH Client (Putty).
\nFor the first day of class, start by login using SSH client, putty for learning and access the Shell putty line commands,<\/p>\n

SSH Client (Putty) Commands.<\/h2>\n

For access the MySQL and open the SSH SQL Monitor\/ Terminal.<\/h3>\n
mysql -u [username] -p;<\/pre>\n
or<\/p>\n
sudo mysql -u [username] -p;\r\n<\/pre>\n
Why use Sudo. [Read Below].<\/p>\n
[username] used when login the ssh or connect with FTP.<\/p>\n
for Example<\/p>\n
sudo mysql -u root -p;<\/pre>\n
Select a specifed database with SSH command and login to MySQL.<\/h3>\n
mysql -u [username] -p [database];\r\n<\/pre>\n
or<\/p>\n
sudo mysql -u [username] -p [database];<\/pre>\n
Include Sudo in MySQL command to allow a permitted user to execute a command as the superuser or another user.<\/p>\n
Create a new database.<\/h3>\n
create database [database_name];<\/pre>\n
and create a database with Character set utf8mb4<\/p>\n
CREATE DATABASE wordpress CHARACTER SET utf8mb4;<\/pre>\n
MySQL Create Database<\/strong> keyword use for creating a specific database with a unique name in the SQL server.<\/p>\n
 <\/p>\n
Grant all permission to the particular database in MySql<\/p>\n
grant all on database_name.* to 'database_user'@'localhost' identified by 'password';<\/pre>\n
 <\/p>\n
Select database.<\/h3>\n
use [database_name];<\/pre>\n
MySQL use<\/strong> keyword used to select any existing (All Ready Created) database in SQL Server.<\/p>\n
Select database() determine and find the selected name of the database which we working currently .<\/h3>\n
select database();<\/pre>\n
It helps to find out in the SSH terminal which database is currently selected and which of database user push the SSH command on database<\/p>\n
After opening the database determine all tables, use command.<\/h3>\n
show tables;<\/pre>\n
Show tables line command use for the list of schema, name,\u00a0 owner, type, and row count for the table.<\/p>\n
Show database table structure.<\/h3>\n
describe [table_name];<\/pre>\n
MySQL describes keyword use for show table information in detail. Every column and row detail will show on your screen.<\/p>\n
List all indexes on a table:<\/h3>\n
show index from [table_name];<\/pre>\n
Create a new table with columns in the database.<\/h3>\n
CREATE TABLE [table_name] ([column_name] VARCHAR(120), [another-column] DATETIME);<\/pre>\n
Add a column in a table with the selected database.<\/h3>\n
ALTER TABLE [table_name] ADD COLUMN [column_name] VARCHAR(120);<\/pre>\n
Add a column into table with a unique, auto-incrementing ID.<\/h3>\n
ALTER TABLE [table_name] ADD COLUMN [column_name] int NOT NULL AUTO_INCREMENT PRIMARY KEY;<\/pre>\n
Insert a new record in the table by the selected database.<\/h3>\n
INSERT INTO [table_name] ([column_name], [column_name]) VALUES ('[value_defined]', '[value_define]');<\/pre>\n
Show and select all records.<\/h3>\n
SELECT * from [table_name];<\/pre>\n
Select and show some particular column in the database.<\/h3>\n
Select [column_name], [column_name] from [table_name];<\/pre>\n
Count the rows record enter in a database table.<\/h3>\n
Select COUNT([column_name]) from table;<\/pre>\n
Counting and selecting grouped records.<\/h3>\n
SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];<\/pre>\n
Selecting specific records.<\/h3>\n
SELECT * FROM [table_name] WHERE [column] = [value]; (Selectors: <, >, !=; combine multiple selectors with AND, OR);<\/pre>\n
Select records containing the specified values.<\/h3>\n
SELECT * FROM [table_name] WHERE [column] LIKE '%[value]%';<\/pre>\n
Select records starting with [value].<\/h3>\n
SELECT * FROM [table_name] WHERE [column_name] LIKE '[value]%';<\/pre>\n
Select records starting with value and ending with the specified value.<\/h3>\n
SELECT * FROM [table_name] WHERE [column] LIKE '[val_ue]';<\/pre>\n
Select a range.<\/h3>\n
SELECT * FROM [table_name] WHERE [column] BETWEEN [value1] and [value2];<\/pre>\n
Select with a custom order and only limit.<\/h3>\n
SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value]; (Order: DESC, ASC)<\/pre>\n
Updating records in the table.<\/h3>\n
UPDATE [table] SET [column] = '[updated-value]' WHERE [column] = [value];<\/pre>\n
Deleting records entry in the table.<\/h3>\n
DELETE FROM [table] WHERE [column] = [value];<\/pre>\n
Delete all records from a table.<\/h3>\n
DELETE FROM [table];<\/pre>\n
(This also resets the incrementing counter.)<\/p>\n
Delete all records in a table.<\/h3>\n
truncate table [table];<\/pre>\n
Removing table columns.<\/h3>\n
ALTER TABLE [table] DROP COLUMN [column];<\/pre>\n
Deleting tables in single Database.<\/h3>\n
DROP TABLE [table];<\/pre>\n
Deleting databases.<\/h3>\n
DROP DATABASE [database];<\/pre>\n
Custom column output names.<\/h3>\n
SELECT [column] AS [custom-column] FROM [table];<\/pre>\n
Export a database dump (more info here).<\/h3>\n
mysqldump -u [username] -p [database] > db_backup.sql;<\/pre>\n
Import a database dump (more info here).<\/h3>\n
mysql -u [username] -p -h localhost [database] < db_backup.sql;<\/pre>\n
Import the database into the selected database.<\/h3>\n
[database_name] < sql_file.sql;<\/pre>\n
Logout the SSH MySQL<\/h3>\n
exit;<\/pre>\n
Update the\u00a0 wp_options value where option value define in home and siteurl fields<\/p>\n
first, select and open your database in putty.<\/p>\n
\r\nUPDATE wp_options SET option_value = replace(option_value, 'http:\/\/olddomain.com', 'http:\/\/newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';<\/pre>\n","protected":false},"excerpt":{"rendered":"
How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH. List of all commands used […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[46,45],"tags":[],"class_list":["post-1368","post","type-post","status-publish","format-standard","hentry","category-mysql","category-ssh-commands"],"acf":[],"yoast_head":"\nSSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools\" \/>\n<meta property=\"og:description\" content=\"How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH. List of all commands used […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"MyFreeOnlineTools\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-19T16:09:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-02T05:04:57+00:00\" \/>\n<meta name=\"author\" content=\"myfreeonlinetools\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"myfreeonlinetools\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\"},\"author\":{\"name\":\"myfreeonlinetools\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\"},\"headline\":\"SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database\",\"datePublished\":\"2021-08-19T16:09:57+00:00\",\"dateModified\":\"2021-10-02T05:04:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\"},\"wordCount\":518,\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"articleSection\":[\"MySQL\",\"SSH Commands\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\",\"name\":\"SSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\"},\"datePublished\":\"2021-08-19T16:09:57+00:00\",\"dateModified\":\"2021-10-02T05:04:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myfreeonlinetools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"name\":\"MyFreeOnlineTools\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\",\"name\":\"MyFreeOnlineTools\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"contentUrl\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"width\":387,\"height\":79,\"caption\":\"MyFreeOnlineTools\"},\"image\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\",\"name\":\"myfreeonlinetools\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"caption\":\"myfreeonlinetools\"},\"description\":\"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.\",\"sameAs\":[\"https:\/\/myfreeonlinetools.com\/\",\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\",\"https:\/\/www.youtube.com\/learnschoolonline\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"SSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools","og_description":"How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH. List of all commands used […]","og_url":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/","og_site_name":"MyFreeOnlineTools","article_author":"https:\/\/www.facebook.com\/LearnSchoolOnline\/","article_published_time":"2021-08-19T16:09:57+00:00","article_modified_time":"2021-10-02T05:04:57+00:00","author":"myfreeonlinetools","twitter_card":"summary_large_image","twitter_misc":{"Written by":"myfreeonlinetools","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#article","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/"},"author":{"name":"myfreeonlinetools","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c"},"headline":"SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database","datePublished":"2021-08-19T16:09:57+00:00","dateModified":"2021-10-02T05:04:57+00:00","mainEntityOfPage":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/"},"wordCount":518,"publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"articleSection":["MySQL","SSH Commands"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/","url":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/","name":"SSH Linux Command for Putty Client - All MySQL Line commands for maintain MySQL database - MyFreeOnlineTools","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#website"},"datePublished":"2021-08-19T16:09:57+00:00","dateModified":"2021-10-02T05:04:57+00:00","breadcrumb":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/myfreeonlinetools.com\/blog\/ssh-linux-command-for-putty-client-all-mysql-line-commands-for-maintain-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myfreeonlinetools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database"}]},{"@type":"WebSite","@id":"https:\/\/myfreeonlinetools.com\/blog\/#website","url":"https:\/\/myfreeonlinetools.com\/blog\/","name":"MyFreeOnlineTools","description":"","publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization","name":"MyFreeOnlineTools","url":"https:\/\/myfreeonlinetools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","contentUrl":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","width":387,"height":79,"caption":"MyFreeOnlineTools"},"image":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c","name":"myfreeonlinetools","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","caption":"myfreeonlinetools"},"description":"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.","sameAs":["https:\/\/myfreeonlinetools.com\/","https:\/\/www.facebook.com\/LearnSchoolOnline\/","https:\/\/www.youtube.com\/learnschoolonline"]}]}},"_links":{"self":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/comments?post=1368"}],"version-history":[{"count":0,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1368\/revisions"}],"wp:attachment":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/media?parent=1368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/categories?post=1368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/tags?post=1368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}