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)
forgotten password so not able to connect to DB
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:
http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
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:
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
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
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
Hi Kalvaro,
i executed mysqld.exe in command window it throws an error saying
pls let me know what can be done ? as i have not done modifications to mysql server.
thanks in advance..
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..
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 one
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.
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.
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...
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...
Please login to leave a reply, or register at first.