How can you change the root password if the root password is lost?

  • In such cases when the password is lost the user should start the DB with – skip-grants-table and then change the password. Thereafter with the new password the user should restart the DB in normal mode.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What are federated tables?

What is the difference between Unix timestamps and MySQL timestamps?

How can one take incremental backup in MySQL?

What is the difference between MyISAM Static and MyISAM Dynamic?

How to change a password for an existing user via Mysqladmin?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
How can you change the root password if the root password is lost?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges