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

    • in conclusion when somebody who has a project for 10+ years still on development writes an e-say to try until you succeed and then advertises his project, one of the reasons is he needs money, so l2j has once more become pure expensive hobby, you wont make money out of it.   You can still use L2jFrozen and get better results for this, i know some people that done it    keep in mind that C in aCis stands for Crappy, and after all these years its not a cool wordplay anymore, its a fact, prove me wrong.
    • First, don't really follow the "main voice", moreover if you consider it an hobby. Simply do what you want, you got only one life so use it as you want. If you make it an hobby, it's exactly like piano, or velo - only practice makes you better.   Secondly, how do you learn things ? It's actually a really important question, since some can simply be scholar, read books (theory) then practice ; and some simply can't read books. I'm the second type, I hated school, I find it boring - my knowledge in Java comes from try-and-fail. You improve your coding style every year or so, I can myself rewrite my own code (which I already considered top-notched) after a while. You always learn something new - even if Java barely evolves. L2J is a fun way to learn programming, it's a giant sandbox where you can edit anything, and I believe it should be taken as it.   My own way of learning was as follow : Add existing customs, no matter what they are : the point is to know main classes used by L2J / customs. L2J is barely Java knowledge ; the true knowledge is to know WHAT to search in WHICH location (what I call, organization). You have to understand than EVERYTHING you think already exists, in a form on another, in the source code. A custom is only the association of the different mechanisms you found "here and there", glued together in a proper goal. Once you know main classes to edit, and the customs you added are compiling fine, the main point is to know WHAT exactly you DID. Try to understand WHY and WHERE you actually copied the code. Third point would be to MANIPULATE the customs you added in order to fit your wish. First edit little values, then logic conditions ; eventually add a new Config, or a new functionality to the custom. Fourth point would be to begin to craft your own ideas. Once again, EVERYTHING already exists, in a form or another. You want a cycled event ? You got Seven Signs main task as exemple. Npc ? Search any type of Npc and figure out what it does. Fifth point would be to understand Java - mostly containers (WHAT and WHERE to use them), variables types and main Java mechanisms (inheritance, static modifier, etc). You should also begin to cut your code into maintainable classes or methods. Java can actually run without optimization, but bigger your ideas, more optimized and well-thought it should be. It's direct saved time in the future, and you would thank yourself doing so. Main tips : ALWAYS use any type of versioning system - GIT or SVN. It allows to save your work, step by step and eventually revert back anytime you want if you terribly messed up. L2J is 80% organization knowledge, and 20% Java knowledge. Basically, if you know WHAT and WHERE to search, if you aren't dumb, it's easy to replicate and re-use things. Cherry on top is to use a already good coded pack to avoid copy-paste crap and get bad habits. Avoid any type of russian or brazilian packs, for exemple - their best ability is to leak someone's else code. Obviously you need some default sense of logic, but Java and programming in general help you to improve it.   Finally, most of your questions could be solved joining related Discord (at least for aCis, I can't speak for others) - from the moment your question was correctly asked (and you seemed to search for the answer). My community (and myself) welcomes newbies, but got some issues with noobies.   The simpliest is to try, fail and repeat until you succeed - it sounds stupid, but that's basically how life works.   PS : about Java ressources, before ChatGPT, it was mostly about stackoverflow website, and site like Baeldung's one. With ChatGPT and alike, you generally double-cross AI output to avoid fucked up answers. Also, care about AI, they are often hallucinating really hard, even today. They can give you complete wrong answer, you tell them they are wrong, and they say "indeed, I suck, sorry - here's a new fucked up answer". You shouldn't 100% rely over AI answer, even if that can give sometimes legit answers, full code or just skeletons of ideas.   PPS : I don't think there are reliable ressources regarding L2J itself, also most of the proposed code decays pretty fast if the source code is actually maintained (at least for aCis). Still, old coded customs for old aCis sources are actually a good beginner challenge to apply on latest source.
    • WTS: - AQ - Baium - Zaken  - Frintezza - Vesper Fighter Focus Fire Element   pm for detalis
  • 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