[Stones]

So i've been testing my script on my localhost for about 4 or 5 days now, everything works fine, every thing says, SQL data loads from phpmyadmin and well, everything works the way it should, so, i finally uploaded the script to my windows VPS, installed XAMP and then started the server, i went in game and i noticed that nothing had really loaded.

Код:

if(DEVMODE == 0)mysql_connect("localhost","root","samp","");

So thats the connection information for the MySQL server i've tried changing to 127.0.0.1 i've tried changing to the actual IP of the VPS and it just won't connect.

And yes, i've checked if it has a password on, it doesn't.

Any help would be greatly appreciated!

[Stones]

It's actually rejecting the connection now

Код:

[19:03:55] >> mysql_connect( )

[19:03:55] CMySQLHandler::CMySQLHandler() - constructor called.

[19:03:55] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...

[19:03:55] CMySQLHandler::Connect() - Access denied for user 'root'@'localhost' (using password: NO) (Error ID: 1045)

[jlalt]

Quote:

Originally Posted by Stones It's actually rejecting the connection now Код: [19:03:55] >> mysql_connect( ) [19:03:55] CMySQLHandler::CMySQLHandler() - constructor called. [19:03:55] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ... [19:03:55] CMySQLHandler::Connect() - Access denied for user 'root'@'localhost' (using password: NO) (Error ID: 1045)

are you sure that your vps phpmyadmin page doesn't require password? mind if you sure it with me on private message?

also you may go to http://ip/phpmyadmin to see what's up there. good luck.

[Stones]

I reinstalled XAMP on my VPS and left the connection details unchanged, works now, thanks for the help anyway!

[Vince]

Security issues are through the roof. Never run shit as root and always use a password. The password for your admin account is probably "admin" or "password" as well.