Issue:-
ERROR 2049
(HY000): Connection using old (pre-4.1.1) authentication protocol ref used
(client option 'secure_auth' enabled)..
Solution:-
On the command
line, use below ....
mysql
-uUSERNAME -pPASSWD DbName -h HostName --skip-secure-auth
OR
Login to mysql
DB with root user.
show variables
like 'old_passwords';
+-----------------+-------+
|
Variable_name | Value |
+-----------------+-------+
|
old_passwords | ON |
|-----------------+-------+
old_passwords is
ON is clearly the problem,
So temporarily
changed it:
set session
old_passwords = 'OFF';
show variables
like 'old_passwords';
+-----------------+-------+
|
Variable_name | Value |
+-----------------+-------+
|
old_passwords | OFF |
------------------+-------+
Created a new
user:
create user
'username' IDENTIFIED BY 'passwd';
than try to
connect DB.
ReplyDeleteGreat blog! Your explanation style is too good, it is very impressed to me. I want more unique posts and Keeping the good work...
Oracle DBA Training in Chennai
Oracle DBA Course in Chennai
Unix Training in Chennai
Oracle Training in Chennai
Pega Training in Chennai
Primavera Training in Chennai
Excel Training in Chennai
Corporate Training in Chennai
Tableau Training in Chennai
Hi,
ReplyDeleteI must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.
Software Testing Training in Chennai
Software Testing Course in Chennai
Hadoop Training in Chennai
Python Training in Chennai
Web Designing Course in chennai
PHP Training in Chennai
German Language Classes in Chennai
Software Testing Training in Anna Nagar
Thanks for posting this blog. This author has been sharing some valuable content in a better way.
ReplyDeleteIELTS Coaching in Anna Nagar
IELTS Coaching in Chennai Anna Nagar
IELTS Coaching in Adyar
IELTS Coaching in Porur
IELTS Coaching in Mumbai
Best English Speaking Classes in Mumbai
Spoken English Classes in Chennai
IELTS Coaching Centre in Chennai
Thanks for sharing this great blog. That is very interesting to read and I am always searching for informative blog like this.
ReplyDeleteHtml5 Training in Chennai
Html5 Courses in Chennai
Html5 Training in OMR
DOT NET Training in Chennai
.net coaching centre in chennai
QTP Training in Chennai
LoadRunner Training in Chennai
Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Courses in Bangalore
digital marketing training in marathahalli
Digital Marketing Course in Coimbatore
Digital Marketing Course in Madurai
digital marketing training in btm
mmorpg oyunlar
ReplyDeleteInstagram takipçi satın al
TİKTOK JETON HİLESİ
Tiktok Jeton Hilesi
antalya saç ekimi
referans kimliği nedir
İnstagram Takipçi Satın Al
metin2 pvp serverlar
instagram takipçi satın al
Smm Panel
ReplyDeleteSmm Panel
iş ilanları
İNSTAGRAM TAKİPÇİ SATIN AL
HIRDAVATÇI
beyazesyateknikservisi.com.tr
Servis
tiktok jeton hilesi
üsküdar lg klima servisi
ReplyDeletependik arçelik klima servisi
çekmeköy bosch klima servisi
ataşehir bosch klima servisi
çekmeköy arçelik klima servisi
ataşehir arçelik klima servisi
kadıköy samsung klima servisi
kadıköy mitsubishi klima servisi
kartal vestel klima servisi