Jump to content

Question

Posted

Καλησπερα, εχει μερικες μερες προσπαθω να χτισω τον δικο μου σερβερ αλλα ολα πανε στραβα απο την αρχη. Οταν τρεχω την mySQL και φτανω στο τελικο σημειο που κανει Execute, το τελευταιο κουτακι (Apply Security settings) μου βγαζει το παρακατω σφαλμα.

 

 

"The security settings culd not be applied to the database because the connection has failed with the following error.

 

Error Nr.1045

Access denied for user 'root'@'localhost' (using password: NO)

 

If a personal firewall is running on your machine, please make sure you have opened the TCP port3306 for connections. Otherwise no client application can connect to the server, After you have opened the port please press [Retry] to apply the security settings.

 

If you are re-installin after you just uninstalle the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu."

 

*μου βγαζει απο κατω δυο button "Retry" και "Skip"

 

Αν εχει καποιος γνωση τι πρεπει να κανω.. Ευχαριστω πολυ .

13 answers to this question

Recommended Posts

  • 0
Posted
10 hours ago, Nightw0lf said:

simenei oti exeis idi kapio service installed me onoma mysql pou trexei idi

uninstall mysql kai perna ksana

Το έχω τσεκαρει πολλές φορές, το μόνο που έχει είναι κάτι microsoft cisual c++ (κάπου 5 6 τέτοια προγράμματα)

  • 0
Posted
6 hours ago, panospaok said:

Το έχω τσεκαρει πολλές φορές, το μόνο που έχει είναι κάτι microsoft cisual c++ (κάπου 5 6 τέτοια προγράμματα)

κανε unistall oti mysql εχεις μετα πηγαινε  C:\  πατα στη προβολη και μετα λεπτομέρειες και  τσεκαρε τα κρυφα αρχεια . Μπες στο programdata  Σβησε το φακελο mysql (C:\ProgramData) και ξανα περασε το κανονικα και θα παιξει τεσταρισμενο χρονια τωρα.  spacer.png

  • 0
Posted
18 hours ago, xRelic said:

κανε unistall oti mysql εχεις μετα πηγαινε  C:\  πατα στη προβολη και μετα λεπτομέρειες και  τσεκαρε τα κρυφα αρχεια . Μπες στο programdata  Σβησε το φακελο mysql (C:\ProgramData) και ξανα περασε το κανονικα και θα παιξει τεσταρισμενο χρονια τωρα.  spacer.png

Φίλε μου σίγουρα έχω διαγράψει μέσα από τα αρχεία τους φακέλους που λες το έχω τεσταρει πολλές φορές, όταν κάνω ινσταλ φαίνεται ότι είναι καθαρό όλα. Στα προγράμματα έχει και κάτι microsoft visual C++ μπορεί να υπάρχει θέμα με αυτά;

  • 0
Posted

oxi sou eipa kane apegkatastasi

an exei minei akoma kapio service akoloutha auto

https://www.lifewire.com/deleting-service-in-windows-7-vista-and-xp-153356

kai aporw giati akous kapion pou irthe na kanei diafimisi kai sou leei na sviseis arxeia pou einai lathos se auti ti periptwsi

  • 0
Posted

Open your windows cmd with administrator rights than,

You must run the command "sc delete MySQL" where "MySQL" is the name of the service

 

than try again to install your mysql setup.

  • 0
Posted
4 hours ago, panospaok said:

 

Αν θες στειλε μου discord να μπω να το δω,.

 

On 1/19/2023 at 4:59 PM, Nightw0lf said:

oxi sou eipa kane apegkatastasi

an exei minei akoma kapio service akoloutha auto

https://www.lifewire.com/deleting-service-in-windows-7-vista-and-xp-153356

kai aporw giati akous kapion pou irthe na kanei diafimisi kai sou leei na sviseis arxeia pou einai lathos se auti ti periptwsi

Αν κατάλαβα σωστα τι εννοεί το εχω παθει στο παρελθον και εγω φιλε μου , δεν ειχα λογο να κανω κατι τετοιο γιατι δεν παρεχω Hosts. απλα το εχω επιφανεια εργασίας , να σαι καλα ομως γιατι εχουμε ξανα μιλησει και ξερω τι παιδι εισαι 😉

  • 0
Posted
1 hour ago, xRelic said:

Αν θες στειλε μου discord να μπω να το δω,.

 

Αν κατάλαβα σωστα τι εννοεί το εχω παθει στο παρελθον και εγω φιλε μου , δεν ειχα λογο να κανω κατι τετοιο γιατι δεν παρεχω Hosts. απλα το εχω επιφανεια εργασίας , να σαι καλα ομως γιατι εχουμε ξανα μιλησει και ξερω τι παιδι εισαι 😉

den to lew gia sena prwsopika oti akouei kapion pou tou leei na svisei arxeia alla i diafimisi itan poliiiiiiiiiiiii ekei pou tha prepe hahahahahahaha, kserw to provlima tou einai sto service an svisei to service i to stamatisei tote tha luthei alla den fenete na antapokrinete se auta pou tou lew egw an deis

san na min iparxw ena pragma

 

:kappa:

to korifeo einai pou petagete o allos kai tou leei akrivws auto pou tou lew sta aglika san na min iparxw

  • Haha 1
  • 0
Posted
6 hours ago, Nightw0lf said:

den to lew gia sena prwsopika oti akouei kapion pou tou leei na svisei arxeia alla i diafimisi itan poliiiiiiiiiiiii ekei pou tha prepe hahahahahahaha, kserw to provlima tou einai sto service an svisei to service i to stamatisei tote tha luthei alla den fenete na antapokrinete se auta pou tou lew egw an deis

san na min iparxw ena pragma

 

:kappa:

to korifeo einai pou petagete o allos kai tou leei akrivws auto pou tou lew sta aglika san na min iparxw

Φίλε μου έκανα αυτό που είπες, με το λινό που εστειλες εξακολουθεί το ίδιο, θα κάνω μερικές προσπάθειες και σήμερα θέλω να πιστεύω να στρώσει 

  • 0
Posted
4 hours ago, panospaok said:

Φίλε μου έκανα αυτό που είπες, με το λινό που εστειλες εξακολουθεί το ίδιο, θα κάνω μερικές προσπάθειες και σήμερα θέλω να πιστεύω να στρώσει 

Στειλε μου ενα ετοιμα discord να μιλησουμε να μπω να το δω με AnyDesk.

  • 0
Posted

Είχες ξανά εγκαταστήσει mysql στο παρελθόν ή είναι η πρώτη φορά και σου βγάζει αυτό το error?

Δοκίμασε MariaDB, και πες μας αν σου κολλάει ξανά στο ίδιο κομμάτι.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Verify if following is supposed to be the way to handle movement npc.getAI().setIntention(CtrlIntention.AI_INTENTION_MOVE_TO, new Location(point.getX(), point.getY(), point.getZ())); For me, it's not enough. And if it's the case, whole AI system is probably buggy.
    • hello, i want to wtt my charracter in l2elmorelab 1x harbor for 1.5kkk adena in l2reborn 10x new. Or if you interested tell me your offer. :)) Clean Mail 30 lvl Cleric Naked   Updated.
    • package ai.npc.NFWalker; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Random; import l2r.gameserver.enums.CtrlIntention; import l2r.gameserver.model.Location; import l2r.gameserver.model.actor.L2Npc; import l2r.gameserver.model.quest.Quest; import l2r.gameserver.network.clientpackets.Say2; import l2r.gameserver.network.serverpackets.NpcSay; public class NFWalkerAI extends Quest { private static final int WALKER_NPC_ID = 20116; private final Map<String, Route> routes = new HashMap<>(); private final Map<Integer, Integer> npcIndexes = new HashMap<>(); private final Map<Integer, Boolean> npcReverse = new HashMap<>(); private final Map<Integer, String> npcCurrentRoute = new HashMap<>(); public NFWalkerAI() { super(-1, NFWalkerAI.class.getSimpleName(), "ai/npc/NFWalker"); loadRoutes(); addSpawnId(WALKER_NPC_ID); } private void loadRoutes() { // Route 1 Data Route route1 = new Route("route1"); route1.addPoint(new RoutePoint(0, 149363, 172341, -941, 0, false, "")); route1.addPoint(new RoutePoint(1, 148568, 172328, -980, 5, true, "Puff")); route1.addPoint(new RoutePoint(2, 148536, 172792, -980, 0, false, "")); // Route 2 Data Route route2 = new Route("route2"); route2.addPoint(new RoutePoint(0, 149363, 172341, -941, 0, false, "")); route2.addPoint(new RoutePoint(1, 150248, 172328, -980, 5, true, "Rise my children! Bring me the servants of the god! Let them be offered to our god Bifrons!")); route2.addPoint(new RoutePoint(2, 150248, 172776, -980, 0, false, "")); // Add routes to the map routes.put("route1", route1); routes.put("route2", route2); } @Override public String onSpawn(L2Npc npc) { if (npc.getId() == WALKER_NPC_ID) { selectInitialRouteForNpc(npc); } return super.onSpawn(npc); } @Override public String onAdvEvent(String event, L2Npc npc, l2r.gameserver.model.actor.instance.L2PcInstance player) { if (event.equalsIgnoreCase("move")) { moveNpc(npc); } else if (event.equalsIgnoreCase("check_reached")) { checkIfReached(npc); } return null; } private void moveNpc(L2Npc npc) { String routeName = npcCurrentRoute.get(npc.getObjectId()); Route route = routes.get(routeName); Integer pointIndex = npcIndexes.get(npc.getObjectId()); if (route != null && pointIndex != null) { RoutePoint point = route.getPoints().get(pointIndex); if (point.isRun()) { npc.setRunning(); } else { npc.setWalking(); } if (!point.getChat().isEmpty()) { npc.broadcastPacket(new NpcSay(npc.getObjectId(), Say2.NPC_ALL, npc.getId(), point.getChat())); } npc.getAI().setIntention(CtrlIntention.AI_INTENTION_MOVE_TO, new Location(point.getX(), point.getY(), point.getZ())); // Log movement intention System.out.println("NPC " + npc.getObjectId() + " moving to " + point.getX() + ", " + point.getY() + ", " + point.getZ()); // Schedule a check to see if the NPC has reached its destination startQuestTimer("check_reached", 1000, npc, null); } } private void checkIfReached(L2Npc npc) { String routeName = npcCurrentRoute.get(npc.getObjectId()); Route route = routes.get(routeName); Integer pointIndex = npcIndexes.get(npc.getObjectId()); if (route != null && pointIndex != null) { RoutePoint point = route.getPoints().get(pointIndex); Location currentLocation = npc.getLocation(); Location targetLocation = new Location(point.getX(), point.getY(), point.getZ()); // Check if the NPC has reached the target location if (currentLocation.equals(targetLocation)) { // Log that the NPC has reached the target System.out.println("NPC " + npc.getObjectId() + " reached target " + targetLocation); // Schedule the next movement startQuestTimer("move", point.getDelay() * 1000, npc, null); if (!npcReverse.get(npc.getObjectId())) { pointIndex++; if (pointIndex >= route.getPoints().size()) { npcReverse.put(npc.getObjectId(), true); pointIndex = route.getPoints().size() - 1; } } else { pointIndex--; if (pointIndex < 0) { npcReverse.put(npc.getObjectId(), false); pointIndex = 0; // Choose a new route after completing the current one in both directions switchRouteForNpc(npc); return; } } npcIndexes.put(npc.getObjectId(), pointIndex); } else { // Check again after 1 second startQuestTimer("check_reached", 1000, npc, null); } } } private void selectInitialRouteForNpc(L2Npc npc) { // Randomly select either route1 or route2 String selectedRouteName = "route" + (new Random().nextInt(2) + 1); npcCurrentRoute.put(npc.getObjectId(), selectedRouteName); npcIndexes.put(npc.getObjectId(), 0); npcReverse.put(npc.getObjectId(), false); startQuestTimer("move", 5000, npc, null); // Log initial route selection System.out.println("NPC " + npc.getObjectId() + " selected initial route " + selectedRouteName); } private void switchRouteForNpc(L2Npc npc) { String currentRoute = npcCurrentRoute.get(npc.getObjectId()); String newRoute = currentRoute.equals("route1") ? "route2" : "route1"; npcCurrentRoute.put(npc.getObjectId(), newRoute); npcIndexes.put(npc.getObjectId(), 0); npcReverse.put(npc.getObjectId(), false); startQuestTimer("move", 5000, npc, null); // Log route switching System.out.println("NPC " + npc.getObjectId() + " switched to route " + newRoute); } private static class Route { private List<RoutePoint> points = new ArrayList<>(); public Route(String name) { } public void addPoint(RoutePoint point) { points.add(point); } public List<RoutePoint> getPoints() { return points; } } private static class RoutePoint { private int id; private int x, y, z, delay; private boolean run; private String chat; public RoutePoint(int id, int x, int y, int z, int delay, boolean run, String chat) { this.id = id; this.x = x; this.y = y; this.z = z; this.delay = delay; this.run = run; this.chat = chat; } public int getId() { return id; } public int getX() { return x; } public int getY() { return y; } public int getZ() { return z; } public int getDelay() { return delay; } public boolean isRun() { return run; } public String getChat() { return chat; } } } I looking for help, with this, the npc not start to move. Im trying to create, an NPC wich have multiple walk routes basic logic is  random pick a route complite the route  like Route 1 start form zero (0 -> 1 -> 2(or more) -> 1 -> 0) When the npc return to 0, the script should pic the other route and start again.  And if there is a message like point 1 here     "route1.addPoint(new RoutePoint(1, 148568, 172328, -980, 5, true, "Puff"));" The npc should display the chat message. Currently my problem is the npc not moving, but if I manage it to start moving its randomly move between the route 1 and 2 set of coordinates. Currently for me its  a nightmare. I hope anyone can help somhow.
    • We are certainly not an ambulance, but we will definitely cure you of blacklists and empty pockets. Live freely with SX! Each of you will receive a trial version of SX to familiarize yourself with the product, all you have to do is post in this thread
  • Topics

×
×
  • Create New...