Tuesday, June 2, 2015

Windows 10 : Last OS upgrade of Windows : D-day 29 July 2015

So Microsoft has announced the date of  release of its last version or upgrade of Windows Operating system as July 29, 2015.

As more and more computing environment is becoming "service oriented " and users don't bother any more about the shrink wrapped products, it is obvious that Microsoft too has to switch its product positioning strategy in the coming times to remain relevant in operating system space.

The graphics and imaging software giant Adobe already transformed their products into services and offering via Adobe CC cloud. Adobe was once a leading software product vendor supplying its products in CD and DVD. Now you have to hook to cloud to use Adobe products... err... means Services.

Google is already offering its software as a services on web since long. It silently and regularly updates the features of it software like Chrome browser etc.

So it is obvious that the product based deployments of operating system will have to change its form in which they have been offered so far.

Not to be surprised that Windows 10,which is code named as " Threshold" and being offered as service is a new but inevitable chapter in the history of Microsoft. This new WAAS ( windows as a services) will have new Apps, new components, new technical capabilities for mobile platforms etc. A lot has yet to emerge.  The 10 will be the last version , after that only components updates will be offered by Microsoft.

No doubt with Windows 10, Microsoft is following the on going trend, set by mobile devices market an cloud computing.

Wednesday, April 25, 2012

How to : Connect MYSQL and phpMyAdmin

Due to security measures you cannot connect phpMyAdmin to MYSQL "out of the box". You require to set MYSQL root password first!

After installing XAMPP,if you try to connect to MYSQL using phpMyAdmin from Tools menu, you may be greeted with this message  Access denied for user: 'root'@'localhost' (Using password: NO)
The following steps will help to resolve this problem.
1. First Set the MYSQL root password from command line
2. Then edit "config.inc.php" file
3. Take some additional steps

Step 1.Set the MYSQL root password from command line
Suppose XAMPP is installed in c:\XAMPP
Switch to folder c:\XAMPP\MYSQL\bin
Run the following command
$ MYSQL -u root -p
you will be in MYSQL prompt. It clearly indicates that the  password was set initially as blank. Now the password need to be set first. Lets set the password as "linux".
2) First switch to MYSQL database. issue the following command
3) In order to change password for user "root", enter the following update command:

MYSQL> update user set password=PASSWORD("linux") where User='root';
4) Then run following commands to reload the privileges
MYSQL> flush privileges;
MYSQL> quit

Up to this stage we have set the MYSQL root password to "linux" from blank password. Now we have to tell about this change to config.inc.php file.
Step 2. Edit "config.inc.php" file
Switch to folder C:\xampp\phpMyAdmin
open config.inc.php file in text editor,go to block which has comment /* Authentication type and info */ .There you can set the root password as follows
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'linux';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
 Restart the XAMPP. Hope you will be able to connect to phpMyAdmin (tools-> phpMyAdmin)

3. Additional Steps: 
Check seurity of database

3.1. Click on Security tab to confirm that MYSQL root is protected. (http://localhost/security/). you should now able to see following.
The MYSQL admin user root has no longer no password                :    Secure
Done! Not only you get rid off from error but also secure MYSQL too.

Allow MYSQL to import larger sized file
3.2. By default MYSQL permit you to import file size upto 8MB .(MYSQL maximum import ax 8,192KiB). Must get rid off at this initial stage itself
Open php.ini file from c:\xampp\php folder and search for "post_max_size ". Change the value to 32.

Happy MYSQLing with phpMyAdmin