Welcome to HBH! If you had an account on hellboundhacker.org you will need to reset your password using the Lost Password system before you will be able to login.

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!