If you are tired of using ‘sudo‘ to execute command line activities, you can switch to root user (super user). First of all, we assign a root password: After assign password for root user, you can switch to root user using ‘su’ command and type in the password:
This guide can be used to insert data into database using select query. Using above syntax, all data in second_table will be copied into first_table. You can also add where keyword.
To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys Export the key Key BE1229CF is the last 8 digit taken from key list. The following message will appear: Now we can update our apt source file for the repository (e.g., /etc/apt/sources.list.d/microsoft.list), adding a signed-by tag: Update apt to make…
I received email from cronjob saying that there was PHP module already loaded: PHP Warning: Module ‘mysql’ already loaded in Unknown on line 0 This warning happens when there is PHP extension loaded more than once. To fix this problem, check /etc/php5/apache2/php.ini file and the corresponding module configuration file in /etc/php5/conf.d/. For mysql module, I…
Requirement: bc package How to: Install bc package Create shell script, name it ‘solve.sh’ And type in these lines: Test the script Create alias ‘solve’ Test again using alias
This problem happens when you are using Remote Desktop Connection Manager (RDCMan) with not updated Terminal Service Client. To fix this problem you have to download and install the latest Terminal Service Client 6.1 from below website. For Windows XP: http://www.microsoft.com/download/en/details.aspx?id=7208 For Windows Server 2003: http://www.microsoft.com/download/en/details.aspx?id=21296
1. Search for virtualbox group id, make sure you already put your username under vboxusers group: $ cat /etc/group .. vboxusers:x:122:kumkum .. 2. Add this line to /etc/fstab: none /proc/bus/usb usbfs devgid=122,devmode=664 0 0 3. Reboot system. Finish. Try plug your usb device to VirtualBox. Note: – devgid=122 is vboxusers group id which is taken…
The following tutorial can be used as dictionary for beginner on SQL syntax. SQL syntaxes are used to manipulate data which are select, insert, update, and delete on database. 1. Select Select command is used to get rows of data from table. Syntax: Example: 2. Insert Insert command is used to insert row to table….
I migrated my WordPress website to new domain, so I need to update all image URLs in wp_posts, wp_postmeta, and wp_options table which are still pointing to old domain. These are the SQL syntaxs to update the tables:
This is my little note on web hosting setup. – Install Ubuntu Server 10.10 – Setup static private IP address – Install ehcp hosting control panel: ehcp.net – Configure ehcp: add domain, add ftp user, modify ehcp dns template, modify external IP – Upload website source code – Import website database – Install smbfs: apt-get…