Jump to content
The Best Lineage 2 Mods – Free & Custom
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

[Help] please, Navicat problem.1130

HouLiGaN

Asked by HouLiGaN,

 Share

Question

HouLiGaN Newbie

HouLiGaN

Posted
Posted

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!

19 answers to this question

Recommended Posts

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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!

  • 0
RandomDude Newbie

RandomDude

Posted
Posted

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.

  • 0
xuinia Newbie

xuinia

Posted
Posted

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.

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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.

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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 .

  • 0
Tryskell Rising Star

Tryskell

Posted
Posted

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...

  • 0
xuinia Newbie

xuinia

Posted
Posted

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 .

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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?

  • 0
xuinia Newbie

xuinia

Posted
Posted

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.

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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 :)

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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!

  • 0
xuinia Newbie

xuinia

Posted
Posted

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.

  • 0
HouLiGaN Newbie

HouLiGaN

Posted
  • Author
Posted

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 ;) !

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • Alex K.
      Need OOG bot that works with L2J Interlude

      By Alex K. · Posted

      Both are in-game bots. I'm looking for an out-of-game bot ((one that doesn’t require the L2 client).     Hmm, never heard about this bot. Will check, thank you
    • SkyLord
      [L2OFF] L2Mid.com (x25 Dynamic Rates)

      By SkyLord · Posted

      🎉 L2Mid is back! After a 3-year pause, we’re launching a new Interlude server based on the original Interlude client (old school 😉).   What to expect • The classic Interlude spirit • Old friends, rival clans, and returning legends • A season focused on pure nostalgia   This may be our final Interlude server. (maybe 😉) 🗓️ Opening: December 5, 2025 at 20:00 (GMT+2)   https://l2mid.com
    • Nury Mykael
      Armor Glow on Hi5

      By Nury Mykael · Posted

      Hello, i was wondering if there's a guide on how to add the enchanting armor glow system from  Ertheia or Lindvior to hi5?
    • visa2014
      Regarding the issue of importing UKX files into Unreal Engin

      By visa2014 · Posted

      I imported this file using Unreal Engine 2 Runtime, modified it, saved it back, and then placed it on the client. When I run the game and wear this back accessory, the client crashes!     2025.10.28 03:52:59 OS : Windows XP 5.1 (Build: 2600) CPU : GenuineIntel  Intel(R) Core(TM) i3-6100 CPU @ 3.70GHz @ 3697 MHz 1023MB RAM Video : NVIDIA GeForce GT 730 (3064) PosCode : TS4(273) -119:-62:-1474 4/1 [0] SkeletalMesh MFighter_Fuckl2jangel.MFighter_Fuckl2jangel: Serial size mismatch: Got 383399, Expected 383403 History: LoadObject <- (SkeletalMesh MFighter_Fuckl2jangel.MFighter_Fuckl2jangel 8376427==8376427/8376498 7993028 383403) <- ULinkerLoad::Preload <- PreLoadObjects <- UObject::EndLoad <- UObject::StaticLoadObject <- (Engine.Mesh MFighter_Fuckl2jangel.MFighter_Fuckl2jangel NULL) <- UMeshComponent::LoadMeshComponent <- UMeshContainer::UpdateMeshComponents <- APawn::UpdateMeshComponents <- User::UpdatePawnMeshContainerByItem <- User::UpdatePawnMeshContainer <- User::SetPawnResource <- NCPawnView_InvenItemWnd::OnRButtonDown <- NCVirtualWndMain::SetFocusingWindow <- NCVirtualWndMain::DispatchWndMsg <- NConsoleWnd::DispatchWndMsg <- NConsoleWnd::MasterConsoleEventProcess <- UEngine::InputEvent <- UWindowsViewport::CauseInputEvent <- UWindowsViewport::UpdateInput <- UViewport::ReadInput <- APlayerController::Tick <- ALineagePlayerController::Tick <- TickAllActors <- ULevel::Tick <- (NetMode=0) <- UMasterLevel::Tick <- TickLevel <- UGameEngine::Tick <- UpdateWorld <- MainLoop   I don't know what the reason is. Can you help me?
    • KejbL
      Over the head icons for olympiad

      By KejbL · Posted

      @BALENCIAGA

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock