{"id":43335,"date":"2022-11-14T12:30:53","date_gmt":"2022-11-14T18:30:53","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=43335"},"modified":"2022-12-28T04:50:05","modified_gmt":"2022-12-28T10:50:05","slug":"10-useful-mysqladmin-commands-for-database-administration","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/","title":{"rendered":"10 Useful mysqladmin Commands for Database Administration"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-43444\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg\" alt=\"10 useful mysqladmin commands for database administration\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this blog post, we will show you ten useful mysqladmin commands for database administration.<\/p>\n<p>Mysqladmin is a client for performing administrative operations. We can use this for checking the server&#8217;s configuration, creating and removing <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-list-all-databases-in-mysql\/\">databases<\/a>, users, tables, rows, and many more in MySQL. MySQL is a relational database management system used worldwide where the information is stored in tables. There are many database types offered by MySQL such as int, bigint, float,tinyint, smallint, mediumint and many more.<\/p>\n<p>In this tutorial, first, we will install MySQL on the latest <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting\/\">Ubuntu 22.04<\/a>, then show you the mysqladmin commands. Let&#8217;s get started!<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69cc2d58868b4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69cc2d58868b4\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#Prerequisites\" >Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#Update-the-System\" >Update the System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#MySQL-Installation\" >MySQL Installation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#1-Set-MySQL-Root-Password\" >1. Set MySQL Root Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#2-Create-a-Database\" >2. Create a Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#3-Drop-Database\" >3. Drop Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#4-Check-Active-Processes\" >4. Check Active Processes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#5-Check-the-Status-of-the-MySQL-Server\" >5. Check the Status of the MySQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#6-Check-MySQL-Status-Variables\" >6. Check MySQL Status Variables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#7-Reload-MySQL-Privileges\" >7. Reload MySQL Privileges<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#8-Connect-Remote-MySQL-Server\" >8. Connect Remote MySQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#9-Run-Multiple-mysqladmin-commands\" >9. Run Multiple mysqladmin commands<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#10-Shutdown-MySQL-Server\" >10. Shutdown MySQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Fresh install of Ubuntu 22.04<\/li>\n<li>User privileges: root or non-root user with sudo privileges<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Update-the-System\"><\/span>Update the System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A fresh installation of Ubuntu 22.04 needs a system update. To update the system packages execute the following commands.<\/p>\n<pre>sudo apt update -y &amp;&amp; sudo apt upgrade -y<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"MySQL-Installation\"><\/span>MySQL Installation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To install MySQL execute the following command:<\/p>\n<pre>sudo apt install mysql-server -y<\/pre>\n<p>Once installed start and enable the MySQL service:<\/p>\n<pre>systemctl start mysql.service &amp;&amp; systemctl enable mysql.service<\/pre>\n<p>To check the status of the service:<\/p>\n<pre>systemctl status mysql.service<\/pre>\n<p>If everything is ok, you should get the following output:<\/p>\n<pre>root@host:~# systemctl status mysql.service\r\n\u25cf mysql.service - MySQL Community Server\r\n     Loaded: loaded (\/lib\/systemd\/system\/mysql.service; enabled; vendor preset: enabled)\r\n     Active: active (running) since Thu 2022-10-13 02:50:00 CDT; 8min ago\r\n   Main PID: 239318 (mysqld)\r\n     Status: \"Server is operational\"\r\n      Tasks: 38 (limit: 4575)\r\n     Memory: 361.4M\r\n        CPU: 4.761s\r\n     CGroup: \/system.slice\/mysql.service\r\n             \u2514\u2500239318 \/usr\/sbin\/mysqld\r\n\r\nOct 13 02:49:58 host.test.vps systemd[1]: Starting MySQL Community Server...\r\nOct 13 02:50:00 host.test.vps systemd[1]: Started MySQL Community Server.<\/pre>\n<p>Now, when MySQL database service is installed, we can start with the <b>mysqladmin<\/b> commands. The syntax of <b>mysqladmin<\/b> command is the following:<\/p>\n<pre>mysqladmin [options] command [command-arg] [command [command-arg]] ...<\/pre>\n<p>To Log in to the MySQL command line with the following command:<\/p>\n<pre>mysql<\/pre>\n<p>On a fresh installation of MySQL, there is no password required, so you will receive the following output:<\/p>\n<pre>root@host:~# mysql\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 8\r\nServer version: 8.0.30-0ubuntu0.22.04.1 (Ubuntu)\r\n\r\nCopyright (c) 2000, 2022, Oracle and\/or its affiliates.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql&gt;\r\n<\/pre>\n<p>In the next sections, we will show you the most 10 used mysqladmin commands for database administration.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"1-Set-MySQL-Root-Password\"><\/span>1. Set MySQL Root Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As we said previously, a fresh installation of MySQL does not require a password. To set up MySQL root password with mysqladmin command, execute the following:<\/p>\n<pre>mysqladmin -u root password StrongPasswordHere<\/pre>\n<p>After executing this command, you should receive this warning:<\/p>\n<pre>root@host:~# mysqladmin -u root password StrongPasswordHere\r\nmysqladmin: [Warning] Using a password on the command line interface can be insecure.\r\nWarning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.<\/pre>\n<p>This means that setting a new MySQL password using mysqladmin should be considered vulnerable, and it can be viewed in the history of the server commands. So you need to be careful and be sure not to share your server&#8217;s root password.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2-Create-a-Database\"><\/span>2. Create a Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To create an empty database, execute the following command:<\/p>\n<pre>mysqladmin -u root -p create testdb<\/pre>\n<p>You will be asked for the MySQL root password, and once inserted the database will be created successfully.<\/p>\n<pre>root@host:~# mysqladmin -u root -p create testdb\r\nEnter password:\r\n\r\nmysql&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n| testdb             |\r\n+--------------------+\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Drop-Database\"><\/span>3. Drop Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To drop the database with mysqladmin command, execute the following:<\/p>\n<pre>mysqladmin -u root -p drop testdb<\/pre>\n<p>You will be asked for the root password<\/p>\n<pre>root@host:~# mysqladmin -u root -p drop testdb\r\nEnter password:\r\nDropping the database is potentially a very bad thing to do.\r\nAny data stored in the database will be destroyed.\r\n\r\nDo you really want to drop the 'testdb' database [y\/N] y\r\nDatabase \"testdb\" dropped\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"4-Check-Active-Processes\"><\/span>4. Check Active Processes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To check the active threads, execute the following command:<\/p>\n<pre>mysqladmin -u root -p processlist<\/pre>\n<p>You will get a table with output similar to this:<\/p>\n<pre>root@host:~# mysqladmin -u root -p processlist\r\nEnter password:\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\n| Id | User            | Host      | db | Command | Time  | State                  | Info             |\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\n| 5  | event_scheduler | localhost |    | Daemon  | 19834 | Waiting on empty queue |                  |\r\n| 14 | root            | localhost |    | Query   | 0     | init                   | show processlist |\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"5-Check-the-Status-of-the-MySQL-Server\"><\/span>5. Check the Status of the MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To check the status of the MySQL server, execute the following command:<\/p>\n<pre>mysqladmin -u root -p status<\/pre>\n<p>You should receive output similar to this:<\/p>\n<pre>root@host:~# mysqladmin -u root -p status\r\nEnter password:\r\nUptime: 19978  Threads: 2  Questions: 18  Slow queries: 0  Opens: 167  Flush tables: 3  Open tables: 86  Queries per second avg: 0.000\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"6-Check-MySQL-Status-Variables\"><\/span>6. Check MySQL Status Variables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To check the status of the MySQL status variables and their values, execute the following command:<\/p>\n<pre>mysqladmin -u root -p extended-status<\/pre>\n<p>You will get a huge table with a lot of information.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"7-Reload-MySQL-Privileges\"><\/span>7. Reload MySQL Privileges<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To reload the MySQL privileges, execute the following command:<\/p>\n<pre>mysqladmin -u root -p reload<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"8-Connect-Remote-MySQL-Server\"><\/span>8. Connect Remote MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To connect to a remote MySQL Host, execute the following command<\/p>\n<pre>mysqladmin -h \"IP-Address-Remote-Host\" -u root -p<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"9-Run-Multiple-mysqladmin-commands\"><\/span>9. Run Multiple mysqladmin commands<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To run multiple mysqladmin commands, just enter them one by one in the same line:<\/p>\n<pre>mysqladmin  -u root -p processlist status reload<\/pre>\n<p>If there is any output available for each command, you will get it respectively like the outputs below:<\/p>\n<pre>root@host:~# mysqladmin  -u root -p processlist status reload\r\nEnter password:\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\n| Id | User            | Host      | db | Command | Time  | State                  | Info             |\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\n| 5  | event_scheduler | localhost |    | Daemon  | 20915 | Waiting on empty queue |                  |\r\n| 18 | root            | localhost |    | Query   | 0     | init                   | show processlist |\r\n+----+-----------------+-----------+----+---------+-------+------------------------+------------------+\r\nUptime: 20916  Threads: 2  Questions: 25  Slow queries: 0  Opens: 170  Flush tables: 3  Open tables: 89  Queries per second avg: 0.001<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"10-Shutdown-MySQL-Server\"><\/span>10. Shutdown MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The last mysqladmin command will be shutting down safely the MySQL server:<\/p>\n<pre>mysqladmin -u root -p shutdown<\/pre>\n<p>If you check the status with the <b>systemcl status mysql<\/b> you should get this:<\/p>\n<pre>root@host:~# systemctl status mysql\r\n\u25cb mysql.service - MySQL Community Server\r\n     Loaded: loaded (\/lib\/systemd\/system\/mysql.service; enabled; vendor preset: enabled)\r\n     Active: inactive (dead) since Thu 2022-10-13 08:42:56 CDT; 12s ago\r\n    Process: 239318 ExecStart=\/usr\/sbin\/mysqld (code=exited, status=0\/SUCCESS)\r\n   Main PID: 239318 (code=exited, status=0\/SUCCESS)\r\n     Status: \"Server shutdown complete\"\r\n        CPU: 2min 15.480s\r\n<\/pre>\n<p>The MySQL service is stopped successfully with the mysqladmin command.<\/p>\n<p>That&#8217;s all. We just showed you the ten most used mysqladmin commands on Ubuntu 22.04 using the latest MySQL 8.0 version. If you find any difficulties while managing your MySQL server, you just need to sign up for one of our <a href=\"https:\/\/www.rosehosting.com\/linux-vps-hosting\/\">NVMe VPS hosting plans<\/a> and submit a support ticket. Our admins will help you with any aspect of the MySQL server. We are available 24\/7.<\/p>\n<p>If you liked this post about ten useful mysqladmin commands for database administration, please share it with your friends on social networks or simply leave a reply below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, we will show you ten useful mysqladmin commands for database administration. Mysqladmin is a client for &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"10 Useful mysqladmin Commands for Database Administration\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#more-43335\" aria-label=\"Read more about 10 Useful mysqladmin Commands for Database Administration\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":43444,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1236],"tags":[2036,41,39],"class_list":["post-43335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-guides","tag-administration","tag-database","tag-mysql","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>10 Useful mysqladmin Commands for Database Administration | RoseHosting<\/title>\n<meta name=\"description\" content=\"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let&#039;s get started!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"10 Useful mysqladmin Commands for Database Administration\" \/>\n<meta property=\"og:description\" content=\"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let&#039;s get started!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-14T18:30:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-28T10:50:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg?v=1666783717\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"10 Useful mysqladmin Commands for Database Administration\" \/>\n<meta name=\"twitter:description\" content=\"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let&#039;s get started!\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"10 Useful mysqladmin Commands for Database Administration\",\"datePublished\":\"2022-11-14T18:30:53+00:00\",\"dateModified\":\"2022-12-28T10:50:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/\"},\"wordCount\":651,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/10-useful-mysqladmin-commands-for-database-administration.jpg\",\"keywords\":[\"administration\",\"database\",\"mysql\"],\"articleSection\":[\"Databases\",\"Guides\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/\",\"name\":\"10 Useful mysqladmin Commands for Database Administration | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/10-useful-mysqladmin-commands-for-database-administration.jpg\",\"datePublished\":\"2022-11-14T18:30:53+00:00\",\"dateModified\":\"2022-12-28T10:50:05+00:00\",\"description\":\"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let's get started!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/10-useful-mysqladmin-commands-for-database-administration.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/10-useful-mysqladmin-commands-for-database-administration.jpg\",\"width\":742,\"height\":372,\"caption\":\"10 useful mysqladmin commands for database administration\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/10-useful-mysqladmin-commands-for-database-administration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"10 Useful mysqladmin Commands for Database Administration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"10 Useful mysqladmin Commands for Database Administration | RoseHosting","description":"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let's get started!","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:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/","og_locale":"en_US","og_type":"article","og_title":"10 Useful mysqladmin Commands for Database Administration","og_description":"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let's get started!","og_url":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2022-11-14T18:30:53+00:00","article_modified_time":"2022-12-28T10:50:05+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg?v=1666783717","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"10 Useful mysqladmin Commands for Database Administration","twitter_description":"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let's get started!","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"10 Useful mysqladmin Commands for Database Administration","datePublished":"2022-11-14T18:30:53+00:00","dateModified":"2022-12-28T10:50:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/"},"wordCount":651,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg","keywords":["administration","database","mysql"],"articleSection":["Databases","Guides"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/","url":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/","name":"10 Useful mysqladmin Commands for Database Administration | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg","datePublished":"2022-11-14T18:30:53+00:00","dateModified":"2022-12-28T10:50:05+00:00","description":"In this blog post, we will show you ten useful mysqladmin commands for database administration. Let's get started!","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/10-useful-mysqladmin-commands-for-database-administration.jpg","width":742,"height":372,"caption":"10 useful mysqladmin commands for database administration"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/10-useful-mysqladmin-commands-for-database-administration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"10 Useful mysqladmin Commands for Database Administration"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=43335"}],"version-history":[{"count":5,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43335\/revisions"}],"predecessor-version":[{"id":43446,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43335\/revisions\/43446"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/43444"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=43335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=43335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=43335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}