Tag Archives: phpMyAdmin

phpmyadmin: Drag And Drop File Upload

I use phpMyAdmin to manage mySql databases quite often and I find myself uploading / importing SQL files. I’ve gotten a little spoiled with WordPress’ HTML5 drag and drop ajax style uploader. Every time I go to use phpMyAdmin I start wishing that it had a HTML5 style drag-and-drop file uploader, something like this: I think it would be fairly easy to write a plugin and implement this idea but I have not done it yet. Leave a comment if the lack of a drag and drop HTML5 file uploader for phpMyadmin bugs you too.

Posted in Server Administration, Tech Opinion, Web Development | Tagged , , , , , | Leave a comment

phpMyAdmin plugins / extensions

I recently was trying to add some functionality to phpMyAdmin – like have some of the fields set to UTF or INT by default. This could be accomplished with a little javascript, but I didn’t just want to go hacking away at the core. Logically there should be a way to add a plugin, but i don’t think there is any documentation on it. I did find this, which has no replies: hi everybody, i’ve read here and there that phpMyAdmin can be extended developing some plugin. e.g. i’ve found this webpage: http://wiki.phpmyadmin.net/pma/Development with the import and export plugin documentation. unfortunately, that documentation was not so clear about how writing a plugin. could you, please, point me to some reference? a web site, a book… whatever you found useful for plugin development… thanks in advance francesco So how about a link to writing a plugin or extension for phpMyAdmin? Does anyone have any good resources?

Posted in Web Development | Tagged , , , | 2 Comments

How to set phpMyAdmin to use utf8

In your mf.cnf file: [mysqld] default-character-set = utf8 collation-server = utf8_unicode_ci init-connect=’SET NAMES utf8′ character-set-server = utf8 #try uncommenting these if you have problems #skip-character-set-client-handshake #character_set_client=utf8 #character_set_server=utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 And I have this in my confg.inc.php file for phpMyAdmin: $cfg[‘DefaultLang’] = ‘en-utf-8’; $cfg[‘DefaultCharset’] = ‘utf_8’; $cfg[‘DefaultConnectionCollation’] = ‘utf8_general_ci’; $cfg[‘Lang’] = ‘en-utf-8′; To verify, run this command: show variables like “%character%”;show variables like “%collation%”; collation_connection latin1_swedish_ci collation_database utf8_unicode_ci collation_server utf8_unicode_ci It does not really matter what the collation_connection shows up as. This has no bearing on how the mysql commands are run. If it is not utf8 that is fine. Tip: Just make sure that your DATABASE’s coalitions are also set to utf8 (utf8_general_ci), in phpMyAdmin – then tables you create inside the database will have that coallation too.

Posted in Web Development | Tagged , | Leave a comment

Enabling Linked Tables in phpMyAdmin

This is what I was running when I got this to work: WAMP Server 2.0 Apache 2.0.63 PHP 5.2.8 MySQL 5.1.36 Step 1: Edit and run create_tables.sql This sql file is included with phpMyAdmin, in a wamp installation it can be found at: C:\wamp\apps\phpmyadmin3.2.0.1\scripts\create_tables.sql On many Linux systems that file can be located at /etc/phpmyadmin/config.inc.php There are two sections at the top which are usually commented out – one to create a phpmyadmin database, and one to create a phpmyadmin user. I usually just create the database myself and I prefer to use the following command in the next step to create the user. So, after creating the database, I usually just run the file as it originally came. Step 2: Create a control user (controluser): You’re on your own if you used the script above to create your control user, and you probably know what you’re doing. If you don’t, however, I recommend these mysql commands: CREATE USER ‘phpmyadmin’@’localhost’ IDENTIFIED BY ‘pmapass’; GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO ‘phpmyadmin’@’localhost’; Step 3: Edit config.inc.php: Add these lines to your config.inc.php file and then you should be good to go! $cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’; $cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma_bookmark’; $cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’; $cfg[‘Servers’][$i][‘table_info’] = ‘pma_table_info’; $cfg[‘Servers’][$i][‘table_coords’] = ‘pma_table_coords’; $cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma_pdf_pages’; $cfg[‘Servers’][$i][‘column_info’] = ‘pma_column_info’; $cfg[‘Servers’][$i][‘history’] = ‘pma_history’; $cfg[‘Servers’][$i][‘designer_coords’] = ‘pma_designer_coords’; $cfg[‘Servers’][$i][‘tracking’] = ‘pma_tracking’; $cfg[‘Servers’][$i][‘controluser’] = ‘phpmyadmin’; $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’; Troubleshooting: If you’re getting the message “The additional features for working with linked tables have been deactivated. To find out why click here.” or … Continue reading

Posted in Tech Tips, Web Development | Tagged , | 19 Comments