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
Excellent post, thanks for this. I gathered lots of information from this and I am happy about it. Do share more updates.
ReplyDeleteMicrosoft Dynamics crm Training in Chennai
Microsoft Dynamics Training
Microsoft crm Training
Hacking course in Chennai
PHP Training in Chennai
gst Training in Chennai
Microsoft Dynamics crm Training in Anna Nagar
Microsoft Dynamics crm Training in Vadapalani
Microsoft Dynamics crm Training in Thiruvanmiyur
best weighing machine in india
ReplyDeleteA IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.
ReplyDeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring 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
Thanks a lot for sharing such a good source with all, i appreciate your efforts taken for the same. I found this worth sharing and must share this with all.
ReplyDeleteDot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
Great Post! Thanks for your Share.
ReplyDeleteQuality Onesie: Kigurumi Onesie Pajamas For Adults And Kids
Qualityonesie offers Pikachu, Disney, Anime, Hello Kitty, Animals, Winnie the Pooh, Stitch, Unicorn Kigurumi Onesie Pajamas for Adults and Kids.
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