• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Tutorial] How to lock us_opt1 database privileges to localhost on MySQL

ralke

(҂ ͠❛ ෴ ͡❛)ᕤ
Joined
Dec 17, 2011
Messages
1,470
Solutions
27
Reaction score
844
Location
Santiago - Chile
GitHub
ralke23
Twitch
ralke23
Hi, this tutorial will talk about a very simple glitch that some newbies might face when using MySQL. There's an easy way to access to server database, you just need to write, for example: myserver.com/us_opt1 and that will do the trick, you're in the database! The reason behind this? You dont have properly configure the database privileges, they're ALL GRANTED, and what we need is to change them to LOCAL to only allow local access to up_opt1 and others.

So first... Go to Uniform Server folder and then seach for httpd, it is located on \core\apache2\conf, in case of Xampp the file will be called httpd-xampp.conf
httpd.png


Open that file on Notepad++ and search for:
Code:
#== Default phpMyAdmin
<Directory "${US_ROOTF}/home/us_opt1/">
  Options Indexes Includes
  AllowOverride All
  require All Granted
</Directory>

Then you will encounter something like this:
unknown.png

This means that the privilege access to us_opt1, us_opt2 and others is allowed to enter on any other CPU, and what we need, is to only LOCALLY access to our database to avoid intruders! For that just change all granted to local:

Code:
require All Granted

Change to
Code:
require local

As long you change us_opt1 to local this will protect yourself from intruders! I dont really know if is necessary to change other directories such as us_opt2, /home/us_pac/, and others, I would like to clear out that in this thread.

That's the tutorial!
Hope this to be helfull, Regards!
 
Last edited:
It's for phpMyAdmin, not MySQL.
Other than that, good job :)
 
Back
Top