How to Create Database in MySQL in Linux Command Line
\nMySql DB Creation Procedure for RedHat Fedora Ubuntu Cent OS Debian Linux<\/p>\n
Login to your MySQL server through console remote shell (putty)<\/p>\n
Example : If you want to create a database name = mytestdb and grant permission for user = testuser with password = testpasswd This will create mytestdb and enable access for testuser form localhost How to Create Database in MySQL in Linux Command Line MySql DB Creation Procedure for RedHat Fedora Ubuntu Cent OS Debian Linux Mysql Database in Command Line Login to your… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[88],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/129"}],"collection":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/comments?post=129"}],"version-history":[{"count":4,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/129\/revisions"}],"predecessor-version":[{"id":749,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/129\/revisions\/749"}],"wp:attachment":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media?parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/categories?post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/tags?post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\ndatabase name = mytestdb
\nUser Name = testuser
\nPassword\u00a0 = testpasswd<\/b><\/p>\n #mysql -u root -p ( enter the mysql root password)\r\n mysql> create database mytestdb;\r\n mysql> grant all privileges on mytestdb.* to testuser@localhost identified by 'testpasswd';\r\n mysql> FLUSH PRIVILEGES;<\/b>\r\n mysql>show databases;\r\n mysql> exit <\/b><\/pre>\n
\nIf you want to connect mysql form remote serve<\/b>r, then replace localhost with your remote server ip<\/p>\n","protected":false},"excerpt":{"rendered":"