How to install MySql 5.6 in RHEL6 , if Internet connectivity is not there

-
Installing MySql 5.6 in  My Linux Server RHEL6 , but problem was that there was no internet connectivity in server .
so for installing  MySql need to download  three .rpm file , that you can download from any other   another internet connected pc  and put those rpm file in RHEL6 Machine .

MySQL-server-5.6.16-1.el6.X86_64.rpm
MySQL-client-5.6.16.el6.x84_64.rpm
MySQL-embeded-5.6.16-1.el6.x86_64.rpm

i have installed all three rpm by using command :
rpm -ivh server   then  rpm -ivh embeded  then rpm - client .

but when i started service ,service shows ,there is no mysql service available in ,so i tried to uninstall by using command
rpm -ev .rpm file ..........................................
but  it is showing rpm file is not installed . after searching from multiple troubleshoot ,i have found a solution to uninstall rpm file by using below mentioned command  :

rpm -ev --nonscripts   make sure , remove .rpm extension from the file name for uninstalling the file ..

after uninstalling successful  , now  i am getting error  while again installing , due to conflicting of few sql files with existing file  in mysql server .
so  in this case ,use  --force key  , ex  : rpm -ivh --force  .
in this way i am able to install mysql5.6 in server .

---------------Now How to setup UserName and Password for same  -----------------------------------------

First  : run command  = mysql_safe --skip-grant-tables &
Second  :  mysql -u root
by this you will enter into mysql cli .from here like as usual ,we can  set username and password
by below mentioned  command:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');


ok it's done ...........................


Q  : how to take remote of windows from linux .
Ans : install yum -y rdesktop or rpm -qa rdesktop   . then use command rdesktop for taking remote

Comments

Post a Comment

Popular posts from this blog

Triggers in MySQL

-
Image
Trigger MySQL: Trigger can be used in two ways with before and after with Delete ,insert and update command .Let me show you a example of before update   . I have created two table employee and employee_audit . employee table is table where my raw data will be stored and employee_audit table is table where to store data after changes or can say trigger execution . Table structure of employee and employee_audit table : CREATE TABLE   `test`.`employee` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `lstname` varchar(10) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; CREATE TABLE   `test`.`employee_audit` ( `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `lstname` varchar(20) DEFAULT NULL,   `action` varchar(50) DEFAULT NULL,   `upd_datetime` datetime DEFAULT NULL,   `newname` varchar(20) DEFAULT NULL, ...
Read more

MySQL 8.0.2 Windows Function

-
Q : What is sql windows function  ? Ans  : a windows sql function will perform aggregation for each row in result set  , letting  each row in  the result set , leatting each row retain its identity . Example  : mysql> CREATE TABLE t(i INT); mysql> INSERT INTO t VALUES (1),(2),(3),(4); mysql> SELECT SUM(i) AS sum FROM t; +------+ | sum  | +------+ |   10 | +------+ mysql> SELECT i, SUM(i) OVER () AS sum FROM t; +------+------+ | i    | sum  | +------+------+ |    1 |   10 | |    2 |   10 | |    3 |   10 | |    4 |   10 | So  you can see only by  using over()  windows function  , sum is showing along with  each value that  has been summed . Q: what are types of windows sql function  ? Ans :  sql aggregate function can be used in ...
Read more

list in python

-
# declaring a list list_t = [ "my" , "name" , "is" , "abhishek" ] print (list_t) # accessing first list item print (list_t[ 0 ]) # accessing all item of list for x in list_t: print (x) # inserting item at position in list . list_t.insert( 0 , "hello" ) print (list_t) # extending a list lastname = [ "rathor" ] list_t.extend(lastname) print (list_t) # removing item from list list_t.pop( 0 ) print (list_t) list_t.remove( "rathor" ) print (list_t) # index of item in list print (list_t.index( 'name' )) # sorting an index list_t.sort() print (list_t) # reverse is also possible in index list_t.reverse() print (list_t) # constructing a list with constructor list2 = list (( "abhishek" , "pratap" , "singh" , "rathor" )) print (list2) # tuple and list both behave same except tuple are unchangeable and ordered collection # so inserting and removing ...
Read more