Cannot Connect – Error 1045

[rfresh]

When I try to connect to my web site I get an error 1045:

“Access denied for user: [email protected]”

I've configured MySQL for user 'rfresh' and MySQL password is being used – so why can't I connect?

Thanks for any help…

[CalEvans]

Make sure you configure it for:

[email protected]

or

rfresh@%

=C=

[HCB]

I am getting the error:

error number 1045:

Access denied for User: 'elmer_elmerlibr@##.###.###.### (Using Password: Yes)

where the # represent my ip address.

I tried the suggestion to add @% on to the end of my user name and when I did this I got the error message:

error number 1045:

Access denied for User: 'elmer_elmerlibr@%@##.###.###.### (Using Password: Yes)

THanks,

[Ritesh]

Greetings

You need to add % permission in the MySQL user table.

HTH

[Rayiw]

Hi Guys,

I'm getting the same error trying to get started here.

If I use the users I already have setup, the program adds my ipaddress to the end of the username.

If i try to add the user name and ip address info to the database, it gets truncated from:

[email protected]

to

syncuse

Gets error 1045

It would appear that the ip address for my pc gets added to the user name, but I can't add the same full user information as a MySQL user.

Also, what does, need to add % permissions to user table mean exactly?

Thanks

New user

Rayiw

[Ritesh]

Greetings

MySQL stores its access permission information in the Users table of MySQL database.

The MySQL privilege system ensures that all users may do exactly the things that they are supposed to be allowed to do. When you connect to a MySQL server, your identity is determined by the host from which you connect and the user name you specify. The system grants privileges according to your identity and what you want to do.

MySQL considers both your hostname and user name in identifying you because there is little reason to assume that a given user name belongs to the same person everywhere on the Internet. For example, the user joe who connects from office.com need not be the same person as the user joe who connects from elsewhere.com. MySQL handles this by allowing you to distinguish users on different hosts that happen to have the same name: you can grant joe one set of privileges for connections from office.com, and a different set of privileges for connections from elsewhere.com

Therefore, instead of providing a particular host in the Host column you should provide % to greant access to users connecting from any machine.

HTH

[Ritesh]

BTW, SQLyog does not add any extra information to what is provided by the User . Give yourselves correct permission and SQLyog will connect without any problem !!

[gluegun]

CalEvans wrote on Jul 18 2003, 04:27 PM:

Make sure you configure it for:

[email protected]

or

rfresh@%

=C=

This doesn't work becaue the username must be alphanumeric. 🙁

[Shadow]

As far as I'm concerned, usernames do not have to be alphanumeric (any character is allowed but '%' and '_'), unless your ISP changed the rules somehow. And even if it were, then providing '%' as host name should be sufficent.

[Shadow]

I forgot to list '@' in the forbidden characters' list.

[gluegun]

My host is a pain the a$$. It's breezeland.. the so called “best free host”. They're services are actually the best for a free host but what are they worth if the host is constantly getting hacked and nothing seems to work there. This host has had something wrong with it for the majority of the year going down for months at a time. Right now the MySQL databases at Breezeland is not viewable (that's why I'm trying to view it with SQLyog, I heard people at Breezeland could view it with SQLyog) and the forum has also been down for the longest time. It's just a complete mess there. I will have to buy a domain eventually I think.

You said that as far as you're concerned everything is alpahnumeric except “%” and “_”. Well hello the person said you had to put @% at the end of your database username when you create it…

The reason I'm doing all this and putting up with breezeland is because I want to successfully install a PHP MySQL based forum board. This is the only place I know that hosts free MySQL and PHP. Now I'm having problems with SQLyog program . Man I want to cry but I have to laugh…

[Ritesh]

I think you got it wrong.

You have to add '%' in the Host column in the User table so that corresponding user can connect from any host rather than some particular host.

[gluegun]

Ok I'm confused because I have no idea what you mean my “Host column” and “User Table” I don't know where to put the “%” or the “@%”!

[Shadow]

Dear gluegun,

What if you read chapter 4.2 “General Security Issues and the MySQL Access Privilege System” and chapter 4.3 “MySQL User Account Management” first? These two chapters describe the privilage system in detail, even the structure of the mysql db is explained.

There are two ways to add a user to a server:

– by explicitly issuing “INSERT INTO mysql.user (Host,User,Password…) VALUES ('%','my-user-name',MD5('my_password'),…); FLUSH PRIVILAGES;” SQL commands (… means the rights that accept values 'N' and 'Y'; MD5 is a MySql function that creates MD5 hash of the parameter)

– by issuing a GRANT command: GRANT SELECT, INSERT… ON my_db_name.* TO 'my-user-name'@'%';

If you specify ' around your username, then any characters are allowed, but _,@ and % are cautioned against; otherwise these three characters are not allowed!

[Author]

Posts