Help for a newbie

Could I have some really basic advice to help me get going with HeidiSQL.
I cant see a quickstart guide. Is there one?

What should I be putting in the boxes in the connection window? Are these ftp codes given me by my ISP or what?

hostname
user
password
port

Please can I have some guidance? I am completely new to SQLdatabase management. Thankyou very much :)

Hostname: likely the same as in your FTP-session

Port: most likely 3306 (default for MySQL)

User/Password: your personal credentials for mysql which were set by some database administrator. Don't mix that up with your FTP-, SSH- or whatever-account

anse:
hi anse

do you mean that i first create a database using my sql?
marion

anse:

hi again.
i have created database, yet still there is not insturctions for how to use heidi. i do not know my host.
any assistance would be happily appreciated
marion

i do not know my host.

Neither I know it.

I'm trying to learn to use php and mysql on my home computer. I have xampp. How do I configure heidisql to use it with localhost? It's not finding mysql.

I cannot connect :?

I would like to show you what varients that i try.

hostname: sitename.com
user: cpanel user name
password: cpanel password
port: 3306

hostname: site ip
user: cpanel user name
password: cpanel password
port: 3306

hostname: sitename.com
user: mysql db username
password: db user password
port: 3306

hostname: site ip
user: mysql db username
password: db user password
port: 3306

It is always same, i have never connected..

127.0.0.1 and the pass is ascent and the port is 3306 that is if your playing world of warcraft and setting up an account for it for a creating a private server.. you can try that one i said.. =D cause it worked for me...

How can i get a password? i have used password i have on site here and username nothing works! how to connect and ive tried ascent as password didnt work ither im going mad! please help.

heres whats written

host: 127.0.0.1

user:root

password:

port: 3306 Timeout: 30 secs

and when i press on connect theres an error message that appears saying: SQL Error : "Access denied for the user: 'root'@'localhost' (using password: NO)" can some1 help me plz so i can connect

Nobody here knows what your password is.

You can start the server with "mysqld-nt.exe --skip-grant-tables" instead of "mysqld-nt.exe" and it will allow you to login using any login/password, or at least root/"".

OK I am a total newb to this stuff and I am trying trying to put a custom item on my wow server but i can't connect, I used my register user and pass but it doesnt work, i dont know what FTP is or any of that stuff can any please help?

user?
pass? :cry:

I was able to connect a long time ago but I cant remember how... Now whenever I try I either get:

SQL Error: Host 'LR1' is not allowed to connect to this MySQL server

or

Unknown Database: arcemu

or

Acess Denied for user 'root'@'localhost' (using password: NO)

Same thing even when I type in the password.

Do I have to type in the database username and pw, or computer? or what...



... What is going on...

Hell don't mix up just everything. What is the hostname you're trying to connect to?