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

Installation

mpgrp39 posted 10 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 posted 10 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 posted 10 years ago
The default password for a blank MySQL installation is a blank string.
Leaving the password dialog box empty might get you in.
siMKin posted 10 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 posted 9 years ago
if you used acc user:root i tought the pass was :Admin
Dr. Dave posted 9 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 posted 8 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 posted 8 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.