Mysql database setup

how does one setup up the mysql database?

i have tried to open mysql and do this
created a new data base called nextcloud
i then create a new user ncadmin and password
i then open the new user and select the nextcloud database i created and select all the options and apply.

is this the way you create a mysql user and database?

There are lots of ways to do it; I use the MySQL command line. But what you’re describing should work fine–Nextcloud will create all the tables with the appropriate structure.