Donate to us via Paypal!
The important thing is not to stop questioning. - Albert Einstein
Thursday, October 01, 2020
Navigation
Home
 Find:
 Information:
Learn
Communicate
Submit
Shop
Challenges
 Exploit:
 Programming:
 Think:
 Track:
 Patch:
 Other:
 Need Help?
Other
Members Online
Total Online: 99
Guests Online: 97
Members Online: 2

Registered Members: 128895
Newest Member: owowojube
Latest Articles

View Thread

HellBound Hackers | Computer General | Web Server

Author

SQL Database in Linux Server

Scar0ptics
Member



Posts: 229
Location: ∆ P®0X¥ W0R|D ∆
Joined: 19.11.13
Rank:
Mad User
Posted on 05-08-16 21:09
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 '[email protected]#';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit
Bye
[[email protected] ~]#




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 '[email protected]#';
overlay-network.ddns.net
Author

RE: SQL Database in Linux Server

Scar0ptics
Member



Posts: 229
Location: ∆ P®0X¥ W0R|D ∆
Joined: 19.11.13
Rank:
Mad User
Posted on 06-08-16 20:06
I figured it out!

Edited by Scar0ptics on 07-08-16 05:24
overlay-network.ddns.net