If even after repeated upload you still get timeout error, pleasechange your settings in \phpmyadmin\libraries\config.default.php from $cfg[‘ExecTimeLimit’] = 300; to $cfg[‘ExecTimeLimit’] = 0; and restart. Now there is no execution time limit (trust we are talking about local server). Source : Change Script time out in phpmyadmin
At the first site is a dropdown field to select the language of phpmyadmin. In the config.inc.php you can set: $cfg[‘Lang’] = ”; More details you can find in the documentation: http://www.phpmyadmin.net/documentation/
pip install pymysql Then, edit the __init__.py file in your project origin dir(the same as settings.py) add: import pymysql pymysql.install_as_MySQLdb()
Changing php.ini will change the session duration for all the websites running on the server. To change it just for PhpMyAdmin, open config.inc.php and add: $sessionDuration = 60*60*24*7; // 60*60*24*7 = one week ini_set(‘session.gc_maxlifetime’, $sessionDuration); $cfg[‘LoginCookieValidity’] = $sessionDuration;
Open phpMyAdmin and select the SQL tab. Then type this command: SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘your_root_password’); Also change to this line in config.inc.php: $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’; To make phpMyAdmin prompts for your MySQL username and password.
change localhost to 127.0.0.1 in /etc/phpmyadmin/config.inc.php $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; The reason for this is that pma tries to connect to the mysql.socket if you use localhost. If you use 127.0.0.1 PMA makes a TCP connection which should work.
Try to import it from mysql console as per the taste of your OS. mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql path} or if it’s on a remote server use the -h flag to specify the host. mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path}
On Ubuntu you should be able to install the necessary PDO parts from apt using sudo apt-get install php5-mysql There is no limitation between using PDO and mysql_ simultaneously. You will however need to create two connections to your DB, one with mysql_ and one using PDO.
You cannot do it with just a single MySQL command, however you can use MySQL to construct the statement for you: In the MySQL shell or through PHPMyAdmin, use the following query SELECT CONCAT( ‘DROP TABLE ‘, GROUP_CONCAT(table_name) , ‘;’ ) AS statement FROM information_schema.tables WHERE table_name LIKE ‘myprefix_%’; This will generate a DROP statement … Read more
I stumble upon this issue and I solved it just by logging out of phpMyAdmin and in again. EXPLANATION Take a look at the error message query: SELECT command denied to user ”@’localhost’ for table ‘pma_table_uiprefs’ This happens due to MySQL denying access to user “” (blank) at server localhost. The default setting is to … Read more