Home > mysql > MySQL 5.5 accepts password but then closes connection

MySQL 5.5 accepts password but then closes connection

July 24Hits:1
Advertisement

Apologies in advance for lack of information. I have installed MySQL 5.5 x64 on a Windows XP Professional x64 development machine. Today, upon trying to connect with any tool(MySQL workbench, PHP script, PhpMyAdmin, or command-line utility), the password is accepted but the connection is immediately closed:

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -u root -p Enter password: *************** Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.6.5-m8 MySQL Community Server (GPL)  Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.  Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.  mysql> Bye  C:\Program Files\MySQL\MySQL Server 5.6\bin> 

I have attempted removing all MySQL server-related files by deleting the installation directory and C:\Documents and Settings\All Users\MySQL\MySQL server 5.6, as well as D:\InnoDB Datafiles, where my InnoDB Tablespace lies. There is no important data, but I am unable to get MySQL server to operate properly. If any more info is needed, please do tell.

I have installed MySQL with the MSI installer and the instance config wizard. I have also tried the 5.6 development version, to no avail.

Answers

A) Try with

  • mysql -h[your IP] -u[username] -P[]port -p
  • mysql -h127.0.0.1 -u[username] -p
  • mysql -hlocalhost -u[username] -p

Which one works and which does not?

B) Set Log_warnings=2 in my.ini and restart MySQL server and see error log entry when connection gets closed abruptly.

Have you looked in the Windows event log to see if mysql is reporting any errors?

Also, do you permit root logins?

Final thing to look at.. you are logging to your loopback address (127.0.0.1), which in recent memory caused some issues in XP. Try using your ip address instead.

Related Articles

  • MySQL 5.5 accepts password but then closes connectionJuly 24

    Apologies in advance for lack of information. I have installed MySQL 5.5 x64 on a Windows XP Professional x64 development machine. Today, upon trying to connect with any tool(MySQL workbench, PHP script, PhpMyAdmin, or command-line utility), the pass

  • IMAP not accepting passwordsSeptember 29

    Hi. After a server reboot IMAP has stoped working; It does not accept passwords. This is for Thunderburd, Evolution and Roundcube. Code: [email protected]:~# telnet XXXXX.com.br 143 Trying 66.7.2XX7.XX4... Connected to XXXXs.com.br. Escape character is '^]

  • Mysql isn't accepting remote connectionsAugust 2

    I've configured MySQL on my CentOS 6.5 64 bit server and configured it to accept remote connections from any IP. When trying to connect through HeidiSQL it shows this error: SQL Error (2003): Can't connect to MySQL server on 'ip' (10060) Here's my co

  • How to secure MySQL database usernames and passwords within a php file? May 25

    This question already has an answer here: Reasonable way to store encrypted passwords in a webapp's database, Linux 4 answers I am working on a PHP website and my researches showed that it is entirely possible that the server can get hacked and the P

  • How to setup a MySql server to accept remote connections?December 6

    I am installing a MySql server in Ubuntu desktop. I could connect MySql Query Browser to it when specifying the Server Hostname as localhost, but when I replace it by the machine's IP it stops working (even if the MySql Query Browser runs in the same

  • ssh still accepts password authentication despite being configured for public-key only authentication (which works!)May 3

    I have configured an Ubuntu 10.04LTS desktop install to only allow public key authentication. RESULT: public key authentication works perfectly! QUESTION: The problem is that despite being configured to only accept public key authentication the clien

  • LDAP vs MySQL for Usernames and PasswordsJuly 10

    I understand the LDAP databases are more secure, but is it always necessary to use LDAP instead of MySQL for usernames and passwords? --------------Solutions------------- I'm not sure I agree that "LDAP databases are more secure". After all, an

  • Does the SFTP server accept passwords at all?August 31

    I'm trying to connect to a sftp server via sftp [email protected] Whatever I do, I get "Permission denied (publickey)." Googling doesn't help as everybody recommends switching to key-based authentication, which is a funny idea for somebody no

  • Mysql on ubuntu root password dissapeared somehow? Password no more required for mysql root? September 30

    Possible Duplicate: Mysql loses its root password I am sure i have mysql server installed on localhost with ubuntu with root user and required password. I have continued my daily developing job and suddenly password for root is no more required? Some

  • HDD not accepting PasswordOctober 16

    I have Dell Inspiron 6400 and my Hard disk (Seagate) was password protected. Now suddenly my HDD not accepting password (even though I know the password). I tried my HDD into another Laptop but result was same. Always showing Invalid Password. Can an

  • MySQL allows entry without Password November 28

    This question already has an answer here: MySQL 5.5.16 allows anonymous connections 2 answers I have configured my MySQL Database to require passwords on all users, even root from the machine itself. Now I discovered that there are empty Users in my

  • SSH Log: "Accepted password for user-"December 1

    I have only port 29999 open for SSH connections. But in the log file I see entries like this: Accepted password for user1 from 190.101.200.100 port 55805 ssh2 saying that a connection was accepted from port 55805. What does it mean? that someone was

  • Allow linux root user mysql root access without passwordDecember 27

    On cPanel when I am logged in as root and type "mysql" without hostname and password it gives me direct access to mysql root user. I would like to do this for one of my non-cpanel server where the linux root user gets password less logon to mysq

  • Can't start MySQL to reset root passwordDecember 19

    I've installed mysql-server on a Linux box and forgot (oops) the root password. Having looked around the internet, the general method is so: Stop MySQL (sudo service mysql stop) Start MySQL in special mode (sudo mysqld_safe --skip-grant-tables) Login

  • MySQL server stops accepting connections partially ("gone away" error)February 19

    Hope someone can help me debug this issue. There is a MySQL server 5.6.22 running on OS X 10.2. The load isn't too heavy. All databases are stored in InnoDB. From time to time it stop accepting connections from PHP applications and said applications

  • Ubuntu 12.04 on VMWare doesn't accept password April 25

    This question already has an answer here: How do I reset a lost administrative password? 14 answers I install Ubuntu 12.04 on VMWare. It works about month. But now it doesn't accept password. Password correct 100%. What should i do? --------------Sol

  • Ubuntu and mysql server. Something isnt allowing me to connectDecember 14

    I have a question about mysql settings http://serverfault.com/questions/94054/remote-connections-and-mysql-on-ubuntu/94088#94088 now i want to figure out why i cannot connect. I made sure bind-address was commented out. I can ping the server within t

  • monit mysql server blocked because of too many bad connectionsFebruary 27

    Is there any tweak for monit or another way to monitor whether one server can access mysql on another server? I tried it with monit but as you probably know, after 10 attempts, mysql blocks the server. check host db1.server with address db1.server if

  • Why is MySQL server only accepting empty passwords?September 10

    I've added a new user to my MySQL 5.1 server on a fresh installation of Fedora 13 and set its password. (Using SET PASSWORD FOR USER myuser = PASSWORD('...')), but MySQL only accepts the user when I'm using an empty password to log on. In other words

  • MySQL not accepting password, responds with using password: NOJuly 17

    I'm telling mysql to prompt for a password but it won't acknowledge it: mysql -h xxxxxx.xxxxxx.us-east-1.rds.amazonaws.com -P 3306 -u root –p response: Access denied for user 'root@%'@'10.10.1.1' (using password: NO) Even when I explicitly pass the p

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.385 s.