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

    • You always find a way to lower the bar. Consistency matters. I admire your dedication to being completely unaware of how little you matter.     at least you are not entirely useless you can always serve as a bad example
    • hahahahahahahahahahahaha this says more about MaxCheaters than about me xD
    • 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 🙄
    • Базы данных от прямых источников!                                  Холодка                 Реги                 Депы                 Богатые физики                                  Много актуальных гео!                 Замена брака!                 Гарант+                                  Контакты                 ТГ - @yashkatsigun    
    • 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 😉  
  • 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