Install Mysql from ZIP without MySQL Installer or Exe

-
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 2nd command work file ..  ,now  I am telling difference between these command . , first command will generate a  secure key for connecting mysql  but 2nd command will let you intilize mysql  without password , you can generate it letter  my mentioned command
Alter user  ‘root’@’localhost’ identified by password  ‘password’


Step 4 : so now we have initialized , go to bin install and type  “mysqld”
if server start  perfectly  without error .. then it will be in connected state .else it will break  and check for Error log.

Step 5: where to check Error Log .
open Error log folder ,you will see  error in error log  as shown



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