Error while connecting to MySQl Server 5.1.34 on UNIX platform.

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Error while connecting to MySQl Server 5.1.34 on UNIX platform.
# 1  
Old 02-02-2010
Error while connecting to MySQl Server 5.1.34 on UNIX platform.

Hi,

I have MySQL 5.1.34 installed on Solaris and Linux machine.

MySQl installed Solaris Machine - A.A.A.A
Remote Machine - B.B.B.B

I have user in mysql.user as below:

Code:
| user  |                     password                                    | host     |
+------+-------------------------------------------+-------------------------+
| root |*FAAFFE644E901CFAFAEC7562415E5FAEC243B8B   |    localhost
| root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19  |     %


When I try to connect using

Code:
> mysql -u root -p  with password (root) it works fine on the A.A.A.A machine.
Enter password: - root                 SUCCESS

Code:
> mysql -u root -h A.A.A.a -p (From remote machine) gives error as:
Enter password:  - root           FAILS

ERROR 1045 (28000): Access denied for user 'root'@'A.A.A.A' (usi
ng password: YES)

Using other user with host '%' and password is (pass)

Code:
> mysql -u root -p 
Enter password: pass
It gives the same error as :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


From remote machine
Code:
> > mysql -u root -p 
Enter password: pass

It is successful.

How should I create single user which will connect from both the machine with same credentials?

Last edited by pludi; 02-02-2010 at 08:13 AM.. Reason: code tags, please...
# 2  
Old 02-02-2010
Option 1: Use the same connection command on both hosts, meaning connect explicitly to the IP of the host. That way you should force it to use the password for root@A.A.A.A

Option 2: (not advised). Remove the entry for root using host '%', and change the host column for the other entry to read '%'. Or vice versa. But this could result in local maintenance scripts not working anymore, so I'd advise against it unless you're sure what you're doing.
# 3  
Old 02-02-2010
Thanks for the reply.

I have used same command on both the machine using IP address, but still it is giving the same error as "ERROR 1045 (28000): Access denied for user.

I have also removed user with the entry for host '%' and tried changing the host for user whose host were' localhost'.
In such case it is only connecting from remote machine and not from the same machine.
From the same machine it is giving the error as above.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connecting to Windows server from UNIX through script

I am trying to connect to a Windows server say 10.1.1.10. This servers has a folder named RAJ in which there are multiple .zip files. All these zip files contain a text file called XYZ.txt. Now i have to merge the content of these XYZ.txt files from each of the .zip file and create a new text... (1 Reply)
Discussion started by: swapniljadav
1 Replies

2. Red Hat

Error connecting to repo server

Hi guys, I will really appreciate your help on this issue I am having. I built a repository on one of my servers using a red hat dvd . It is working fine on that server. When I create a repo file in a client server and try to connect to the server repository, I get this error ... (2 Replies)
Discussion started by: cjashu
2 Replies

3. Solaris

Ftp: SSL_connect error while connecting from source to destination server Solaris 10

Hi Everyone, I am using solaris 10.I am facing a different problem here with tlsftp.I have intalled all steps for tlsftp and able to connect to the destination server from the source server.It worked for some days.But recently when i am connectin it is giving below error.I am... (0 Replies)
Discussion started by: muraliinfy04
0 Replies

4. Shell Programming and Scripting

Error in installing mysql on unix server

Hi , I am trying to install mysql but getting below error $# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) can anyone provide me this file 'mysql.sock' Thanks (6 Replies)
Discussion started by: aish11
6 Replies

5. UNIX for Dummies Questions & Answers

Connecting to Unix server through Oracle

Hi, I need some help regarding oracle with unix script Actually i have a shell script and i want that it gets triggered through a oracle Db.I dont have any idea how is it done, even whether it is possible....pls help.....!!!! (3 Replies)
Discussion started by: fidelis
3 Replies

6. Shell Programming and Scripting

Connecting to multiple unix server from unix server using shell script

Hi Gurus, I'm a unix newbie and I would like to connect to multiple unix servers from unix server using shell script i.e from server a to server b,c,d etc. I want to copy the files from unix server a to server b, c, d. I can access staright using ssh without the need to have password and user... (5 Replies)
Discussion started by: sexyTrojan
5 Replies

7. UNIX for Dummies Questions & Answers

Connecting to UNIX server

Hi, My knowledge bucket of UNIX is almost empty. I have developed an application in EXCEL which can create XML files (Metadata) from Binaries. These binaries are stored in UNIX server on regular intervals. Currently I am transferring all binaries(GBs of files) to WINDOWS using WINSCP and... (2 Replies)
Discussion started by: bobs
2 Replies

8. Shell Programming and Scripting

Connecting to remote unix server using java?

I need help writing java code that can connect to a remote unix server, and run a script on that server. I have scoured the internet, but I have been unable to find proper documentation on how this can be accomplished. Any help is appreciated thanks. (1 Reply)
Discussion started by: developncode
1 Replies

9. UNIX for Advanced & Expert Users

connecting UNIX/Linux to NTP server

Hello i want to connect my solaris & Linux boxes to ntp server i used the command /usr/sbin/ntpdate -s -b -p 8 -u <NTP-IP> and added the NTP server as server in /etc/ntp.conf please help in completing the process and verifying it (1 Reply)
Discussion started by: learn82
1 Replies

10. UNIX for Dummies Questions & Answers

Connecting to samba server from unix command line

Hi, I am trying to connect to a samba server from my unix command line. I am using Ubuntu and I can access the server from the GUI, but I need to write a script to automate a backup. Does anyone know how to do a cd into a smb drive from the unix command line? Thanks, Eric (2 Replies)
Discussion started by: ejbrever
2 Replies
Login or Register to Ask a Question