Welcome to HBH! If you have tried to register and didn't get a verification email, please using the following link to resend the verification email.

SQL Database in Linux Server


Scar0ptics's Avatar
Member
0 0

Create a database user and grant all the privileges to the user on the database ‘public_db‘

MariaDB [(none)]> grant all on public_db.* to 'userNameHere'@'localhost' identified by 'Nextcloud@123#'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> exit Bye [root@testing ~]#

MariaDB [(none)]> grant all on public_db.* to 'userNameHere'@'localhost';

Do I leave localhost or do I put a private or public IP right there. I'm thinking it stays the same, but I want to make sure. Also will either of these work???

MariaDB [(none)]> grant all on public_db.* to 'userNameHere'@'localhost' identified by 'Nextcloud@123#';


Scar0ptics's Avatar
Member
0 0

I figured it out!