Total Pageviews

Sunday, 6 November 2022

SQLSERVER : How to Login SQLSERVER

 HOW TO LOGIN SQLSERVER


1) OPEN CMD

2) TYPE BELOW COMMAND:-

     mysql -u root -p

3) enter password  


(Note : if u dont know password pls reset it usin update commmand


update mysql.user set password ='new pasword1' 

where user='root';

)


4) if u dont know the password just change default int file..which located in BIN folder.


------------------------How to change password of root user---------


1)mysqladmin -u root -p password 

2) enter password      (Note :- skip and plz press enter)

3) new password        (Note :- plz enter your new password)

4) confirm password        (Note :- plz enter your confirm password)


No comments:

Post a Comment

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...