BF2Statistics - #1045 - Access denied for user

[Ver24436]

Hi,

I'm attempting to install BF2Statistics and I'm completely new to using PHPMyAdmin.

I'm at a loss as to how to grant DBO Rights and Grant Global Right 'FILE ACCESS'

I have tried

GRANT ALL PRIVILEGES ON * . * TO 'xxxxxx'@'localhost' IDENTIFIED BY PASSWORD 'xxxxxx'


I receive the following Error:

#1045 - Access denied for user 'xxxxxx'@'localhost' (using password: YES)


Thanks for you time.

[Edge100x]

For security reasons, we won't be able to grant you this access right on the shared hosting machine.

From http://dev.mysql.com/doc/refman/5.1/en/ ... #priv_file:

The FILE privilege gives you permission to read and write files on the server host using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements and the LOAD_FILE() function. A user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL server. (This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also enables the user to create new files in any directory where the MySQL server has write access. As a security measure, the server will not overwrite existing files.

(This would allow you to masquerade as the MySQL user when it comes to files, giving you access to all customer databases and not just yours.)

It's a bit surprising that any application would need this right. If it truly does, you'll have to run the MySQL server on your own VDS/VPS/dedicated server, such as one of ours from https://www.nfoservers.com/order-virtua ... server.php (no provider will be able to grant you this right on a shared webhosting platform).

[Ver24436]

Thanks for the quick responce...

As I mentioned this is all very new to me and I can respect the security conserns.

We currently have a VDS/VPS Package with Nuclear Fallout.

Two core: Perfect for 2-6 game servers or several large sites.

* Two full, dedicated HT CPU cores (Core i7 or better)
* 2048 MB of RAM
* 200 GB of hard drive space
* 1000 GB of InterNAP bandwidth transfer
* Two IP addresses

We would like to install the Private BF2 Ranking System from BF2Statistics.com

According to the readme it requires that I Grant DBO (Database Owner) rights to new user account.

If I understood you correctly if we move the hosting to our VDS/VPS, I will be able to do this?

[Edge100x]

Yes, you'd be able to run the whole thing on your VDS. To do it, you'll need to have LAMP/WAMP installed, though, most likely. If you need help with the resources you'll need for one of those, please post in the dedicated server/VDS forum and I'll do my best to assist.

[Ver24436]

Edge100x,

Thanks again for the quick assistance. I have a few more questions.

If i am going to be using WAMP on our VDS, do i still need the hosting package we purchased, it's still currently in the 2 day trial period. Can I cancel this and still host from our VDS?

And how does the hosting impact our monthy bandwidth? Since the hosting package permited unlimited bandwidth but the VDS is limited to 1000 GB / month?

[Edge100x]

If i am going to be using WAMP on our VDS, do i still need the hosting package we purchased, it's still currently in the 2 day trial period. Can I cancel this and still host from our VDS?

That's up to you. Our webhosting would still work well for things like fast map downloads, that you might want to have unlimited data transfer, and it's also very easy to use, but it's optional.

And how does the hosting impact our monthy bandwidth? Since the hosting package permited unlimited bandwidth but the VDS is limited to 1000 GB / month?

Simple stats generation shouldn't even make a blip for you