MySQL Error Nr. 1045 Access denied for user 'root'@'192.168.0.28' (using password: YE

uppalagayatri · 05-02-2011, 07:44 AM

Hai everybody,

I have install on mysql5.1.47 on fedora12

when i excute below command i can able to login

#mysql -u root -p

if i use

#mysql -h 192.168.0.28 -u root -p

ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.28' (using password: YES)

anybody can help how solve this.

Thanks in advanced....................

ChrisWashburn · 05-02-2011, 08:10 AM

When you don't specify the host, mysql will try to access the daemon through a socket file. When you do specify the host ("-h 192.168.0.28"), the daemon will be accessed through the network interface. Assuming that 192.168.0.28 is the local server, you will need to specificaly grant access through the network interface. This is done with "GRANT ... ON ... TO root@192.168.0.28;"

frankbell · 05-02-2011, 09:03 PM

Also, this might help:

http://dev.mysql.com/doc/refman/5.1/...ss-denied.html

uppalagayatri · 05-04-2011, 07:46 AM

Quote:

Originally Posted by ChrisWashburn

When you don't specify the host, mysql will try to access the daemon through a socket file. When you do specify the host ("-h 192.168.0.28"), the daemon will be accessed through the network interface. Assuming that 192.168.0.28 is the local server, you will need to specificaly grant access through the network interface. This is done with "GRANT ... ON ... TO root@192.168.0.28;"

Hi chris

can u tell me how to apply privileges

mysql>grant all privileges on *.* root@192.168.0.28;

but at that time i am getting below error

##########################
MySQL Error Nr. 2003
Can't connect to MySQL server on '192.168.0.28' (111)
##########################

if i use
#mysql -h 127.0.0.1 -u <root> -p <password>

at this time it is working

please guide me

Thanks in advanced.....................

chrism01 · 05-04-2011, 06:47 PM

Check the firewall

iptables -nvL

http://linux.die.net/man/8/iptables

uppalagayatri · 05-04-2011, 11:56 PM

Quote:

Originally Posted by chrism01

Check the firewall

iptables -nvL

http://linux.die.net/man/8/iptables

Thanks for giving reply

but i have stopped firewall service in my local & remote system

Wim Sturkenboom · 05-05-2011, 12:57 PM

Not a connection issue, I think; command is incorrect.

Code:

grant all privileges on *.* to root@192.168.0.28 identified by 'password'

A while ago that I used it, so there might be a mistake in the syntax.

Notes:
1) I don't advise to allow mysql root access via the network for security reasons; I only allow mysql root access from the physical machine (or via SSH from remote machines)
2) With the given command, your root user that connects via the network will not be able to grant permissions (which is -again- very advisable in my opinion).

uppalagayatri · 05-06-2011, 12:48 AM

Quote:

Originally Posted by Wim Sturkenboom

Not a connection issue, I think; command is incorrect.

Code:

grant all privileges on *.* to root@192.168.0.28 identified by 'password'

A while ago that I used it, so there might be a mistake in the syntax.

Notes:
1) I don't advise to allow mysql root access via the network for security reasons; I only allow mysql root access from the physical machine (or via SSH from remote machines)
2) With the given command, your root user that connects via the network will not be able to grant permissions (which is -again- very advisable in my opinion).

Hi Thanks for reply

ISolved the problem. when i change in /etc/my.cnf file bind-address=192.168.0.28 and i have applied privileges at that time
#mysql -h 192.168.0.28 -u root -p <password>
above the command is working.

can any body tell how add one more ip because 192.168.0.28 is my local ip if i change ip in /etc/my.cnf the mysqld daemon is not starting.

please guide me

Wim Sturkenboom · 05-06-2011, 08:30 AM

To my knowledge, you can't. The server can only listen on one address / port combination. So you have to start a second server (mysqld) with a different configuration.

But I'm actually missing what your trying to achieve. If you want to connect from multiple machines to this server, you have achieved what you wanted. The rest should be solvable with the grant command.

If you want something else, let us know.

ChrisWashburn · 05-11-2011, 01:45 PM

If you leave out the "bind-address", the daemon will listen on all interfaces by default. If you want to specifically tell it to listen on all interfaces, you can use "bind-address=0.0.0.0". You stated that when you change the IP in my.cnf, the daemon will not start. What are you changing it to? It must be an IP local to the server.