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

Install Mysql from ZIP without MySQL Installer or Exe

-
Image
How to install MySQL from Zip file . Step1 : Download  MysSQL   from  myql  website ..    Download From Here you will see  mentioned  folder  and  file .except red circle folder ,that I have  created manually  . Data: for storing database file . error: for storing error  log . tmp: it need to  for installation  of myql Step  2:  now create  a configuration file  my.cnf(linux)  ,my.ini (windows) . Mandatory configuration parameter that need to include in your file as shown . Step 3 : Now  Need to initialize  mysqld  by mentioned any of command .         mysqld    --initialize         mysqld    --initialize-insecure In my case first command did not  work properly  ,but 2 nd command work file ..  ,now  I am telling difference between these command . , first command will generate a  secure key for connecting mysql  but 2 nd command will let you intilize mysql  without password , you can generate it letter  my mentioned command Alter user  ‘root’@’localhos
Read more

Logging in Python .

-
Python logging is as much important for python as flavours in Ice Cream , lies in politics and life without goal .without flavour ice cream means ,it may be tasty for you but not for others ,so  a programme should be like that it should be understandable by others .Logging is used for log purpose of a programme ,what actually it is doing .lies in politics means you can not grow your code without logging otherwise ,it is very difficult to track your programme . So before further moving we can see .where logging can be used . 1: Displaying a information of  programme . 2: Issuing a warning . 3: Catching  a error . 4: Catching Critical information . How we can  achieve by python logging: So for achieving we need to know  ,level in python ,mostly 5 type of level are used in python DEBUG,INFO,WARNING ,ERROR and CRITICAL .let's elaborate what actually each level means in python . DEBUG : Debug we used for diagnostic purpose or detailed information . INFO     : Programme is w
Read more

Dictionary in Python

-
# how to create blank dictionary dictionary = {} print(dictionary) # declare dictionary with key and value dictionary = {"fname": "avni","mname":"singh","lname":"rathor"} print(dictionary) # accessing key and value from dictionary for key in dictionary:     print(key)     print(dictionary[key]) # accessing key and value with items method for key,value in dictionary.items():     print(key,value) #  value can also be fetched from get method print(dictionary["fname"]) print(dictionary.get("fname")) # now will add key and value in dictionary . dictionary["age"] = "31" print(dictionary) # now removing item fname  from dictionary dictionary.pop("fname") print(dictionary) # del keyword can also be used del del dictionary["lname"] print(dictionary) # can clear dictionary with clear function dictionary.clear() print(dictionary) # dict constructior
Read more