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.
> 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.
Thank you so much @E-werd.
So, to conclude.
I won't touch the said file (debian.cnf)
Run the script below as you have mentioned.
mysql -u root -p
CREATE DATABASE throat;
CREATE USER 'throat'@localhost IDENTIFIED BY 'Pass1234';
GRANT ALL PRIVILEGES ON throat.* TO 'throat'@localhost;
exit
One last question: Is the mysql password the same as the root password? It's asking me for a password when I run mysql -u root -p. Sorry if you found the question stupid. I'm really dumb in this.
Thank you so much @E-werd.
So, to conclude.
1. I won't touch the said file (debian.cnf)
2. Run the script below as you have mentioned.
```
mysql -u root -p
CREATE DATABASE throat;
CREATE USER 'throat'@localhost IDENTIFIED BY 'Pass1234';
GRANT ALL PRIVILEGES ON throat.* TO 'throat'@localhost;
exit
```
One last question: Is the mysql password the same as the root password? It's asking me for a password when I run `mysql -u root -p`. Sorry if you found the question stupid. I'm really dumb in this.
There's linux root (as defined in /etc/passwd, the super user account on the system) and there's the mysql/mariadb root. They're two different things, the latter being specifically for mysql/mariadb.
There's linux root (as defined in /etc/passwd, the super user account on the system) and there's the mysql/mariadb root. They're two different things, the latter being specifically for mysql/mariadb.
Thanks @E-werd. It's on my local machine. So it's more of a test site.
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?