Visit Our UNIX and Linux User Community


MySQL Authentication errror 1251 on Solaris.


 
Thread Tools Search this Thread
Operating Systems Solaris MySQL Authentication errror 1251 on Solaris.
# 1  
Old 08-20-2009
MySQL Authentication errror 1251 on Solaris.

I am trying to connect to MySQL installed on windows from Solaris machine.

While doing this getting error as:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251"

I have installed mysql-5.1.34-solaris10-sparc.tar.gz on Solaris.

mysql_real_connect() gets failed. If I do the same from mysql prompt it is succesfully connect to mysql on windows.

-bash-3.00# ./mysql -u root -h 10.77.176.122 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.1.34-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

But when I do following I get error.

-bash-3.00# ./mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
-bash-3.00# ./mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
-bash-3.00#


Can you please tell us what needs to be done for this?
# 2  
Old 08-20-2009
Hia,

Maybe teh belo wlink can help.

MySQL Lists: mysql: RE: MySQL Error 1251 / phpMyAdmin

Cheers,
Shazin

Previous Thread | Next Thread
Test Your Knowledge in Computers #557
Difficulty: Easy
The most expert of software developers never make mistakes.
True or False?

9 More Discussions You Might Find Interesting

1. Solaris

Solaris FTP authentication

Dears, Is there any way to secure ftp communication using transport layer security authentication /auth tls/? My background is solaris 10, wuftp. Scanned Solaris hosts in our network and found some insecure communications. Read all documents from oracle.com. But cannot find anything about... (1 Reply)
Discussion started by: sembii
1 Replies

2. Shell Programming and Scripting

Trying to convert utf-8 to WINDOWS-1251

Hello all i have utf-8 file that i try to convert to WINDOWS-1251 on linux without any success the file name is utf-8 when i try to do : file -bi test.txt it gives me : text/plain; charset=utf-8 when i try to convert the file i do : /usr/bin/iconv -f UTF-8 -t WINDOWS-1251 test.txt >... (1 Reply)
Discussion started by: umen
1 Replies

3. Shell Programming and Scripting

Send emails on Solaris 10 via relay authentication

Hi, I am looking for a shell/perl script which can used to get authenticate on relay server by a domain user account and password and send emails. Basically in our organisation system level authentication is blocked and we need to get authenticated via user level authentication on smtp... (1 Reply)
Discussion started by: sahil_shine
1 Replies

4. Solaris

Help with Solaris 10 and ldapclient authentication

Hello everyone! Currently, i have a RHEL6 server, with openLDAP server running. Most of our servers run on Rhel platform, but some of them run in Solaris 10, and I need to make them authenticate with ldap too. As the ldap server is running without encryption, the command I used for initialize... (13 Replies)
Discussion started by: Lilbighorn
13 Replies

5. Solaris

Solaris 10 openldap authentication with md5 passwords

Hello to everyone, We are trying to enable ldap authentication with pam_ldap and md5 passwords on a Solaris 10 system to an openldap server. If passwords are stored using crypt, everything works correctly. But if the password in openldap is in md5, then authentication fails. We have installed... (0 Replies)
Discussion started by: jfotop
0 Replies

6. Solaris

Iplanet LDAP User Authentication on Solaris

Dear Friends, I have recently installed iplanet directory server on my Solaris 10 machine.I was able to successfully install and configure ldap on my system.Furthermore, was also able to add user entries to the LDAP database server.But now I am finding it difficult to authenticate LDAP users... (1 Reply)
Discussion started by: raunaqnilekani
1 Replies

7. Solaris

Authentication of solaris with AAA?

hi i have a lab with routers, switches etc, and i was internet users to authenticate from my solaris server to another AAA server and then they able to access any router or switch. guide me where to start. thanks, Mazhar (2 Replies)
Discussion started by: mazhar99
2 Replies

8. Shell Programming and Scripting

Perl compilation errror on Linux 9.0

Hi, I installed Perl 5.8.9 on Linux machine and when I complied Perl script.It give error like :- perl: relocation error: /opt/ActivePerl-5.8/lib/auto/IO/IO.so: undefined symbol: Perl_newXS_flags Please provide solution to this issue. Thanks in advance. (1 Reply)
Discussion started by: allways4u21
1 Replies

9. UNIX for Advanced & Expert Users

ppp errror message in logs

I am getting this message in the log file. Apr 29 15:32:02 router ppp: Warning: Label COPYRIGHT rejected -direct connection: Configuration label not found This repeats every so often, the link is up however...Any ideas why i am getting this. Its freebsd 6.1 and pppoE. Frank (1 Reply)
Discussion started by: frankkahle
1 Replies

Featured Tech Videos