Welcome to MaxCheaters.com

Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads

  • 0

Help Give me help pls!


Go to solution Solved by iTopZ,

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

Share this post


Link to post
Share on other sites

9 answers to this question

Recommended Posts

  • 0
  • Solution
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

Share this post


Link to post
Share on other sites
  • 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

Share this post


Link to post
Share on other sites
  • 0
13 hours ago, Equi93 said:

yes it is, wait can sql port be closed?

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

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

Share this post


Link to post
Share on other sites
  • 0
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?

Share this post


Link to post
Share on other sites
  • 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

Share this post


Link to post
Share on other sites
  • 0

Who is a owner of this table, what the privileges of owner and who owner of this PHP script file? In all cases you will get this error.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.