to create new user on mysql database we can use below script; DB_NAME = KartookShop DB_USER = Kartook DB_PASSWORD = password HOST=localhost we want to give SELECT,INSERT,UPDATE,DELETE,CREATE,DROP permission on Kartook. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON KartookShop.* TO ‘Kartook’@’localhost’ IDENTIFIED BY ‘password’; this will allow Kartook to connect to KartookShop database from localhost. If you want to give […]
Category Archives: Linux
How to Create a new database on MySQL? To create a new database you need to login as root or a account that has permission. we will create KartookShop database. -> mysql -u root -p mysql> create database KartookShop; Query OK, 1 row affected (0.06 sec)
Here what bc, a command line calculator, comes in handy. In this short tutorial, I will show how to do some basic calculation with bc. First launch bc by typing bc and hitting enter. You will see bc ready to take your commands. [root@kartook ~]# bc bc 1.06 Copyright 1991-1994, 1997, 1998, 2000 Free Software […]
How do I disable desktop icons for “Computer,” “Home,” and “Trash?” If you do not want your desktop cluttered with the default icons for “Computer,” “Home,” and “Trash,” you can disable any or all of them. To do this, launch Applications > System Tools > Configuration Editor (gconf-editor from the command line), and go to […]
How do I upgrade from gnome2-lite to the full GNOME 2.28 desktop? The Lite edition does not include all of the components of the standard GNOME 2.28 desktop. If you wish to install the full desktop, first remove the gnome2-lite package, then install the gnome2 port or package. For example: root@kartook# pkg_delete gnome2-lite Then one […]
How do I remove www from all my urls so that search engine can only rank domain.com/ urls under Linux Apache web server? Add following code to your .htaccess or httpd.conf (directory directive) file: RewriteEngine On RewriteCond %{HTTP_HOST} ^www.yourdomain.com$ [NC] RewriteRule ^(.*)$ http://domain.com/$1 [R=301,L] If you added directives to httpd.conf, restart Apache: # service httpd […]
This guide can be adapted to all linux ditro, its not one specific. Installing necessary tools kartook@Nilas:~$sudo apt-get install aespipe mkisofs loop-aes-utils Chose a password You need to chose a 20+ character password and DO NOT FORGET IT, you will NEVER get your data back if you forget the password. Note : Use KeePass Creating […]
See what your users are doing using SSH connected to your system — this will show you what happens on the first console. If someone is typing, you’ll be able to get an output of his keystrokes. Substitute cat /dev/vcs1 with cat /dev/vcs2 or cat /dev/vcs3 and so on for other consoles. cat /dev/vcs1
How do I install perl on FreeBSD operating system? Practical Extraction and Report Language or Perl can be installed using FreeBSD ports or binary package system. Perl is a language optimized for scanning arbitrary text files, extracting information from those text files, and printing reports based on that information. It’s also a good language for […]