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

SQL error 2003

User, date Message
Written by weard3
2 years ago
Category: General
11 posts since Sat, 01 Sep 12
Hey guys i need help on the SQL error 2003 unhappy

Network type:MySQL (TCP/IP)

Hostname/IP:My Hamachi IP

User:root

Password:ascent(already tryed others)

Port:3307

pls i need help with this smile

Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
talk to the provider who runs your mysql server.
- is the password for user root correct ?
- is there any particular reason why to use port 3307 ? standard is port 3306.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
1: what do you mean provider who runs mysql server?

2:inst the password waht ever i want?

3:i tryed using 3306 and its the same error
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
1: a mysql database server must be running somewhere so that you can use it with mysql.
-if the server is running on your own computer, you must have set a passwort for root when installing mysql;
-if the server is running on someone else´s computer, then the person who adminstrates that computer is your databse provider; ask him/her.

2: no. the password is configured in the mysql server for the user named "root", you must find out what it is.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
iam not an expert so i dont understand so i dindt understand a few parts sorry.but yh its running on my PC. i just wanted to do a server public by hamachi but erros stopped me
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
if i understand you correctly, you are trying to setup a public hamachi server, and want to do something with a mysql database related to it.

i do not know hamachi, and have no idea wether a mysql server is included in its client software (and thus is really running on your computer - you should see a process named mysqld then), or wether it accesses some central server. consult the hamachi documentation, or forums on using hamachi, for this. there you should also find info on how to connect to that database server.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
ok thx
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
sorry to bother you but i tryed to find it on hamachi site and nothing what do you suggest me?
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
whats mySQL password the root password thats all i need to know.is it my router pass?
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
no. it´s not your router password, its not your phone number, and its not your mother´s maiden name. the password is in the configuration of the mysql server that hamachi is talking to. find out which server this is, and get it from there. i do not know it, and i cannot find it out. if you cannot find out the password by yourself, than whatever you want to do can not be done.
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
as an afterthought: your question "is it my router pass" seems to indicate to me, that you have very little idea of what you are doing, and/or very little knowledge of the components involved (mysql server, hamachi).

I suggest:
- open google.com, and input "hamachi mysql" as the search terms (without the "). You will get around 550000 results; read the top 50 or 100, and see wether this tells you something about your problem. Note: this is NOT a joke, but only what i myself do when confronted with an unknown situation.
- buy a book on mysql, and learn about "what is a database server", "how do i configure a mysql server (espec user accounts)".

Also note: this here is a forum to support a particular piece of software, ie the mysql client "heidisql".
the question how to generally access or configure database servers, or how to access the one that you want to use, is NOT a support question for heidisql and thus is misplaced in this forum.
this is also not a forum on how to learn to use a mysql server, and also not a forum on how to learn to use other software (hamachi) that may or may not use mysql.

SEEK ELSEWHERE.

I suggest you stop posting here; I will not talk to you again.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
one time this forum helped me that why i was trying
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
Well I too have the impression you're not really helping yourself. All your comments read as if you did not dive into the problem at all. Be honest, how many seconds did you take to follow jfalch's hints, and how long did you try to find something on the net, at Google or on the Hamachi pages, was it 10 or 30 seconds? I just typed "mysql hamachi 2003" into Google and found very helpful hints in the very first results, so that's why I think you did not look at all.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
i found things too and nothing could help me because i got another error that is (1045).... and hamachi site has nothing about MySQL

unhappy
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
Man, post the whole message, not only the error number.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
sure: SQL Error (1045):Access denied for user 'root'@'Panoramix' (using password: YES)

Panoramix is my pc user name.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
i use my hamachi ip in the host
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
Ok, now you click here please.
Written by weard3
2 years ago
11 posts since Sat, 01 Sep 12
the problem is that i dunno anything about this:

https://help.ubuntu.com/community/MysqlPasswordReset

and i think this may be the anwser for my problem.
 

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