How to add a printer using the command line in Linux

Open a new command line window and type in the following command as root sudo system-config-printer Now a window should Pop-Up where you are able to add a new Printer

April 7, 2018 · 1 min · 30 words · icarnaghan

How to add more than 1 column at a time to a PostgreSQL database table

ALTER TABLE users ADD COLUMN fax int, ADD COLUMN phone int;

April 7, 2018 · 1 min · 11 words · icarnaghan

How to add the Trash Can Icon to your Ubuntu Desktop

How to add the Trash Can Icon to your Ubuntu Desktop? Ubuntu has the ability for you to add the Trash Can to you’re Desktop. STEP 1 Press the Alt+F2 keys together to open the Run Application window. STEP 2 In the text field type in gconf-editor and hit the Run button**.** STEP 3 Locate/browse to the following location apps->nautilus->desktop STEP 4 Check the trash_icon_visible checkbox. And the Trash Can will appear on yourDesktop. You can change the Trash Icon name if you need to or like to by changing the value for trash_icon_name. ...

April 7, 2018 · 1 min · 102 words · icarnaghan

How to assign Select Privileges to a specific user in PostgreSQL

GRANT SELECT ON table TO user; Replace table with your database table and user with the user that should get Select privileges

April 7, 2018 · 1 min · 22 words · icarnaghan

How to center a Headline/Title in the middle of a page in Word

Open Microsoft Word Click on File and the on Page Setup… Click on the Layout tab Under the Page section set the Vertical Alignment to Center

April 7, 2018 · 1 min · 26 words · icarnaghan

How to change the owner of a Database in PostgreSQL

First you need to login with the Super User e.g. psql postgres After logged-in type the following command ALTER DATABASE database OWNER TO newuser; Replace database with your database and newuser with your username

April 7, 2018 · 1 min · 34 words · icarnaghan

How to change the root MySQL password with MySQL installed on Ubuntu/Linux

Open a new Terminal Window. Type in the commands below. mysqladmin -u root OLDPASSWORD NEWPASSWORD If you get the error below follow solution 2 mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' If you did not get the error above restart the mySql server by typing the following command: sudo service mysql restart Solution 2: If Solution 1 did not work, this should work. ...

April 7, 2018 · 1 min · 160 words · icarnaghan

How to change the TIMEOUT of the GRUB loader Menu when your PC boots on Ubuntu

NOTE: Tested on Ubuntu 9.04 Boot into Ubuntu Open a new Terminal Window Type in the following command: {codecitation style=“brush: bash;"}sudo gedit /boot/grub/menu.lst{/codecitation} Now gedit will open. Located the following lines: ## timeout sec # Set a timeout, in SEC seconds, before automatically booting the default entry # (normally the first entry defined). timeout 10 Change timeout 10 to the desired timeout seconds. eg. timeout 4 Save the file and exit. ...

April 7, 2018 · 1 min · 85 words · icarnaghan

How to change the Timezone in CentOS 6

The timezone that’s active on your system is stored in the file /etc/localtime First make a backup of the existing localtime file mv /etc/localtime /etc/locatime.backup Now we create a link so that the timezone auto updates when updates come through ln -s /usr/share/zoneinfo/Africa/Johannesburg /etc/localtime In the above change Africa/Johannesburg to the appropriate timezone you need to use To test this change run the following command and see if the timezone updated. ...

April 7, 2018 · 1 min · 72 words · icarnaghan

How to change the welcome message after SSH login

Login as root via SSH Add a message to /etc/motd using vim eg. vim /etc/motd Add your message to this file eg. ###Please think before you type### Logout Login via SSH and then after successful login the message will appear

April 7, 2018 · 1 min · 40 words · icarnaghan