1). fist login by using mysql -u root -p let us see the all exisint databse We have till- show databases; and provide password for mysql 3). if you want to see the tables in a DB use mydatabase_name; 4). next we may in the need to see the...
Install MySql2 on an Ubuntu machine…
MySQL is a powerful database management system used for organizing and retrieving data To install MySQL, open terminal and type in these commands: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql During the installation, MySQL will ask you to set a root password. If you miss the chance to set the...
How To Install Node.Js Using NVM
How To Install Using NVM An alternative to installing Node.js through apt is to use a specially designed tool called nvm, which stands for “Node.js version manager”. Using nvm, you can install multiple, self-contained versions of Node.js which will allow you to control your environment easier. It will give...
Devise Gem in rails and their use.
Devise 3.0 works with Rails 3.2 onwards. You can add it to your Gemfile with: gem 'devise' Run the bundle command from terminal to install it. bundle After you install Devise and add it to your Gemfile, you need to run the generator: rails generate devise:install The generator will...
Install a Secure phpMyAdmin (MySql Database) GUI on Ubuntu
phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities. Setup The steps in this tutorial require the user to have root privileges on your virtual private server. You can see how to set that up...
How to take Postgres DB backup from server and insert it on local Project
Step-1 login to the server by using ssh kya and ip Ex- ssh ‘user@101.111.00.01′ then provide password step-2 login to the post by using sudo su – postgres Provide password for postgres pg_dump slips99 > xyz.sql (make sure we are oing to have proper dump from server – production/development...
Want Mysql GUI ,Workbench is one option, see How to Install MySql Workbench on Ubuntu
Workbench is use to view the server Databae on our Local PC There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and Ubuntu To install Workbench go to terminal and type(ctrl + alt + T) 1. sudo add-apt-repository ppa:olivier-berten/misc ITs better...
How to validate and disable (start & end) dates less than start date (datepicker)
In some case we want start date should be less than end date, and to disable renaming date HTML Script $(document).ready(function(){ $(“#txtFromDate”).datepicker({ numberOfMonths: 1, onSelect: function(selected) { $(“#txtToDate”).datepicker(“option”,”minDate”, selected) } }); $(“#txtToDate”).datepicker({ numberOfMonths: 1, onSelect: function(selected) { $(“#txtFromDate”).datepicker(“option”,”maxDate”, selected) } }); });
Basic command require to work on file on serve
Often we need to know the description of our folder and file on terminal that can be do by using ls -l this will display something like – ls -l filename_backup.tar -rw-rw-r-- 1 User_name User_name 7792640 Feb 21 01:30 filename_backup.tar where 1). -rw-rw-r– ==> is the permission for this...
Aadhar Card App
Know complete information about your Aadhaar Card. You can also book an appointment for your Aadhaar Card. Features: 1) Download your e-Aadhaar Card. 2) Get your e-Aadhaar Card on your mobile. 3) Check Status of Aadhaar Card. 4) Book an appointment for Aadhaar Card. 5) Update your personal...