{"id":2784,"date":"2022-12-03T21:21:08","date_gmt":"2022-12-04T05:21:08","guid":{"rendered":"https:\/\/doubleecpu.com\/?page_id=2784"},"modified":"2022-12-03T21:21:08","modified_gmt":"2022-12-04T05:21:08","slug":"mariadb-administration","status":"publish","type":"page","link":"https:\/\/doubleecpu.com\/index.php\/mariadb-administration\/","title":{"rendered":"MariaDB administration"},"content":{"rendered":"\n<p>Login to an existing installation<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u USERNAME -p <\/pre>\n\n\n\n<p>This will log in to the current local installation, to login to a remote host. MariaDB or MySQL must be installed to execute the command <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u USERNAME -p PASSWORD -h HOSTNAME<\/pre>\n\n\n\n<p>Once Logged in a few useful commands to run:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>checking the version <br>SELECT VERSION()<\/li><li>Show a list of Databases<br>SHOW DATABSES<\/li><li>To see a list of users<br>USE msql; SELECT Host, User FROM user;<\/li><li>Add a User<br><\/li><li>Remove a User<br><\/li><li>Restrict a User<br><\/li><li>Create Table<br>CREATE DATABASE todo; <br>CREATE TABLE todo.tasks <br>( id INT(11) unsigned NOT NULL AUTO_INCREMENT<br>, description VARCHAR(500) NOT NULL<br>, completed BOOLEAN NOT NULL DEFAULT 0<br>, PRIMARY KEY (id)<br>);<\/li><li>Close, Exit, Quit<br>quit<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Login to an existing installation mysql -u USERNAME -p This will log in to the current local installation, to login to a remote host. MariaDB or MySQL must be installed to execute the command mysql -u USERNAME -p PASSWORD -h HOSTNAME Once Logged in a few useful commands to run: checking the version SELECT VERSION() &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/doubleecpu.com\/index.php\/mariadb-administration\/\" class=\"more-link\">Read more<span class=\"screen-reader-text\"> &#8220;MariaDB administration&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2784","page","type-page","status-publish","hentry"],"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/comments?post=2784"}],"version-history":[{"count":1,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2784\/revisions"}],"predecessor-version":[{"id":2785,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2784\/revisions\/2785"}],"wp:attachment":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/media?parent=2784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}