Access phpMyAdmin from domain directly

By | 2016-03-04T16:52:20+00:00 March 4th, 2016|

In this documentation, we can check how to access phpMyAdmin from your domain directly.   1) Download the latest version of phpMyAdmin. You can use the following URL to download the stable version of phpMyAdmin. https://www.phpmyadmin.net/downloads/   root@localhost [/usr/local/src]# wget https://files.phpmyadmin.net/phpMyAdmin/4.4.15.4/phpMyAdmin-4.4.15.4-all-languages.tar.bz2 root@localhost [/usr/local/src]# tar jxf phpMyAdmin-4.4.15.4-all-languages.tar.bz2 root@localhost [/usr/local/src]# ls ./  ../  phpMyAdmin-4.4.15.4-all-languages/  phpMyAdmin-4.4.15.4-all-languages.tar.bz2 root@localhost [/usr/local/src]# [...]

Read More
 0

How to Run MySQL Query in phpMyAdmin

By | 2019-08-26T13:46:49+00:00 February 2nd, 2016|

In this documentation, we can check how to run MySQL query in phpMyAdmin.   1) Login to cPanel account. 2) Click the icon ‘phpMyAdmin’ from the section ‘DATABASES’.   3) Select the database name.   4) Select the table name where you want to work.   5) Click on the tab ‘SQL’.   6) Enter [...]

Read More
 0

PHPMyAdmin shows every database when logging in as a user

By | 2019-08-26T06:27:09+00:00 October 23rd, 2015|

If phpmyadmin shows all the databases on a server when it should only show the users databases do the following: First be sure a MySQL root password is set. Add safe-show-database in the mysqld section of /etc/my.cnf [mysqld] safe-show-database Then restart mysql. If this does not work do the following: mysql -u root -p mysql [...]

Read More
 0

cPanel’s phpmyadmin fails to export database

By | 2019-08-22T13:39:51+00:00 October 23rd, 2015|

If cpanel's phpmyadmin shows an error like: can't find the file at export.php During an export/database dump raise the php memory limit to 512MB ram for cpanel's internal php.ini file. The file is located at /usr/local/cpanel/3rdparty/etc/php.ini Change the memory limit memory_limit = 512M When done, run /usr/local/cpanel/bin/install_php_inis Regards, John Quaglieri InterServer Inc - Interserver http://www.interserver.net [...]

Read More
 0