What is this Error no. 1045

Asked by Pravin Singh on 2009-09-09

When I try to connect to MySQL through a newly bought GUI, I am getting this error 1045. I did a serch on google and found that it is the problem with server datails. Please help..

Question information

Language:
English Edit question
Status:
Solved
For:
MySQLAtFacebook Edit question
Assignee:
No assignee Edit question
Last query:
2009-09-11
Last reply:
2010-05-05
Ernst Zlo (ernst-zlo) said : #1

Would you please consider to give some more details?

What GUI?
Can you connect to the MySQL server with another program (PHP?)
Can you ping the host (if not localhost)?
What port are you using?

Pravin Singh (pravinsingh) said : #2

Hi Ernst,

Thank you for yor quick response. I wonder if you can tolerate a novice like me. I really appreciate your help.

Well, I am using SQLyog Community Edition as a GUI and I am still learning how to connect MySQL server to PHP. I have done it before and somehow I was able to do so. But if you suggest me some tutorials on this it will be of great help. I can ping the Localhost using port 3306.

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #82318]: What is this Error no. 1045
> Date: Wed, 9 Sep 2009 13:45:06 +0000
>
> Your question #82318 on MySQLAtFacebook changed:
> https://answers.launchpad.net/mysqlatfacebook/+question/82318
>
> Status: Open => Answered
>
> Ernst Zlo proposed the following answer:
> Would you please consider to give some more details?
>
> What GUI?
> Can you connect to the MySQL server with another program (PHP?)
> Can you ping the host (if not localhost)?
> What port are you using?
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/mysqlatfacebook/+question/82318/+confirm?answer_id=0
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/mysqlatfacebook/+question/82318
>
> You received this question notification because you are a direct
> subscriber of the question.

_________________________________________________________________
Sports, news, fashion and entertainment. Pick it all up in a package called MSN India
http://in.msn.com

Ernst Zlo (ernst-zlo) said : #3

Hi Provyn,
very sorry for the delay in answering, I simply forgot to hook the „E-mail me future discussion about this question“ <sigh>
(Which will tell you all about beeing a novice and that it does NOT depend on this <grin>)

I am working with MYSQL-Administrator (Synaptic search for mysql-admin ) because it is available on Linux and - sometime I'm forced to use it Windows <g>

There is a very informative script to see, what is running and what not and which config files are involved etc. etc.
safe this in your web root directory as test.php

<?php mysqlinfo(); ?>

And carefully look at the output. There is a section about MySQL too.

The fact that you can ping the mysql server means, that it is up an running.
THATS FINE <g>

1045 should be a simple login + password problem.

Open a terminal
mysql -u root -h localhost -p

you are requested for your password.
After entering it should display:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1236
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

[you can leave the MySQL server by typing exit]
if that's o.k. we can follow the PHP to MySQL connection problem ...

MySQL http://dev.mysql.com/doc/ for the docs.
Apache http://httpd.apache.org/ for links to FAQ and docs.

But feel free to ask here IMHO it is a very little thing, you've missed ;-)

Which does NOT mean, that reading manuals are not quite a good idea to get solution to problems ...

Mark Callaghan (mdcallag) said : #4

1