Posts Tagged ‘MYSQL’

MYSQL – Change default root password + WAMP server

Posted: March 14, 2011 in MySQL, WAMP Server
Tags: ,
0

1.Open PHPMyAdmin and goto sql editor and check root user password by using
SELECT user, host,PASSWORD FROM mysql.user;

2. Run the following sql command to change the password
 SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpwd’);

3. Changing the root password will create issue with PHPMyAdmin as it is by default configured to run with root and blank password. Reset it to new password in \wamp\apps\phpmyadmin3.3.9\config.inc.php file

Refer http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html for more details about all OS environments.

PHP & MYSQL Development Platform

Posted: March 14, 2011 in MySQL, PHP, WAMP Server
Tags: , ,
0

Nearly 33% of world web sites are built on PHP including top tech company sites like Facebook, Yahoo, Flickr, Wikipedia and CMS sites like Wordpress, Joomla and Drupal. There are dozens of Frameworks available in market which will make the PHP development easy with out of box support for many of the today’s Web needs like Caching, Security, CDN … etc.

Install WAMP Server which will install Apache, PHP & MYSQL for you. It will also install PHPMyAdmin which you can use to work on MYSQL.

To work on PHP, you need a editor and you can use NetBeans for it. NetBeans editor is built using Java, so you need to install jdk to install NetBeans. NetBeans has built-in support for 2 PHP frameworks – Symfony, Zend PHP Web Frameworks. We need to do small configuration changes at NetBean editor level to use these frameworks. 

  1. http://www.wampserver.com/en/download.php – WAMP Server download
  2. http://netbeans.org/downloads/start.html?platform=windows&lang=en&option=php – NetBeans IDE for PHP
  3. https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProductDetail-Start?ProductRef=jdk-6u24-oth-JPR@CDS-CDS_Developer – Download JDK
  4. http://www.phpframeworks.com/
  5. http://en.wikipedia.org/wiki/Comparison_of_web_application_frameworks – Web application frameworks based on all technologies
  6. http://w3schools.com/php/php_intro.asp
  7. http://www.php.net/, http://www.php.net/manual/en/install.php
  8. http://www.mysql.com/