Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Error while connecting to MySQl Server 5.1.34 on UNIX platform.
Special Forums UNIX and Linux Applications Error while connecting to MySQl Server 5.1.34 on UNIX platform. Post 302391667 by amit_27 on Tuesday 2nd of February 2010 06:29:02 AM
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...
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT OPENSOLARIS

mysql_zap

zap(1)								  MySQL database							    zap(1)

NAME

       zap - a perl script used to kill processes

USAGE

       /usr/bin/mysql_zap [-signal] [-?Ift] pattern

SYNOPSIS

       zap [-I|-?]  [-f] [-t]

DESCRIPTION

       zap    supports by executing

       -I|-?  info

       -f     force

       -t     test

NOTE

       If  -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
       signal 9. If -t is given the processes is only shown on stdout.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(1), perror(1), replace(1)

       For  more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war-
       ranty.  Manual  page  by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
       dia.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							    zap(1)
All times are GMT -4. The time now is 03:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy