how to fix your mysql when it buges beyond no repair this covers all errors for mysql

[project anthrax]

hey this is project anthrax as you all know when you make a private server it looks like its going to be tons of fun. But in realty you just get a ton of work now im going to show you how to make it easer on your self. With the NOTORIOUS error # cannot connect to local host using password yes/no.
FIRST MAKE SURE YOU BACK UP YOUR DB's GO TO WHERE YOUR MYSQL FOLDER IS LOCATED OPEN IT GO TO THE DATA FOLDER AND COPY UR DB"S TO UR DESK TOP AFTER YOU COMPLETE THE LAST STEP MAKE A DB WITH THE SAME NAME AS THE OLD ONE AND TAKE YOU TABLES OUT OF UR BACK UP DB FOLDER GO INTO THE MYSQL DATA FOLDER AND OPEN THE FOLDER OF YOUR DB NAME AND COPY PAST ALL THE TABLES FOR IT IN THERE
Steps#
1. go to START then RUN then type cmd
2. now a window should pop up type in ipconfig
3. then you should get a bunch of addresses go to the one that looks some thing like 192.168........then w/e after it
4. now open up what ever internet browser you have and put that in the default search at the top now yuor router page should come up
5. username and password is usualy
admin and the password is password some times not. Some possible user name pw combos
Admin Admin or
Admin password
6. now that you have it opened go to firewall settings at the top click it. Now this should come up
General
Maximum Security(High)
Inbound Policy: Reject.
Remote Administration settings will override the security inbound policy.
Outbound Policy: Reject.
Outbound access is allowed to the following services: Telnet, FTP, HTTP, HTTPS, DNS, IMAP, POP3 and SMTP.
Typical Security(Medium)
Inbound Policy: Reject.
Remote Administration settings will override the security inbound policy.
Outbound Policy: Accept.
Minimum Security (Low)
Inbound Policy: Accept.
Outbound Policy: Accept.
Block IP Fragments Set it on minimum security and then press apply now let it load.
7. Now go to CCleaner CCleaner - Home and download it
8. once that is done completely remove mysql and all thing being used by it navicat or hemisql or sqlyog
9. now open up ccleaner and go to Regestry Tab on it and then scan for issues then when its done click fix selected issues. Then do it one or two times if there any thing left in it.
10. Congratulations its fixed
11. redownload all your mysqls again XD but dont use the same account make* a new user.
12. Thank you this was made by project anthrax please dont copy this!

[Ballwinkle]

erm, theres prolly a better and safer way to do this. it gets technical.

[project anthrax]

nope my ways the best lol

[2dgreengiant]

Found this in my whydb folder:

/* This sql is very handy if your mysql server has been crashed and some tables are 'corrupt/damaged' */
REPAIR TABLE account_data;
REPAIR TABLE account_forced_permissions;
REPAIR TABLE account_overrides;
REPAIR TABLE accounts;
REPAIR TABLE arenateams;
REPAIR TABLE auctions;
REPAIR TABLE banned_names;
REPAIR TABLE banned_phrases;
REPAIR TABLE characters;
REPAIR TABLE characters_insert_queue;
REPAIR TABLE charters;
REPAIR TABLE corpses;
REPAIR TABLE gm_tickets;
REPAIR TABLE groups;
REPAIR TABLE guild_bankitems;
REPAIR TABLE guild_banklogs;
REPAIR TABLE guild_banktabs;
REPAIR TABLE guild_checkpoints;
REPAIR TABLE guild_data;
REPAIR TABLE guild_logs;
REPAIR TABLE guild_ranks;
REPAIR TABLE guilds;
REPAIR TABLE instances;
REPAIR TABLE ipbans;
REPAIR TABLE mailbox;
REPAIR TABLE mailbox_insert_queue;
REPAIR TABLE playerpets;
REPAIR TABLE playerpetspells;
REPAIR TABLE playersummonspells;
REPAIR TABLE professiondiscoveries;
REPAIR TABLE questlog;
REPAIR TABLE server_settings;
REPAIR TABLE social_friends;
REPAIR TABLE social_ignores;
REPAIR TABLE tutorials;

[project anthrax]

which folder/file did you see that in? if it was in the data folder go into you db folder name is the same as ur db and take the tables out of there

[snowbird]

Dude this was a repost of mine which was alot better more discrptive with programs and all of that

and also thats not how you fix it. thats a port problem which is very easy 2 fix and im like 13

[project anthrax]

dude I posted this like 8 months ago you noob before you got here. And yes this is how to fix it. This has worked for many people including my self and I wouldnt take your word for it. And why would you say it was yours if you think it doesnt work you dont know who your messing with =] have a nice day

I reposted my old guide becuase it was outdated

[Jackie Moon]

nice guide, lol snowbird you fail. Shutdown much?!?! lol