How do you change a password for an existing user via
mysqladmin?




Answers were Sorted based on User's Feedback



How do you change a password for an existing user via mysqladmin?..

Answer / anil alpati

mysqladmin -u root -p password "oldpassword" "newpassword"

Is This Answer Correct ?    3 Yes 0 No

How do you change a password for an existing user via mysqladmin?..

Answer / guest

mysqladmin -u root -p password "newpassword" .

Is This Answer Correct ?    4 Yes 2 No

Post New Answer




More MySQL Interview Questions

How do you backup a database in mysql?

0 Answers  


For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers  


about foregine

2 Answers  


What is difference between inner vs self vs cross?

0 Answers  






Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 Answers  


List some mysql advantages and disadvantages?

0 Answers  


Tell us something about heap tables?

0 Answers  


What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Wipro, CSS, Aufait,


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  


What is the purpose of using ifnull() function?

0 Answers  


Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers  






Categories