Access denied MYSQL ?
#1

mysql_log
Code:
[12:21:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
[12:21:13] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
this happens on my localhost when I want to login lol
I have 3 connections done to mysql server.
From FS
From GM
From my UCP (website)

Would that be an issue? my main server isn't affected only localhost.

I unload FS> I can login
I load FS> I can't login
They use different tables.
Reply
#2

Quote:
Originally Posted by Crystallize
View Post
mysql_log
Code:
[12:21:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
[12:21:13] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
this happens on my localhost when I want to login lol
I have 3 connections done to mysql server.
From FS
From GM
From my UCP (website)

Would that be an issue? my main server isn't affected only localhost.
Disable firewall, and check if the connection is allowed to localhost (mysql server allow more than 1 connection), check the user login's
Reply
#3

Quote:
Originally Posted by XeonMaster
View Post
Disable firewall, and check if the connection is allowed to localhost (mysql server allow more than 1 connection), check the user login's
I unload FS I can login.
I load FS I can't login.
What the issue could be? The FS is not affiliated with main gm it uses different tables&db
Reply
#4

Quote:
Originally Posted by Crystallize
View Post
I unload FS I can login.
I load FS I can't login.
What the issue could be? The FS is not affiliated with main gm it uses different tables only same database.
it might be the FS and gamemode use same handle, Mysql Handle is an Id (number) not something special
so i guess you need to set it manualy (spell ;-

like that

OnGamemode:

PHP Code:
new MySQL:Database 0
OnFilterScript:

PHP Code:
new MySQL:Handle 1
OnAnythingElse

PHP Code:
new MySQL:Handle = (int anything else ^) 
Reply
#5

my onfsinit

my mysql variable (i set it as you said or maybe I got it wrong?
Code:
new mysql = 1;
Reply
#6

Quote:
Originally Posted by Crystallize
View Post
my onfsinit
Code:
	mysql=mysql_connect(--); //Connecting to mysql database
my mysql variable (i set it as you said or maybe I got it wrong?
Code:
new mysql = 1;
what mysql plugin you are using?

if you use R40+ you should put MySQL: tag to be

Code:
new MySQL:mysql = 1;
Reply
#7

Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
Reply
#8

Quote:
Originally Posted by Logic_
View Post
Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
I'm a fucking idiot but I will delete it anyways its a test db wont be useful in next 5 mins.
And yes im using r39 if im not mistaken lol
Reply
#9

The main question arises why are you using the FS, you can integrate it in your script.
Reply
#10

Quote:
Originally Posted by Logic_
View Post
Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
no, he is using R40 based on mysql_connect that he used
Quote:

password and database parameters swapped in mysql_connect:
Code:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASSWORD);
becomes
Code:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);

so you should put MySQL: tag on the variable @Crystallize

EDIT: i did saw the Database in last of params on mysql_connect if im not mistaken
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)