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

Help for a newbie

jossiejojo posted 10 years ago in Creating a connection
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 :)
ansgar posted 10 years ago
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
marionjoe posted 10 years ago
anse:
hi anse

do you mean that i first create a database using my sql?
marion
marionjoe posted 10 years ago
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
ansgar posted 10 years ago

i do not know my host.



Neither I know it.
eKatherine posted 10 years ago
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.
ANRE posted 10 years ago
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..
chefmarty125 posted 10 years ago
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...
tosse posted 9 years ago
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!evilgrin please help.
gushersboy posted 9 years ago
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
rosenfield posted 9 years ago
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/"".
wyldemayne posted 9 years ago
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:
timedevour36 posted 9 years ago
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...
ansgar posted 9 years ago
Hell don't mix up just everything. What is the hostname you're trying to connect to?

Please login to leave a reply, or register at first.