If you ever run into a problem where you have phpMyadmin open and cannot find where to create a database, because it is simply not there, ssh into your server and from the command line run;<\/p>\n
This will now allow phpMyadmin to show the “Create database” option located directly under the “MySQL connection collation:” option. \/* \/* \/* \/* \/* ?> As a workaround, use the cpanel function “Mysql Databases” >> “Create New Database” to create a database for a user account as this allows for the creation of a database outside of phpmyadmin.<\/p>\n","protected":false},"excerpt":{"rendered":" If you ever run into a problem where you have phpMyadmin open and cannot find where to create a database, because it is simply not there, ssh into your server and from the command line run; vim \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/config.inc.php look for the following lines in the file; (may be towards the bottom) \/\/ cpanel: cases 36079,… <\/p>\n
\nvim \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/config.inc.php
\n<\/code>
\nlook for the following lines in the file; (may be towards the bottom)
\n
\n\/\/ cpanel: cases 36079, 36080, 36144
\n$cfg['ShowChgPassword'] = false;
\n$cfg['ShowCreateDb'] = false;
\n$cfg['AllowUserDropDatabase'] = false;
\n<\/code>
\nand change it to
\n
\n\/\/ cpanel: cases 36079, 36080, 36144
\n$cfg['ShowChgPassword'] = false;
\n$cfg['ShowCreateDb'] = true;
\n$cfg['AllowUserDropDatabase'] = false;
\n<\/code><\/p>\n
\nHere is the default file if you need a reference.<\/p>\n
\n< ?php\n\/* vim: set expandtab sw=4 ts=4 sts=4: *\/\n\/**\n * phpMyAdmin sample configuration, you can use it as base for\n * manual configuration. For easier setup you can use scripts\/setup.php\n *\n * All directives are explained in Documentation.html and on phpMyAdmin\n * wiki
\n *
\n * @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $
\n *\/<\/p>\n
\n * This is needed for cookie based authentication to encrypt password in
\n * cookie
\n *\/
\n$cfg['blowfish_secret'] = ''; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/p>\n
\n * Servers configuration
\n *\/
\n$i = 0;<\/p>\n
\n * First server
\n *\/
\n$i++;
\n\/* Authentication type *\/
\n$cfg['Servers'][$i]['auth_type'] = 'http';
\n\/* Server parameters *\/
\n$cfg['Servers'][$i]['host'] = 'localhost';
\n$cfg['Servers'][$i]['connect_type'] = 'tcp';
\n$cfg['Servers'][$i]['compress'] = false;
\n\/* Select mysqli if your server has it *\/
\n$cfg['Servers'][$i]['extension'] = 'mysql';
\n\/* User for advanced features *\/
\n\/\/ $cfg['Servers'][$i]['controluser'] = 'pma';
\n\/\/ $cfg['Servers'][$i]['controlpass'] = 'pmapass';
\n\/* Advanced phpMyAdmin features *\/
\n\/\/ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
\n\/\/ $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
\n\/\/ $cfg['Servers'][$i]['relation'] = 'pma_relation';
\n\/\/ $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
\n\/\/ $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
\n\/\/ $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
\n\/\/ $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
\n\/\/ $cfg['Servers'][$i]['history'] = 'pma_history';
\n\/\/ $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';<\/p>\n
\n * End of servers configuration
\n *\/<\/p>\n
\n * Directories for saving\/loading files from server
\n *\/
\n$cfg['UploadDir'] = '';
\n$cfg['SaveDir'] = '';<\/p>\n
\n<\/code><\/p>\n