Jump to content
  • 0

Give me help pls!


Question

Posted (edited)

when i am trying to connect mysql base this is what i am getting >

mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)

what i have to do? this is the code i am using

https://pastebin.com/TnRLZXrm

pls some solutions...

Edited by Equi93

9 answers to this question

Recommended Posts

  • 0
Posted (edited)

funny, you only need to set the host of user that the user is allowed to connect from to.

44.2.56.12 -> you try to connect into mysql with user/pass

33.2.11.24 -> server says no this user/pass is only allowed from 127.0.0.1 or localhost

you need to allow it from 44.2.56.12 

simple as hell

 

side note the problem is on server, and if you use live data not cached each user who opens your website will also open database connection meaning you ddos your server all by your self.

 

imagine you run like hell and hit your head into a wall get up and run again into the wall.

learn how to cache database data ffs its 2021

 

what is most amazing tho is all this answers a guy even told you to use a function that has been deprecated in 2013 and removed from php in 2015 another gives half commands that probably dont even know what it does.

 

:yuno:Access denied for user 'root'@'localhost' 

Edited by iTopZ
  • 0
Posted (edited)
9 minutes ago, Irrelevant said:

sql port is open ?

yes it is, wait can sql port be closed?

yes its open 3306 is port, i just checked ..

Edited by Equi93
  • 0
Posted
4 hours ago, Irrelevant said:

make sure the table in your navicat are named exactly the same.
go to https://phpcodechecker.com/ and check the code if is that correct

I have stupid question cus idk, if code is correct navicat shouldn't make table automatically? If not and if you have time can you write me table parameters?

  • 0
Posted (edited)

first of all you need allow connect IP from website -> machine and after make a user and pass for this and check website what php rev use maybe can't read mysqli_connect() and need mysql_connect()

Edited by tazerman2
Guest
This topic is now closed to further replies.


  • Posts

    • I already finished my panel for change name and gender, anyway need restart, im used schema  $stmt = $conn->prepare("EXEC lin_ChangeCharacterName2 ?, ?, ?"); for change name... also for change gender i used if ($race == 5) // Kamael race ID; modify this value as per your database { $error = "Gender change is not allowed for Kamael race characters."; } else { $stmt = $conn->prepare(" UPDATE user_data SET gender = ?, face_index = 0, hair_shape_index = 0, hair_color_index = 0 WHERE char_id = ? AND account_name = ? "); Sorry no idea how to add cached update in myext64 about, not have any  solution for this yet compatible to myext64 code. This is my panel make in php http://177.73.143.43:8080/account/ Cool panel for me, without experience in any code. Without help from any people here 🙄
    • Don't listen to that idiot @Nightw0lf — he doesn't know or understand anything... he just talks nonsense. Here's the solution, just to prove that they're the useless ones giving you meaningless and useless answers.   function disableCharacter($charId){ $buf = pack("cVV", 0x14, $charId, 1); return $this->Send($buf); } function enableCharacter($charId, $accountId){ $buf = pack("cVV", 0x15, $charId, $accountId); return $this->Send($buf); } function kickCharacter($charId) { $buf = pack("cV", 0x05, $charId); $tmp = $this->Send($buf); sleep(2); return $tmp; } //-------------------------------------------------------------------------------- if ($func==7)//DESHABILITAR PERSONAJE { $char_id = $var1; $CACHED->kickCharacter($char_id); $respuesta = $CACHED->disableCharacter($char_id); RegistrarActividad("disableCharacter",$respuesta,GetCharNameByCharId($char_id)."(".$char_id.")",0,0,0,0); } else if ($func==8)//HABILITAR PERSONAJE { $char_id = $var1; $account_id = $var2; $CACHED->kickCharacter($char_id); $respuesta = $CACHED->enableCharacter($char_id,$account_id); RegistrarActividad("enableCharacter",$respuesta,GetCharNameByCharId($char_id)."(".$char_id.")",$account_id,0,0,0); } //-------------------------------------------------------------------------------- $CACHED->disableCharacter($char_id); $tabla = sqlsrv_query($conexion_lin2world, "UPDATE user_data SET xxxxxxxxxxxx WHERE char_id=".$char_id.""); $CACHED->enableCharacter($char_id,$account_id); Now just compare the stupidity said by that imbecile @Nightw0lf with the answer I gave you... Thanks to people like this, MaxCheaters is in the state it's in... They keep following useless people who are good for nothing 😉  
    • A new template is available: Mystical-World - Responsive HTML Template    
    • very helpful comment when you say to some random person that is asking for help this: "I hope that the imbeciles that you defend better answer you" indicates you have serious psychological issues, you are a problem for the community at this point  read the rules and stop spreading the toxicity virus you are infected with, seek professional help.     on topic, l2off servers have the issue of real time name changing through website and CacheD server, in some of them even successfully return no errors but its still not working, the player has to restart the game afterwards so in best case you log them out, thats all i can tell you from the website side development. i suggest this to be inside try/catch dont use advext the guy gives errors in the documentation of the website connections and calls other developers idiots who cant make it i have rewrote this function fully (this function contains the errors)  https://wiki.depmax64.com/index.php/Список_php-функций_для_работы_с_пакетами_IL and still i made everything work except the rename, this can be done with other methods and SQL side using function queries
    • Buying & Selling Torn City Cash
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock