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

Help for a newbie

User, date Message
Written by jossiejojo
7 years ago
Category: Creating a connection
4 posts since Fri, 11 May 07
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 :)
Written by ansgar
7 years ago
4801 posts since Fri, 07 Apr 06
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
Written by marionjoe
7 years ago
3 posts since Thu, 12 Jul 07
anse:
hi anse

do you mean that i first create a database using my sql?
marion
Written by marionjoe
7 years ago
3 posts since Thu, 12 Jul 07
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
Written by ansgar
7 years ago
4801 posts since Fri, 07 Apr 06

marionjoe wrote: i do not know my host.



Neither I know it.
Written by eKatherine
6 years ago
1 posts since Wed, 05 Mar 08
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.
Written by ANRE
6 years ago
1 posts since Thu, 06 Mar 08
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..
Written by chefmarty125
6 years ago
3 posts since Wed, 16 Apr 08
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...
Written by tosse
6 years ago
1 posts since Thu, 01 May 08
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.
Written by gushersboy
5 years ago
1 posts since Sun, 09 Nov 08
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
Written by rosenfield
5 years ago
127 posts since Wed, 24 Jan 07
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/"".
Written by wyldemayne
5 years ago
1 posts since Sun, 01 Mar 09
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:
Written by timedevour36
5 years ago
1 posts since Tue, 03 Mar 09
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...
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
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.