MySQL Problem
#10

Adytza helped me get past all that, but now I am faced with this problem:

Код:
SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[21:23:20] password = ""  (string)
[21:23:20] maxnpc = 0  (int)
[21:23:20] 
[21:23:20] Server Plugins
[21:23:20] --------------
[21:23:20]  Loading plugin: streamer.so
[21:23:20] 

*** Streamer Plugin v2.6 by Incognito loaded ***

[21:23:20]   Loaded.
[21:23:20]  Loading plugin: sampmysql.so
[21:23:20] 
/*************************************************/
/* SAMP-MySQL v0.15 Plugin loaded successfully ! */
/*************************************************/

[21:23:20]   Loaded.
[21:23:20]  Loading plugin: nativechecker.so
[21:23:20]   Loaded.
[21:23:20]  Loading plugin: mysql.so
[21:23:20]   Failed (plugins/mysql.so: invalid ELF header)
[21:23:20]  Loaded 3 plugins.

[21:23:20] 
[21:23:20] Filterscripts
[21:23:20] ---------------
[21:23:20]   Loading filterscript 'gate.amx'...
[21:23:20]   Unable to load filterscript 'gate.amx'.
[21:23:20]   Loaded 0 filterscripts.

[21:23:20] MYSQL: Attempting to connect to server...
[21:23:20] 
Connection to MySQL database: Successfull !
[21:23:20] Error in mysql_select_db: Access denied for user 'berzerkr_dj'@'184.171.165.221' to database 'berzerkr_berzerkroleplay'
[21:23:20] MYSQL: Database connection established.
[21:23:20] Error in mysql_query: No database selected
[21:23:20] Error in mysql_store_result: No database selected
You can see that the database has been created, I've created a username on my web host to and allowed my server IP to get access to the MySQL. Now it says no database selected? On my gamemode's Pawno, I've set it up like this:

#define MYSQL_HOST "184.171.165.222"
#define MYSQL_USER "berzerkr_dj"
#define MYSQL_PASS "HIDDEN"
#define MYSQL_DB "berzerkr_berzerkroleplay"

That's exactly how it is supposed to be set up, as well. Now, what am I doing wrong?
Reply


Messages In This Thread
MySQL Problem - by sleejay - 17.11.2012, 00:12
Re: MySQL Problem - by sleejay - 17.11.2012, 14:22
Re: MySQL Problem - by sleejay - 17.11.2012, 15:23
Re: MySQL Problem - by InfiniTy. - 17.11.2012, 15:26
Re: MySQL Problem - by sleejay - 17.11.2012, 15:51
Re: MySQL Problem - by InfiniTy. - 17.11.2012, 16:05
Re: MySQL Problem - by sleejay - 17.11.2012, 16:14
Re: MySQL Problem - by InfiniTy. - 17.11.2012, 16:27
Re: MySQL Problem - by sleejay - 17.11.2012, 16:35
Re: MySQL Problem - by sleejay - 17.11.2012, 17:08

Forum Jump:


Users browsing this thread: 6 Guest(s)