Can't Get Connected 1045

[ottago]

I cant get connected. I get this error message.

“Access Denied for user:'[email protected]

Using password Yes

[Ritesh]

Seems, you do not have correct permission to connect to the MySQL server.

[chr]

Hi everybody.

I know this issue has already been brought up several time but unfortunately all proposed explanations (probably) don't apply to my case.

The fact is that I'm able to connect manually using the following command

mysql -h mysql.server.it -P 3306 -u foo -p12345

but when I try to connect with SQLyog I get the aforementioned error.

Here's what is returned by the remote mysql server:

mysql> status

---

mysql Ver 11.18 Distrib 3.23.55, for Win95/Win98 (i32)

Connection id: 186134

Current database:

Current user: [email protected]

Server version: 3.23.51-log

Protocol version: 10

Connection: mysql.server.it via TCP/IP

Client characterset: latin1

Server characterset: latin1

TCP port: 3306

Uptime: 27 days 22 hours 52 min 0 sec

---

and here's what is inside my local SQLyog.ini file:

[Connection 1]

Name=test

Host=mysql.server.it

User=foo

Password=12345

Database=

Port=3306

SSL=0

Compress=0

Before I drive myself nuts on this can anybody help out? java script:emoticon(':eek:')

smilie

I would really appreciate that.

CHR

[Ritesh]

Bewildering 😮 This should work

MySQL client uses the same C API which SQLyog uses to connect to a MySQL server :huh:

Let me check out with my development team and I will post back in a day or two

[MrKAG]

For what it's worth, I have the exact same problem under the same circumstances.

[neilpwaa]

Me too! At a guess, is it anything to do with the Internet Provider adding the ip address to the end of the user id? If so, the user id wont be recognised by MySQL and return the error message. Anyone know how to get round this? I've used MySQL-Front and it works fine 😀 but it'd be nice to use SQLYog too.

[chr]

I thought about this too but, as I stated in my earlier post, if I connect manually (as user 'foo') using the 'mysql' shell command and issue a 'status' request I can see that that the remote db server returns '[email protected]' as the current user. Therefore it looks like this kind of *variable* ISP domain doesn't affect the ability to connect manually.

I was going to try and log all network request made by SQLyog when attempting connection in order to find more clues but I suppose that Ritesh and his team are already looking into this.

Will post any progress.

CHR

[CalEvans]

I still say this is a mysql issue because it's mysql reporting the error. You are talking to the server so SQLyog is working.

I have noticed that the mysql command line interface is more forgiving about the host you are connecting from.

using the mysql cli connect and switch to the mysql database. check the users table to make sure that your username AND host are explicitly set. (I still have problems with host='%')

Then try again.

=C=

[chr]

OK…here's the deal (at least for my case).

I'm able to connect manually using 'mysql' because I have the necessary grants. The same applies to SQLyog, which actually connects but then issues a 'SHOW DATABASES' instruction which succeeds only if the user has the necessary 'SHOW DATABASES' grants. And here's where it gets nasty (takes from the MySQL help file):

Code:

The privileges CREATE TEMPORARY TABLES, EXECUTE, LOCK TABLES, REPLICATION …, SHOW DATABASES and SUPER are new for in version 4.0.2. To use these new privileges after upgrading to 4.0.2, you have to run the mysql_fix_privilege_tables script.

In older MySQL versions, the PROCESS privilege gives the same rights as the new SUPER privilege.

The bottomline is:

* if the DB you are trying to connect to has version 4.0.2 (or greater) the you need to ask you DBA to give you the needed grants (GRANT SHOW DATABASES ON .* TO – or something like that)

* if the DB is older then you are either stuck or your DBA must be willing to grant you PROCESS privileges (I still don't know what that implies in terms of security – need to finish reading the docs)

Or alternatively, SQLyog could be changed so that it does not issue a SHOW DATABASES command upon connection in case a default database is supplied by the user. Just kidding. 😆

Hope this helps. Thanks guys.

CHR

[new to all of this]

Hi every one,

I am very new to all of this. I have ben working so hard on mysql and I cant seem to get any where on it. 😕

I keep getting this:

Error No. 1045

Access denied for user: '[email protected]' (using password: yes)

this is the infomation I used:

new connection

Mysql host address: 65.108.147.160

User Name: cathya

Password: ******** (The pass word that I use to log on to my control panel)

I can use all the help I can get ! I am trying to teach my self all of these things. I am not sure about what I am doing wrong. If you know how or what I am doing wrong please HELP! 😀 I am using RedhotHosting.com for my controle panel. I dont know if that helps any to know what I am doing wrong.

[Ritesh]

Thanks chr .

We will look into this matter 😀

[airplays]

I was plagued by this error message for DAYS, couldn't log into mysql remotely with either mysql-front or sqlyog… finally figured out the syntax of the command to get the remote user successfully added.

steps are:

1) log in as root: mysql -u root -p (then it'll prompt you for your password)

2) for this specific example, using user root at ip 192.168.2.5, which is the ip that you will be logging in from, and password “fruitcake” type the following: (and include the single quotes around the password)…

grant all privileges on *.* to [email protected].2.5 identified by 'fruitcake' with grant option;

[Author]

Posts