Installation
| User, date | Message |
|---|---|
|
Written by mpgrp39
6 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
6 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
6 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
6 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
5 years ago 2 posts since Tue, 03 Jun 08 |
if you used acc user:root i tought the pass was :Admin |
|
Written by Dr. Dave
5 years ago 95 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
4 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
4 years ago 3954 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. |