{"id":129,"date":"2017-10-16T03:38:00","date_gmt":"2017-10-16T03:38:00","guid":{"rendered":"https:\/\/linuxadmin.melberi.com\/uncategorized\/how-to-create-database-in-mysq"},"modified":"2017-10-16T09:19:18","modified_gmt":"2017-10-16T09:19:18","slug":"create-database-in-mysql","status":"publish","type":"post","link":"https:\/\/www.melberi.com\/linuxadmin\/mysql\/create-database-in-mysql","title":{"rendered":"Create Mysql Database in Linux Command Line"},"content":{"rendered":"

How to Create Database in MySQL in Linux Command Line
\nMySql DB Creation Procedure for RedHat Fedora Ubuntu Cent OS Debian Linux<\/p>\n

Mysql Database in Command Line<\/span><\/h2>\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
\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
This will create mytestdb and enable access for testuser form localhost
\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":"
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":[],"class_list":["post-129","post","type-post","status-publish","format-standard","hentry","category-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t