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.

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.

The default password for a blank MySQL installation is a blank string.
Leaving the password dialog box empty might get you in.

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

:)

if you used acc user:root i tought the pass was :Admin

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'.

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

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?