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 MOJAVE

dsenableroot

dsenableroot(8) 					    BSD System Manager's Manual 					   dsenableroot(8)

NAME

     dsenableroot -- enables or disables the root account.

SYNOPSIS

     dsenableroot [-d] [-u username] [-p password] [-r rootPassword]

DESCRIPTION

     dsenableroot sets the password for the root account if enabling the root user account.  Otherwise, if disable [-d] is chosen, the root
     account passwords are removed and the root user is disabled.

     A list of flags and their descriptions:

     -u username
	      Username of a user that has administrative privileges on this computer.

     -p password
	      Password to use in conjunction with the specified username.  If this is not specified, you will be prompted for entry.

     -r rootPassword
	      Password to be used for the root account.  If this is not specified for enabling, you will be prompted for entry.

EXAMPLES

     -dsenableroot
	      Your username will be used and you will be queried for both your password and the new root password to be set to enable the root
	      account.

     -dsenableroot -d
	      Your username will be used and you will be queried for only your password to disable the root account.

     -dsenableroot -u username -p userpassword -r rootpassword
	      The supplied arguments will be used to enable the root account.

     -dsenableroot -d -u username -p userpassword
	      The supplied arguments will be used to disable the root account.

Mac OS								  August 08 2003							    Mac OS
All times are GMT -4. The time now is 02:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy