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.
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
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:
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'.
Please login to leave a reply, or register at first.