SQL error 2003

[expired user #6571]'s profile image [expired user #6571] posted 12 years ago in General Permalink
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

jfalch's profile image jfalch posted 12 years ago Permalink
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.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
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
jfalch's profile image jfalch posted 12 years ago Permalink
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.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
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
jfalch's profile image jfalch posted 12 years ago Permalink
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.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
ok thx
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
sorry to bother you but i tryed to find it on hamachi site and nothing what do you suggest me?
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
whats mySQL password the root password thats all i need to know.is it my router pass?
jfalch's profile image jfalch posted 12 years ago Permalink
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.
jfalch's profile image jfalch posted 12 years ago Permalink
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.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
one time this forum helped me that why i was trying
ansgar's profile image ansgar posted 12 years ago Permalink
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.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
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
ansgar's profile image ansgar posted 12 years ago Permalink
Man, post the whole message, not only the error number.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
sure: SQL Error (1045):Access denied for user 'root'@'Panoramix' (using password: YES)

Panoramix is my pc user name.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
i use my hamachi ip in the host
ansgar's profile image ansgar posted 12 years ago Permalink
Ok, now you click here please.
[expired user #6571]'s profile image [expired user #6571] posted 12 years ago Permalink
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.