| View previous topic :: View next topic |
| Author |
Message |
p3
-
Joined: 17 Jun 2005
Posts: 615
|
 Posted: Wed Aug 31, 2005 2:35 pm Post subject: MySQL Problems |
 |
|
OK, here's the problem.
I woke up this morning, and tried to go to my forums. PHPBB Critical Error - Can't conncet to Database.
So I head over to phpmyadmin, pop out my backups, and load in the backup for my forum, which, thankfully, is only 3 days old and there have been no new posts or anything.
So I upload it. Once it comes back that it has been sucessful, I go back to the phpmyadmin home page.
Seeing as my bad luck only gets worse, I get a
| Quote: | Error
MySQL said:
#1130 - Host 'localhost' is not allowed to connect to this MySQL server
|
The problem is I haven't changed anything...
I went to the config.inc file, and my hostname for the log-in is localhost...
Then, to make matters even worse and finish off my bad morning, I find that the database tables are in the MySQL folder, right there, and completly full.
And I still can't get to my forum because the database is named incorrectly. But I can't get into to phpmyadmin.
And ideas? |
|
| Back to top |
   |
 |
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Wed Aug 31, 2005 2:46 pm Post subject: |
|
|
Make sure mysql is running correctly its unlikely to be deleted or corrupt.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
 |
|
p3
-
Joined: 17 Jun 2005
Posts: 615
|
| Posted: Wed Aug 31, 2005 2:52 pm Post subject: |
|
|
| The Inquisitor wrote: | | Make sure mysql is running correctly its unlikely to be deleted or corrupt. |
Hmm... It looks as if it isn't anymore. What is the executable to start it? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Wed Aug 31, 2005 2:54 pm Post subject: |
|
|
c:/mysql/bin/winmysqladmin.exe
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
p3
-
Joined: 17 Jun 2005
Posts: 615
|
| Posted: Wed Aug 31, 2005 2:58 pm Post subject: |
|
|
| The Inquisitor wrote: | | c:/mysql/bin/winmysqladmin.exe |
Red light :(
Driver not found :( |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Wed Aug 31, 2005 2:59 pm Post subject: |
|
|
Reinstall MySQL without uninstalling it. You will NOT lose any database data. If else fails, restart the computer and try again.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
Tim1681
-
Joined: 17 Jan 2005
Posts: 160
Location: Bristol, CT, USA
|
| Posted: Wed Aug 31, 2005 3:18 pm Post subject: |
|
|
| The Inquisitor wrote: | | Reinstall MySQL without uninstalling it. You will NOT lose any database data. If else fails, restart the computer and try again. |
I Agree, this sorta happened to me once :D.
_________________
mysql> SELECT * FROM users WHERE clue > 0;
0 rows returned.
 |
|
| Back to top |
 |
|
p3
-
Joined: 17 Jun 2005
Posts: 615
|
| Posted: Thu Sep 01, 2005 1:02 am Post subject: |
|
|
Tried all that, and the stuff Andy reccomended on MSN.
I reinstaled it. Same problem.
It says it can't find the MyOBDC Driver (In the MySQL Admin it is in that textbox)
the box says:
| MyOBDC Textbox wrote: |
Not Found
Driver 3.51 Not Found
|
Any ideas? |
|
| Back to top |
|
|
Anonymoose
-
Joined: 09 Sep 2003
Posts: 2192
|
| Posted: Thu Sep 01, 2005 7:34 am Post subject: |
|
|
3 guesses what you'll find out if you search the forum for MySQL Driver - use "Search for all terms" if you haven't figured out how to effectively use a search function.
_________________
"Invent an idiot proof webserver and they'll invent a better idiot..." |
|
| Back to top |
|
|
p3
-
Joined: 17 Jun 2005
Posts: 615
|
| Posted: Thu Sep 01, 2005 2:23 pm Post subject: |
|
|
OK, so I don't need it.
But why does phpmyadmin produce the error "Server not Responsing"??? |
|
| Back to top |
|
|
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Thu Sep 01, 2005 2:33 pm Post subject: |
|
|
Because the server isnt responding perhaps... :P
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
|
|
p3
-
Joined: 17 Jun 2005
Posts: 615
|
| Posted: Thu Sep 01, 2005 2:43 pm Post subject: |
|
|
| The Inquisitor wrote: | | Because the server isnt responding perhaps... :P |
Ya Don't Say......
I meant HOW CAN I FIX IT!!!!!!!!!!
:D |
|
| Back to top |
|
|
|
