Raised This Month: $ Target: $400
 0% 

[MySQL] Access denied


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
SweatyBanana
BANNED
Join Date: Sep 2005
Location: LOL
Old 01-04-2007 , 02:33   Re: [MySQL] Access denied
Reply With Quote #1

Quote:
Originally Posted by Trent-Resnor View Post
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.
SweatyBanana is offline
Send a message via AIM to SweatyBanana Send a message via Yahoo to SweatyBanana
over_mind
Member
Join Date: Aug 2006
Location: Cajun Country!
Old 01-04-2007 , 06:07   Re: [MySQL] Access denied
Reply With Quote #2

Did you make sure the access host is set to the i.p of w/e computer you're using?
over_mind is offline
Send a message via AIM to over_mind Send a message via MSN to over_mind
MaximusBrood
Veteran Member
Join Date: Sep 2005
Location: The Netherlands
Old 01-04-2007 , 06:35   Re: [MySQL] Access denied
Reply With Quote #3

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.
__________________
Released six formerly private plugins. Not active here since ages.
MaximusBrood is offline
SweatyBanana
BANNED
Join Date: Sep 2005
Location: LOL
Old 01-04-2007 , 09:13   Re: [MySQL] Access denied
Reply With Quote #4

Quote:
Originally Posted by MaximusBrood View Post
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...

Last edited by SweatyBanana; 01-04-2007 at 18:18.
SweatyBanana is offline
Send a message via AIM to SweatyBanana Send a message via Yahoo to SweatyBanana
SweatyBanana
BANNED
Join Date: Sep 2005
Location: LOL
Old 01-04-2007 , 18:18   Re: [MySQL] Access denied
Reply With Quote #5

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)
SweatyBanana is offline
Send a message via AIM to SweatyBanana Send a message via Yahoo to SweatyBanana
SweatyBanana
BANNED
Join Date: Sep 2005
Location: LOL
Old 01-04-2007 , 18:39   Re: [MySQL] Access denied
Reply With Quote #6

Ahh just found the lines where it is..

Code:
        if(!SQL_Execute(Queries[Count]))
        {
            // if there were any problems
            SQL_QueryError(Queries[Count],g_Error,511)
            set_fail_state(g_Error)
        }
SweatyBanana is offline
Send a message via AIM to SweatyBanana Send a message via Yahoo to SweatyBanana
SweatyBanana
BANNED
Join Date: Sep 2005
Location: LOL
Old 01-04-2007 , 19:20   Re: [MySQL] Access denied
Reply With Quote #7

Nevermind me

Thanks Maximus for pointing out my dumb mistake.. So small, but so big..

I had a few other small errors in there too, but thank you very much!
SweatyBanana is offline
Send a message via AIM to SweatyBanana Send a message via Yahoo to SweatyBanana
Old 01-05-2007, 09:46
TieuLien
This message has been deleted by TieuLien.
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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