AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   [MySQL] Access denied (https://forums.alliedmods.net/showthread.php?t=49442)

SweatyBanana 01-04-2007 00:19

[MySQL] Access denied
 
Ok so far every single SQL database I have access to has given me this message..

Quote:

L 01/03/2007 - 23:01:03: [mine.amxx] tuple: 1
L 01/03/2007 - 23:01:37: [AMXX] Plugin ("mine.amxx") is setting itself as failed
.
L 01/03/2007 - 23:01:37: [AMXX] Plugin says: Access denied for user 'aoa@dajoob.
com'@'c-67-167-221-218.hsd1.il.comcast.net' (using password: YES)
L 01/03/2007 - 23:01:37: [AMXX] Displaying debug trace (plugin "mine.amxx")
L 01/03/2007 - 23:01:37: [AMXX] Run time error 1: forced exit
L 01/03/2007 - 23:01:37: [AMXX] [0] mine.sma::load_sql (line 62)
SQL info is correct: http://www.chaos-realms.com/aoa/db_listtables.php
but it is not creating the tables...

Trent-Resnor 01-04-2007 02:28

Re: [MySQL] Access denied
 
Have you tried creating the table you wanted to use before running the plugin?

SweatyBanana 01-04-2007 02:28

Re: [MySQL] Access denied
 
Note that I cannot connect to the database..

Trent-Resnor 01-04-2007 02:30

Re: [MySQL] Access denied
 
ermmm, not even outside of the plugin? (cpanel etc?)
and is this data base hosted on your computer? or a different location?

SweatyBanana 01-04-2007 02:33

Re: [MySQL] Access denied
 
Quote:

Originally Posted by Trent-Resnor (Post 423465)
ermmm, not even outside of the plugin? (cpanel etc?)

Click the link that is in my first post.. As you can see, I have access when connecting from a different website (I made that little PHP script to show tables of the database...)

I have access there, but when I enter my info in sql.cfg, it gives me the error above.

SQL server is on a website.. Not my home computer so localhost is not a player.

over_mind 01-04-2007 06:07

Re: [MySQL] Access denied
 
Did you make sure the access host is set to the i.p of w/e computer you're using?

MaximusBrood 01-04-2007 06:35

Re: [MySQL] Access denied
 
Most SQL databases will only allow 127.0.0.1 to access the database by default.
You will have to add your server's IP to the allowed clients list.

over_mind 01-04-2007 06:51

Re: [MySQL] Access denied
 
Oops I'm sorry I meant the server IP not computer IP :oops:

SweatyBanana 01-04-2007 09:13

Re: [MySQL] Access denied
 
Quote:

Originally Posted by MaximusBrood (Post 423504)
Most SQL databases will only allow 127.0.0.1 to access the database by default.
You will have to add your server's IP to the allowed clients list.


Already did...

SweatyBanana 01-04-2007 18:18

Re: [MySQL] Access denied
 
New problem:

Code:

L 01/04/2007 - 16:20:05: [mine.amxx] tuple: 1
L 01/04/2007 - 16:20:17: [AMXX] Plugin ("mine.amxx") is setting itself as failed
.
L 01/04/2007 - 16:20:17: [AMXX] Plugin says: You have an error in your SQL synta
x; check the manual that corresponds to your MySQL server version for the right
syntax to use near ')' at line 1
L 01/04/2007 - 16:20:17: [AMXX] Displaying debug trace (plugin "mine.amxx")
L 01/04/2007 - 16:20:17: [AMXX] Run time error 1: forced exit
L 01/04/2007 - 16:20:17: [AMXX]    [0] mine.sma::load_sql (line 83)



All times are GMT -4. The time now is 22:29.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.