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

Installation

User, date Message
Written by mpgrp39
7 years ago
Category: Installation
1 posts since Thu, 05 Jul 07
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.
Written by siMKin
7 years ago
104 posts since Sun, 01 Apr 07
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.
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
The default password for a blank MySQL installation is a blank string.
Leaving the password dialog box empty might get you in.
Written by siMKin
7 years ago
104 posts since Sun, 01 Apr 07

rosenfield wrote: 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

wrote: Leaving the password dialog box empty might get you in.



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



:)
Written by foxy
6 years ago
2 posts since Tue, 03 Jun 08
if you used acc user:root i tought the pass was :Admin
Written by Dr. DaveMoney, Euro
6 years ago
100 posts since Sun, 27 Jan 08
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'.
Written by susanspy
5 years ago
1 posts since Fri, 29 May 09
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
Written by ansgar
5 years ago
4789 posts since Fri, 07 Apr 06
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.