| View previous topic :: View next topic |
| Author |
Message |
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
 Posted: Sat Dec 10, 2005 4:49 pm Post subject: phpMyAdmin error |
 |
|
I was following a guide and had to delete all users in the phpMyAdmin privileges section, but as soon as I did that I lost access to the phpMyAdmin function and now everytime when I try to access it I get this warning:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Also telling me:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Does anybody know how to fix this?
EDIT: Also I have a question, how do I know what my Database name is? |
|
| Back to top |
  |
 |
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 5:08 pm Post subject: |
|
|
As far as I know, you can't delete the root user. (Only a guess, I've never tried to be honest.) You can change the root password from the command line however, and likely add a new user from the command line too, by appending a query with the correct switch.
Secondly, if your server rejected the connection, the connection to the server apparantly failed or the server isn't active. (Obviously, really.)
Thirdly, as root in phpmyadmin, you can see all databases. (And their names, obviously.) If you mean you have a database on someone elses server and have forgotten the name, then you'll just have to remember or ask the owner.
_________________
 |
|
| Back to top |
    |
|
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
| Posted: Sat Dec 10, 2005 5:52 pm Post subject: |
|
|
I have reinstalled everything and it seems to work now, I gave the root user a password and now I lost access again, I just get the same warning :(
Well I got the site working but how can I change it so that outsiders can see it too. Currently nobody but me can access the site.
And could you also help me with the password problem? |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 6:49 pm Post subject: |
|
|
| Mark538 wrote: | I have reinstalled everything and it seems to work now, I gave the root user a password and now I lost access again, I just get the same warning :(
Well I got the site working but how can I change it so that outsiders can see it too. Currently nobody but me can access the site.
And could you also help me with the password problem? |
Oh, you mean ONLY phpmyadmin tells you that you have the wrong password?
I'm assuming that you're using the built in authorization method for phpmyadmin. (I.E. hardcoded into config.inc.php.) Have you updated the password in config.inc.php to reflect too?
As for phpmyadmin security, simply protect the phpmyadmin directory with a password or address control, and/or change the authorization method in config.inc.php to cookie, so people must know the root username & password to access it.
_________________
|
|
| Back to top |
|
|
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
| Posted: Sat Dec 10, 2005 7:11 pm Post subject: |
|
|
| I sorted the problem, changed it from config to http based. But how do I give outsiders access to my site with the Abyss Web Server tool? |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 7:17 pm Post subject: |
|
|
| Mark538 wrote: | | I sorted the problem, changed it from config to http based. But how do I give outsiders access to my site with the Abyss Web Server tool? |
What do you mean by "the Abyss Web Server tool"? The server?
Assuming so, you mean how do you let outsiders access phpmyadmin? Mysql? Something else?
Sorry, I may well be missing the obvious.
_________________
|
|
| Back to top |
|
|
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
| Posted: Sat Dec 10, 2005 7:48 pm Post subject: |
|
|
Well I have a site but when others try to access that site they get a The site could not be found error.
http://127.0.0.1/viewnews.php?s=
That's the site in my browser, but others cant access it. |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 7:52 pm Post subject: |
|
|
| Mark538 wrote: | Well I have a site but when others try to access that site they get a The site could not be found error.
http://127.0.0.1/viewnews.php?s=
That's the site in my browser, but others cant access it. |
Ah, 127.0.0.1 is a "special" address. 127.0.0.1 will most likely return the visitors computer. 127.0.0.1 for me would be my computer.
Goto whatismyip.com or something to find out your actual IP for the outside world.
_________________
|
|
| Back to top |
|
|
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
| Posted: Sat Dec 10, 2005 7:56 pm Post subject: |
|
|
| What do I do with that IP adress then? I'm rather confused, all I need to know is how others can visit the site =/ |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 8:11 pm Post subject: |
|
|
| Mark538 wrote: | | What do I do with that IP adress then? I'm rather confused, all I need to know is how others can visit the site =/ |
Instead of giving them 127.0.0.1, give them that address.
This may or may not work for you on the computer you are using, it depends on your setup.
_________________
|
|
| Back to top |
|
|
Mark538
-
Joined: 10 Dec 2005
Posts: 6
|
| Posted: Sat Dec 10, 2005 8:26 pm Post subject: |
|
|
| Still doesnt work. |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sat Dec 10, 2005 8:34 pm Post subject: |
|
|
| Mark538 wrote: | | Still doesnt work. |
Read the FAQ, there are a million explanations of why this could be.
_________________
|
|
| Back to top |
|
|
|
