Thursday, August 21, 2014

Installing phpmyadmin for Developers

Before installing phpMyAdmin, you should have already installed a webserver. Apache or IIS are solid options.
Step 1:
     Install php with MySQL support
If you haven't done this already, you can download phpMyAdmin here.
Step 2:
     If your webserver is Apache, first unpack file like so: phpMyAdmin-x.y.z.zip under C:\apache\htdocs\ Rename the directory.
Again, if you were using Apache, you might do this: C:\apache\htdocs\phpMyAdmin-x.y.z to C:\apache\htdocs\phpMyAdmin
Step 3:
     Rename the config
Apache example: C:\apache\htdocs\phpMyAdmin\config.sample.inc.php to 'config.inc.php'
For a single-user (root or trusted) environment, update config.inc.php as:
$cfg['Server'][$i]['auth_type'] ='config';
$cfg['Server'][$i]['user'] = 'root';
$cfg['Server'][$i]['password'] = 'root-password';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Step 4 :
     Access myphpadmin
If access is performed from localhost, use -> http://localhost/phpMyAdmin/
If access is not performed from localhost, use -> http://[URL of the website]/phpMyAdmin/

Auto Complete issue in Chrome’s Devel tool console

The Chrome Dev tools provide a lot of functionality to developer when making changes to scripts. Best features of editing CSS is the auto-complete that allows you to quickly add style elements. Begin typing and Chrome will provide a list of CSS properties, arrow keys used to select an item, hit tab and you'll then be able to set the value. When setting a value hit ctrl+space and you'll get a list of values appropriate for the property.