[Help] please, Navicat problem.1130

[HouLiGaN]

When i go to Navicat and try to open my localhost it wont let me and instead opens a pop up saying:

1130-Host`localhost`is not allowed to connect to this MySQL server.

 

this problem i have had it for a long time i posted it in the greek foroum a few months ago with no exact awnser.

i have uninstaled and reinstalled navicat and mysql and still it wont let me.

 

 

What should i do?

What have i done?

OMG! :P

 

Thank you for your time!

[HouLiGaN]

Ive googled it i think theres no way out of this 1 i have to format my pc!!!!!!!!!!!!!!!!1

:p

If any 1 knows how i can add a user on to my navicat withoyght having 1 already that will be a nice help.

Thanks!

[RandomDude]

you haave same password to mysql and navicat?? (i dont know if that works, because i havent seen this error before)

 

...I dont know how to add new connections when you cant enter the localhost, sry.

[FighterBoss]

You should put the password at your connection and then try again.

[xuinia]

It is remote server that you're trying to connect or it is in your computer?

If it is remote, then you need to configure it to allow acces from outside localhost. If it is in your computer, then I gues you're just using wrong password for mysql.

[HouLiGaN]

Nothing works... :(

If any one has got any other ideas ill try them.

If not, on tuesday ill give it a format. xexe

 

Thanks RandomDude & FighterBoss for replying.

[HouLiGaN]

It is remote server that you're trying to connect or it is in your computer?

If it is remote, then you need to configure it to allow acces from outside localhost. If it is in your computer, then I gues you're just using wrong password for mysql.

xuinia

Its on my pc...

The problem is that i accidently deleted my user on navicat. Now i cannot connect to any server that i make on my pc.

I need to make a new user on navicat but when i press Manage users nothing happens.

thanks for reply...

 

Sorry For Spam Mods, Please forgive me .

[Tryskell]

Connect using root access ?

 

Basically, when you are with root, create an user with all rights, put a password for root and that's all... If you deleted user, you still got root.

 

You normally can't delete root.

 

If you deleted user and have no access to root, try to search where rights accesses are stored... Reinstalling won't help, format will but ti's perhaps "too much" and not needed...

[xuinia]

You can only manage users when you're connected to that server. If you deleted the user that you are trying to use, then thats what happens. If you are using other then root user, then try root with whatever password you ussed. Default password is blank (no password) If that doesnt help, just uninstal mysql, delete all remaining mysql files and reinstall it again. This should create new root user.

 

xuinia

Its on my pc...

The problem is that i accidently deleted my user on navicat. Now i cannot connect to any server that i make on my pc.

I need to make a new user on navicat but when i press Manage users nothing happens.

thanks for reply...

 

Sorry For Spam Mods, Please forgive me .

[HouLiGaN]

If you deleted user and have no access to root, try to search where rights accesses are stored... Reinstalling won't help, format will but ti's perhaps "too much" and not needed...

 

Can any 1 tell me how i do this part?

[HouLiGaN]

Bump....Please someone tell me the above

[xuinia]

Bump....Please someone tell me the above

Did you reinstal mysql ? If not - go and doit. Unistal it, delete mysql folder, restart pc and make an new clean install. During install it will ask you to create root acc.

[HouLiGaN]

Did you reinstal mysql ? If not - go and doit. Unistal it, delete mysql folder, restart pc and make an new clean install. During install it will ask you to create root acc.

 

ok i will try this now i hope it works , this stuff has owend me the past few months i wanna start my server again  but more professionalyyyyyyyyyyy aaaaaaaaaaaaaaaa :)

[HouLiGaN]

When i go to make the root it wont let me says the same problem, 1130 wont alow it.

I uninstalled everything 100% and reinstalled everything 100% and same problem...

 

 

How do i find the "where rights accesses are stored" like tryskell said!

[xuinia]

When i go to make the root it wont let me says the same problem, 1130 wont alow it.

I uninstalled everything 100% and reinstalled everything 100% and same problem...

 

 

How do i find the "where rights accesses are stored" like tryskell said!

How do you install mysql? If you're using windows, then download wamp. It has apache+php+mysql intergrated. That should create a new root user with no password. Try that, if it doesnt help, you're doing something wrong.

[HouLiGaN]

How do you install mysql? If you're using windows, then download wamp. It has apache+php+mysql intergrated. That should create a new root user with no password. Try that, if it doesnt help, you're doing something wrong.

1) i will try it

2) Thank you very much  for staying with me on my problem man ;) !