How do I create a mysql username and password?



How do I create a mysql username and password?..

Answer / Satyendra Pratap Singh

To create a new MySQL user with a password, use the following command:nGRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; Replace 'username' with your desired username and 'password' with your desired password.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is mysql a dbms?

1 Answers  


How many ways we can retrieve the date in result set of mysql using php?

1 Answers  


What ascii 31?

1 Answers  


what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1 Answers  


What is a delimiter in mysql?

1 Answers  


Why do we use mysql?

1 Answers  


What is the full form of mysql?

1 Answers  


How to create trigger in mysql workbench?

1 Answers  


How can you create and drop view in mysql?

1 Answers  


Where is the mysql data directory?

1 Answers  


What is table level locking in mysql?

1 Answers  


Does mysql use t sql?

1 Answers  


Categories