distal-attribute
distal-attribute
distal-attribute
distal-attribute

forgotten password so not able to connect to DB

vijaya posted 3 years ago in General
hi All,
i am not able to connect to DB (MySQL 5.5) as i have forgotten the password, could anyone let me know how to find out username and password ? i am getting error as

Could not establish Connection! Details:
SQL Error: Can't connect to MySQL server on '127.0.0.1'(10061)
kalvaro posted 3 years ago
1. HeidiSQL is just a GUI client for MySQL Server. The error you post is generated by MySQL, not HeidiSQL.

2. MySQL does not store plain passwords but password hashes, and the whole purpose of password hashing is that you can't find out what a given user's password is. Whatever, it's fairly unnecessary. If you have access to the server, you can just reset your password.

3. The error message says nothing about wrong passwords:

wrote: The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.



http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
vijaya posted 3 years ago
Hi Kalvaro,

thanks for your reply. ya you are correct the message says nothing about wrong password. but when i try to run mysql and mysqld exe files the window will open and automatically gets closed. the problem is in MySQL only. please let me know how to resolve it, as i have tried with all possibilities given. 1.tried to restart server under control panel>services but couldn't find mysql under this location.
2.tried to run MySQL server Instance Configuration Wizard but still no luck.

please help me.. thanks in advance
vijaya posted 3 years ago
Hi Kalvaro,

i executed mysqld.exe in command window it throws an error saying

[Warning]"Cant create test file C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\Data\XIN009ODTSPL05.lower-test
mysqld.exe: Can't change dir to 'C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\Data\' <ErrCode: 2>
[ERROR] Aborting
mysqld.exe: Shutdown complete



pls let me know what can be done ? as i have not done modifications to mysql server.

thanks in advance..
kalvaro posted 3 years ago
As I said, HeidiSQL is a tool to do stuff against a MySQL server so there's nothing it can do for you until you have onewink

My advise is that you read the docs and/or find a support group for MySQL Server. It'll also help if you are more descriptive about what you're doing and how it's failing.

vijaya posted 3 years ago
thanks for the reply Kalvaro,

i just wanted to start the mysql server which supports my android application for database maintenance.
the MySQL was working previously on my old system, but i have changed my system few days back and started using MySQL server after long time, did u need to do any setup after system change ?

thanks...
vijaya posted 3 years ago
sorry did i need to do any setup after system change ?
jfalch posted 3 years ago
This is a forum about HeidiSQL, a mysql client software.
it is NOT a forum on "how to configure/run a database server".
as kalvaro said, do find a support group/forum for MySQL Server, and ask there.

Please login to leave a reply, or register at first.