| View previous topic :: View next topic |
| Author |
Message |
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
 Posted: Fri Jun 23, 2006 1:45 pm Post subject: locked myself |
 |
|
| out of phpmyadmin pressed one of the buttons on it and now it says localhost is not allowed to connect to the server anybody no a way to get back in ? |
|
| Back to top |
    |
 |
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Fri Jun 23, 2006 4:09 pm Post subject: |
|
|
| actually ive locked localhost out of mysql server cant reinstall it or anything |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Jun 24, 2006 2:18 pm Post subject: |
|
|
Download MySQLAdmin (google for it).
After you install it, go to "User Administration", find "root" or your main user, right click it and click "Add host from which this user can connect". Now enter "localhost" (without the quotes) and click OK. phpMyAdmin should now be able to connect again.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
 |
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Sat Jun 24, 2006 11:24 pm Post subject: |
|
|
| the my sql administrator m8 ? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Jun 24, 2006 11:26 pm Post subject: |
|
|
No, Microsoft Word... Use your common sense! Yes I mean MySQL Administrator.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Sat Jun 24, 2006 11:30 pm Post subject: |
|
|
| lol sorry m8 i found somethin called mysqladmin aswell so thoughtt it mite be that |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sat Jun 24, 2006 11:31 pm Post subject: |
|
|
Its probably the same program.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Sat Jun 24, 2006 11:47 pm Post subject: |
|
|
the users account part isnt there
it goes
servicecontrol
startup variables
server logs
then theres nothin afta that :? |
|
| Back to top |
|
|
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Sun Jun 25, 2006 12:43 am Post subject: Re: locked myself |
|
|
| hoppy wrote: | | out of phpmyadmin pressed one of the buttons on it and now it says localhost is not allowed to connect to the server anybody no a way to get back in ? |
Can you actually paste what it says?
If you did it by "pressing a button" then you most likely deleted the root user.
If that's the case you can easily re-add it, or you could uninstall, delete the data directory too, and reinstall.
_________________
 |
|
| Back to top |
   |
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Sun Jun 25, 2006 1:08 pm Post subject: |
|
|
| Code: | MySQL said:
#1130 - Host '127.0.0.1' is not allowed to connect to this MySQL server
|
thats what it says used to say localhost instead of 127.0.0.1 though |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Sun Jun 25, 2006 1:25 pm Post subject: |
|
|
You should see the following. If you didnt download the other program you saw.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Mon Jun 26, 2006 12:09 pm Post subject: |
|
|
| the program a downloadeds the same as that but theres only 3 things on al try downloadin again see if i can get it to show up rite |
|
| Back to top |
|
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Mon Jun 26, 2006 10:03 pm Post subject: |
|
|
| got that workin thanks alot mrinquistor your a star |
|
| Back to top |
|
|
hoppy
-
Joined: 12 Jun 2006
Posts: 22
Location: wigan
|
| Posted: Tue Jun 27, 2006 11:31 pm Post subject: |
|
|
sorry bout this but gettin this error now am pretty crap at this :(
| Code: |
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO) |
it says that when the passwords not wrote in the config.inc
but when it is it says
| Code: |
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
|
and am using version 5 so i guess it wont need upgrading |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Wed Jun 28, 2006 7:41 am Post subject: |
|
|
The MySQL version and the PHP version are not compatable. Change one of them. Its easier to change MySQL in most cases.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Wed Jun 28, 2006 12:16 pm Post subject: |
|
|
| hoppy wrote: | | Code: |
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
|
and am using version 5 so i guess it wont need upgrading |
Your PHP and MySQL versions are not compatible. We recommend in such a case using our PHP 5 preconfigured package which supports any MySQL version: http://www.aprelium.com/abyssws/php5win.html .
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
|
