How to allow remote connections on MySQL server

Open your ssh shell and launch the following command:

root@localhost# mysql –p

 Insert the mysql root password, then launch the following commands:

select host, user, password from mysql.user;

You will have the following message:
Setting privileges for remote connection:
Then write the following:

Grant all on *.* to ‘root’@’%’ identified by ‘yourmysqlpassword’;
Flush privileges;

That's it! This command gives access to all tables, to user root, connecting from any ip address.
 If you need to grant this privileges to other existing users, simply change the users or the mask after @.

Your GNOME desktop suddenly reverted to TWM in CentOS 5

http://2.bp.blogspot.com/_qvZ1h1bgBRo/SY0kFQER7EI/AAAAAAAAAbo/xguOFX2CiEE/s400/twm.pngHas your GNOME desktop suddenly reverted to TWM upon a regular restart? If so, you aren’t alone.

Here is what you need to do to restore your GNOME desktop:

  1. 1. Check if you can just get away with switching back to GNOME:

    yum install switchdesk
    switchdesk gnome
    

    If that tells you that gnome is not installed then proceed to step 2, otherwise you should have gotten your GNOME back.
     

  2. We are going to reinstall GNOME. Run this command:

    yum groupinstall "GNOME Desktop Environment"
    

    Now run the command to switch desktops:

     
     switchdesk gnome
    
    

    and you should be good getting your GNOME back upon next restart of your xwindow session (Ctrl+Alt+Bcksp).

     

     Original Source from Anton
    http://blog.bordercrossingmedia.com/2009/01/your-gnome-desktop-suddenly-reverted-to-twm-in-centos-5/