Locked out of my databases

[Khaennn]

I just compiled the most recent TrinityCore, and I was trying to apply the updates.

I thought, "hey, maybe I could make this SQL session a default session," to make the updates go by faster.

I somehow banned localhost from MySQL, getting the error # 1130, and I cannot log into my databases.

What can I do to fix this? When I searched for Google, it gave me a command to use in the cmd window, however it does not work, as I need to be in the database to flush it =/

I was using HeidiSQL at the time.

[Khaennn]

Any ideas?

[Zymus]

Question: Why were you using an administrator user when doing this?

[Khaennn]

I thought I had to be on an admin to make the servers session permanent.

[covert_cat]

/facepalm.

Well, did it only ban localhost? Could you access it from another computer?

Also, Navicat.

[Khaennn]

I do not have access to another computer, and yes, I think it only banned localhost.


edit: but say I did have access, what would I do?

[Zymus]

mysql -u username -p
<enter password>
create user 'username'@'localhost' identified by 'password';
use databaseName;
grant all on * to 'username'@'localhost';

Makes a user with all privileges on a specific database. Then you can use Navicat(as suggestd earlier) or if you have open office, you can use open office base.

[Khaennn]

I tried the commands you suggested, however it still says localhost is not allowed to connect to this MySQL server.

Unless I'm doing it wrong?

[stoneharry]

/facepalm.

Well, did it only ban localhost? Could you access it from another computer?

Also, Navicat.

Why are you recomending Navicat? Although I have no experience with HediSQL, SQLyog (community edition is free before you say it's paid only) is a far better option and far more good in general than Navicat.

On topic, I have no idea on how to solve it, other than reinstall your SQLserver. Looks like you royally screwed up.

[Zymus]

Why are you recomending Navicat? Although I have no experience with HediSQL, SQLyog (community edition is free before you say it's paid only) is a far better option and far more good in general than Navicat.

On topic, I have no idea on how to solve it, other than reinstall your SQLserver. Looks like you royally screwed up.

I'd have to agree.

[Khaennn]

I'm pretty sure I royally screwed up too. =/

I can run the MySQL server from my laptop, but it is very laggy.

[covert_cat]

Perhaps Navicat isn't as good on windows, but on my mac it's very good.