If you’re getting the #2002 Cannot log in to the MySQL server error while logging in to phpmyadmin, try editing phpmyadmin/config.inc.php and change: $cfg[‘Servers’][$i][‘host’] = ‘localhost’; to: $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; Solution from Ryan’s blog Edit (20-Mar-2015): Note that if you’re on a fresh install, config.inc.php may not exist. You need to rename / copy config.sample.inc.php … Read more
It looks like there is a phpMyAdmin setting that you need to edit in config.inc.php. boolean $cfg[‘AllowUserDropDatabase’] (line 503) show a ‘Drop database’ link to normal users
These aren’t necessarily AJAX but thought I’d list them as they may be useful to other people: Adminer phpminiadmin
Edit Eureka! Literally my first SQL function. No warranty offered. Back up your data before using. 🙂 First, define the following function: DROP FUNCTION IF EXISTS lowerword; SET GLOBAL log_bin_trust_function_creators=TRUE; DELIMITER | CREATE FUNCTION lowerword( str VARCHAR(128), word VARCHAR(5) ) RETURNS VARCHAR(128) DETERMINISTIC BEGIN DECLARE i INT DEFAULT 1; DECLARE loc INT; SET loc = … Read more
You have no other conditions like update this in all rows then you can try UPDATE jos_content SET title = CONCAT(‘Mr. ‘, title) if you want to update conditionally that means particular row needs to update the you can use UPDATE jos_content SET title = CONCAT(‘Mr. ‘, title) where fiedl_name=”condition” eg: UPDATE jos_content SET title … Read more
If you are using WHM/Cpanel then in order to change that “Max: 50MiB” limit in the import section of phpmyadmin, you will have to change two values in WHM (Web Host Manager). Step 1) Go to Tweak settings, find the “cPanel PHP Max upload size” change it according to your needs. Save changes. Step 2) … Read more
If i go to localhost:8888/MAMP it gives me the MAMP screen, from which i can go to phpmadmin.
If you see below error message, when try into phpyAdmin: New XAMPP security concept: Access to the requested directory is only available from the local network. This setting can be configured in the file “httpd-xampp.conf”. You can do next (for XAMPP, deployed on the UNIX-system): You can try change configuration for <Directory “/opt/lampp/phpmyadmin”> # vi … Read more