PHPMyAdmin Read-Only User

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
User avatar
hakkuo23
This is my homepage
This is my homepage
Posts: 88
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Thu Aug 05, 2010 5:04 pm

PHPMyAdmin Read-Only User

Post by hakkuo23 »

How can I create a read-only user in PHPMyAdmin so I don't have to worry about people reading my database.cfg file and logging into PHPMyAdmin?
User avatar
Edge100x
Founder
Founder
Posts: 13131
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: PHPMyAdmin Read-Only User

Post by Edge100x »

Which database.cfg are you thinking of? phpMyAdmin, as we install it, does not store database credentials on-disk, and instead they must be specified when any user logs in. If you have a database.cfg file that is being exposed by another application, you should definitely not make that publicly accessible.

There's no way to assign different user privileges in phpMyAdmin, as it just reuses the overall login for the account. We provide a single MySQL login for each webhosting account here, and that login has full access to every database under the webhosting account.
User avatar
hakkuo23
This is my homepage
This is my homepage
Posts: 88
Joined: Thu Aug 05, 2010 5:04 pm

Re: PHPMyAdmin Read-Only User

Post by hakkuo23 »

Oh, the database.cfg I was talking about was in addons/sourcemod/configs. I wanted to block ftp users from accessing it. Can I not do that with aa managed VDS?
User avatar
Edge100x
Founder
Founder
Posts: 13131
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: PHPMyAdmin Read-Only User

Post by Edge100x »

Each game server has just the one FTP account, with full access. I can't think of a way that you could restrict that file so that only certain people using the shared FTP account will see it.

You could use a standalone webhosting account for your main site and only the free one for your game server, though, if this is an important concern.
Post Reply