How to Create a MySQL database on Linux via Command Line

Portal Home > Knowledgebase > Articles Database > How to Create a MySQL database on Linux via Command Line

Posted by kedenya, 11-04-2014, 04:40 AM
Hello first, my cpanel trial have expire cant login cpanel to create new user and database SQL i can login phpmyadmin in this case any idea to create sql database found liquidweb.com/kb/create-a-mysql-user-on-linux-via-command-line but create user only.. i want create database help me tq p/s : sry my bad English
Posted by NorthHosts, 11-04-2014, 05:38 AM
Why don't you just buy a cpanel license?
Posted by kedenya, 11-04-2014, 06:13 AM
no money so can or not? any idea
Posted by Kailash12, 11-04-2014, 08:52 AM
You will not be able to create user in certain account but you can create the database directly. Refer the following URL that will help you to create database as well as grant permissions to users. http://vps2.me/create-mysql-database-with-ssh-command/
Posted by David@CDNsun, 11-04-2014, 09:51 AM
You can't create new database in phpmyadmin? You should be able to run any (granted) SQL command from phpmyadmin.
Posted by LinuxNerd, 11-04-2014, 06:08 PM
mysql -u username -p create database databasename; use database; Pretty much all there is to creating a database vis SSH and nothing more.
Posted by datarealm, 11-04-2014, 07:08 PM
After you create the database, grant the permissions you need to the appropriate mysql user: http://dev.mysql.com/doc/refman/5.1/en/grant.html
Posted by CentOS 6, 11-04-2014, 07:54 PM
There is always Webmin...
Posted by kedenya, 11-07-2014, 11:52 AM
Thank you all get error after running " CREATE DATABASE database1; " and this still need help tq
Posted by NorthHosts, 11-07-2014, 12:17 PM
Just either pay for a license or install something like vestacp which is free? Why would you want to run websites from a server using unlicensed software? Makes zero sense
Posted by kedenya, 11-07-2014, 12:22 PM
Fix need reset the root password SQL first than use root to create new database... done tq for help all now all can, when use google search