Help for a newbie
| User, date | Message |
|---|---|
|
Written by jossiejojo
6 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
6 years ago 3952 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
6 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
6 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
6 years ago 3952 posts since Fri, 07 Apr 06 |
marionjoe wrote: i do not know my host. Neither I know it. |
|
Written by eKatherine
5 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
5 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
5 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
5 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! 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
4 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
4 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
4 years ago 3952 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. |