Skip to main content

Mysql Scripts in Linux Command Line Terminal

In MySQL user always tries to connect with the server via command line interface such as remote login like 'ssh' then they troubled themselves in using graphical interface and get the required output quickly. So they need to automate that task. In this Blog I am going to suggest you a way to do this ...
First of all we need to know that a MySQL service is kept in /etc/init.d/mysqld and we need to invoke that in order to use mysql server and client.
To do this use following command in terminal :
service /etc/init.d/mysqld start
or
service mysqld start

When mysql server is started make a directory like /home/anduril/shubham_Script and after entering into that directory use this command in your terminal.

vi connect_string.sh

It will create a file with the name connect_string.sh you can give any name you want. Press 'i' to edit and enter the following text :

mysqlshow -u root -proot
mysqladmin version -u root -proot
mysqladmin variables -u root -proot
mysqladmin ping -u root -proot
mysql -u root -proot
echo Execute SQL from Linux command line interface:
mysql -h localhost -u root -proot -e "select host,db,user from db" mysql
After enterning all text press esc and use ':wq' to exit from vim...
Where mysql is plateform -u stands for username in this case it is root and the switch -p demands for password which is concatenated with the switch -p and in this case it is root. Users can also specify their host with the switch -h and the host name with a space between them.
In the 5th command we have used a file named 'queries_mysql_script.sql' and saved our queries in this file and run our script.
In the Last statement we have used -e switch to enter our command at the terminal and have fun .
This small script could be very useful when you need to take daily dump and forward it in zip . I hope it helps you.

Comments

Post a Comment

Popular posts

A few useful sql functions

Start mysql in Ubuntu without having root privilege:- If you want to use mysql in Ubutu you can use following command which will use a root level privilege   $ mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 147 Server version: 5.1.49-1ubuntu8.1-log (Ubuntu) When it demands to enter the password fill it with 'root' and hopefully you'll get logged in .   Last_insert_id():- (with no argument) returns the first automatically generated value that was set for an AUTO_INCREMENT column by the most recently executed INSERT statement to affect such a column. For example, after inserting a row that generates an AUTO_INCREMENT value, you can get the value like this:   mysql> SELECT LAST_INSERT_ID(); Database():- Database() method returns the current selected database and you can use it in your communication and your queries. The syntax is :   mysql>select Database (); User():- It a...
Post a Comment
Read more

Add user in Sudoer file

The command sudo provides other users to run a command as a root. To use sudo user must have their level of privilege in /etc/sudoer file. In some cases this file is set for read only and others can edit that file and add their user name in Sudoer for this case such as Fedora 12 users need to provide this syntax as a root on their terminal. Syntax for adding a user in Sudoer file is: echo "username ALL=(ALL) NOPASSWD:ALL" >> /etc/sudoers And to gain the writing privilege you can use the following code in your terminal : chmod 755 /etc/sudoers This code will be enough to give permissions to the user and his user group. If you are an ubuntu user you can easily add your user in this file like: vi /etc/sudoers And you will get a text file. Afterward you need to press 'i' for edit and edit by adding your username just below "root ALL=(ALL) ALL" "username ALL=(ALL) ALL"
Post a Comment
Read more

Hipchat and Icinga

Hipchat Notify 2.0 Hipchat notification with API 2.0 to be used with ICINGA/Nagios Table of Contents Table of Contents Author Audience Introduction Ruby Script Script used on server Service notification Host notification Change in command.conf for Icinga server Example notification Roadmap Author Shubhamkr619@gmail.com Audience System Engineers and operation engineers Introduction Change the default mail notification of Icinga server to hipchat notification using ruby code. This will allow a single place of management of all the notification and alerts across organization. Let that be service,host or business level alerts all can be managed and monitored using hipchat and hubot will give certain advantage over traditional alerting system. Proactive and reactive alerting Managed monitoring Single place of all the alerts Better communication and collaboration Integration with multiple tools in CI cycle Jenkins Chef ...
Post a Comment
Read more

Send mail via SMTP using PERL

Send Mail to gmail account with perl Installation of Send::SMTP::Gmail:  In order to send mail via Gmail, you need to have TLS verification. Having TLS and Installation of perl package Send::SMTP::Gmail is covered in brief.  For Ubuntu:  sudo apt-get install openssl libnet-ssleay-perl  libcrypt-ssleay-perl For RedHat/Fedora/CentOs: yum  install  perl-IO-Socket-SSL  perl-Digest-HMAC  perl-TermReadKey  perl-MIME-Lite  perl-File-LibMagic  perl-IO-Socket-INET6 perl-Net-SSLeay perl-Crypt-SSLeay perl-Email-Send Usages:  Following method is used to send mail and attachment in it. Please read it and post your comments. sub sendMail {         use Email::Send::SMTP::Gmail;         my $to=shift;         my $cc=shift;         my $subject=shift;         my $body=shift;       ...
Post a Comment
Read more

Enter your email address: