Problems with mysql connection

TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Post by TI INDIAN »

Well i tried to run a query on phpmyadmin to grant access but it says access is denied to the database 'ip' ..
YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Post by YamiKaitou »

I never said anything about PMA
Retired, don't bug me
TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Post by TI INDIAN »

Hum... i tried to .. when i click and try to save or press enter it doesnt save it .. and it doesnt lemme save it :P
TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Post by TI INDIAN »

ok... I got something new.. I know but it is the same as the one who started this thread but please take a look at this

Code: Select all

Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query failed!
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Message: Table 'dg_site304.amx_serverinfo' doesn't exist (1146)
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '77.111.225.2:27015'
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query failed!
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Message: Table 'dg_site304.amx_reasons' doesn't exist (1146)
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query statement: 
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Menu item 19 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 21 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Post by YamiKaitou »

You didn't install and setup the Web Interface yet
Retired, don't bug me
TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Post by TI INDIAN »

Hum... Can you explain a little more in a simple language.. didnt get you.. Web interface..Is it installed in mysql or in ftp?? or Do i have to make a support ticket to do it.. :)

Update: I have a rented a website and they have already made database in phpmyadmin... The setup is done by them not me...

Okay i got a message from them.. the message is

Hello,

All the informations on your database are available on the admin panel, in the "My website" menu :

http://verywiki.net/en/VeryGames_panel_ ... ase_access

---

We normally do not reject outside connection, and remote access to the database is allowed.

Can you give me examples of IP addresses that cannot reach the database ?

Best regards,


I sent them that my own game servers cant reach the database...

UPDATE2: How to know that which amx_table_prefix i will use... ?? now I am using amxbans as amx_table_prefix
YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Post by YamiKaitou »

Have you set up the web part yet?
Retired, don't bug me
TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Post by TI INDIAN »

Ok yamikatou Now mysql works correctly.. i just had a small problem i wrote wrong table_prefix .. and now it works ... Special Thanks to Sami .. without him i could've done this and Thanks to you also yamikatou...
Locked