Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I create a database and a user in mysql with command line access?

April 26, 2017Command create database line MySQL user

0

Posted

How can I create a database and a user in mysql with command line access?

1 Answer

0

Posted

You have to enter the below commands in your mysql. create database ; create user ; create user @localhost; set password for = PASSWORD(‘‘); set password for @localhost = PASSWORD(‘‘); grant all on .* to ‘‘; grant all on .* to ‘‘@’localhost’; You have to replace , and in above commands with according values.