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

Help for a newbie

jossiejojo posted 8 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 8 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 7 years ago
anse:
hi anse

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

marionjoe wrote: i do not know my host.



Neither I know it.

eKatherine posted 7 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 7 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 7 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 7 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 6 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 6 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 6 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 6 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 6 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.