Category Covered

shell script mysql important command  

Make sure you logged in mysql using the following command
[root@WAP ~]# mysql -u root
mysql> create database [databasename];

//WHICH DATABASE YOU ARE GOING TO USE OR CHANGE DATABASE use the following command
mysql> use dbname;


//HOW TO SET PRIVILEGES ON DATABASE USING SHELL SCRIPT ON LINUX
mysql> grant all privileges on tera_wurfl_demo.* to root;
mysql> flush pri  
By: Tech writer  |   Total Read: 1953  |   Read more..

how to start stop mysql using shell script or ssh  

To start mysql using shell script
[root@WAP ~]# service mysqld start
or
[root@WAP ~]# /etc/init.d/mysql start


To stop mysql using shell script
[root@WAP ~]# service mysqld stop
or
[root@WAP ~]# /etc/init.d/mysql stop

To restart mysql using shell script
[root@WAP ~]# service mysqld restart
or
[root@WAP ~]# /etc/init.d/mysql restart  
By: Tech writer  |   Total Read: 1797  |   Read more..

how to access mysql database using ssh or shell script  

                  Hope you have already install SSh or puty on your computer and now open the ssh or puty
System may ask you credential to access the the panel.

After access you may get something like that
[root@WAP ~]#
so to know the status of your mysql write "service mysqld status" and press enter. Then

you will see the status  
By: Tech writer  |   Total Read: 1813  |   Read more..
Top 15 Posts
Google+