Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Installation

mpgrp39's profile image mpgrp39 posted 12 years ago in Installation
I have recently install HeidiSQL from here. However I am unable to enter HeidiSQL as i do not know the password. I set a new connection using localhost and the default user is root however I am unable to enter without the password. There was no prompt to ask me for a username and password during installation or is it supposed to be like that. Sorry to trouble you but I would like to know how to solve my problem. Thank you.
siMKin's profile image siMKin posted 12 years ago
The username and password are not for Heidi, but for the database.
Did you install the database-server yourself? In that case you should check the documentation for the default password if you haven't set one during the installation. If someone else did it (your hosting-provider for example) you should contact them.
rosenfield's profile image rosenfield posted 12 years ago
The default password for a blank MySQL installation is a blank string.
Leaving the password dialog box empty might get you in.


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
siMKin's profile image siMKin posted 12 years ago

The default password for a blank MySQL installation is a blank string.



That really depends how you install mysql and on what platform.
I know for a fact that with some linux distributions a default password is set for root. But this is always specified in the docs

Leaving the password dialog box empty might get you in.



the default user is root however I am unable to enter without the password



:)
foxy's profile image foxy posted 11 years ago
if you used acc user:root i tought the pass was :Admin
Dr. Dave's profile image Dr. Dave posted 11 years ago
No, there is no "default" password. If you didn't specify a 'root' password when you set up your MySQL server, it's easy to fix.

Step 1: Create a .txt file in the root of your C drive.

Step 2: Name this file, "mysql-init.txt". So now it should look like this:
C:\mysql-init.txt

Step 3: Type this in your text file, then save and close your file:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

Step 4: Go to START -> RUN and type: NET STOP MYSQL

Step 5: Go to START -> RUN and type: cmd

Step 6: Paste this:

"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --init-file=C:\mysql-init.txt


And you're done. Now log into your MySQL server with HeidiSQL using your new password for 'root'.
susanspy's profile image susanspy posted 10 years ago
hello all,


i am susan here, i have problem with attaching sql server to my website so please anyone let me know what can i do? then to solve my problrem.


thanks in advance


cheers!!!!!!!!!!!!!!!!!!!!

keyword tools~search keywords
Keyword Tracking Tool~overture tool
ansgar's profile image ansgar posted 10 years ago
Susan, your question is too unspecific so noone will be able to help. You could also ask "I have a problem building my house. What can I do?"

Could you please tell what's the *exact* problem?

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