The idea of accessing this file was to use the username and password within it for the throat database connection. The guide was intended more as a way to get you up and running with a development environment so I wouldn't use this for a production site. This goes double now that you've showed us this information.
You'll want to go into the MySQL console and create a database and a new user that throat will use to access it. You need to know the root login for MySQL/MariaDB, once you do you can use these commands to create the database and user. Change 'Pass1234' with whatever password you'd like, I'd suggest something randomly generated. DO NOT LOSE THIS.
mysql -u root -p
CREATE DATABASE throat;
CREATE USER 'throat'@localhost IDENTIFIED BY 'Pass1234';
GRANT ALL PRIVILEGES ON throat.* TO 'throat'@localhost;
exit
Thanks @E-werd. It's on my local machine. So it's more of a test site.
You'll want to go into the MySQL console and create a database and a new user that throat will use to access it. You need to know the root login for MySQL/MariaDB, once you do you can use these commands to create the database and user. Change 'Pass1234' with whatever password you'd like, I'd suggest something randomly generated. DO NOT LOSE THIS.
Since it's on my local machine/test site, should I leave the contents of the file as is instead of going through with the steps you have mentioned below?
mysql -u root -p
CREATE DATABASE throat;
CREATE USER 'throat'@localhost IDENTIFIED BY 'Pass1234';
GRANT ALL PRIVILEGES ON throat.* TO 'throat'@localhost;
exit
should I leave the contents of the file as is instead of going through with the steps you have mentioned below?
Both. You shouldn't be changing the contents of that file anyway.
So, I've reached this point. I'm not sure what do with this file as it says in DO NOT TOUCH! in BOLD
Requesting for help as I don't want to move ahead by making some edits and mess up my installation process, which up to this point has been smooth. @E-werd, thoughts please!
The is what the set up file says. As you can see, it instructs #user and #password to be commented (that's my assumption). Also, if I do comment these out, should it be for both instances of host and user.
On giving the above command i.e. nano /etc/mysql/debian.cnf, this files opens up and these are the contents of the file. What should I do with this file now?