October 9, 2020
  • 3:18 pm Học Excel cơ bản #6: Cách ẩn/hiện thanh công cụ trong Excel
  • 2:38 pm Hướng dẫn xóa phông nền và ghép ảnh bằng paint.net
  • 8:21 pm Hướng dẫn làm trò chơi Lật cặp hình giống nhau bằng powerpoint | TRỢ GIẢNG
  • 12:53 pm Thủ Thuật Excel: Cách Cố Định Hàng Và Cột Trong Excel Bằng Freeze Panes
  • 4:43 am Nối liền các đoạn thẳng trong Autocad – Lệnh Join, PEdit // video học autocad // thuan quang



The reason is that recent Ubuntu installation (maybe others also),
mysql is using by default the UNIX or auth_socket plugin.

1. set root user to mysql_native_password

$ sudo mysql -u root -p # I had to use “sudo” since is new installation

mysql:~ USE mysql;
SELECT User, Host, plugin FROM mysql.user;
mysql:~ UPDATE user SET plugin=’mysql_native_password’ WHERE User=’root’;
mysql:~ FLUSH PRIVILEGES;
mysql:~ exit;

$ service mysql restart

2. Add new db_user with you system_user(recommended)
$ sudo mysql -u root # I had to use “sudo” since is new installation

mysql:~ USE mysql;
mysql:~ CREATE USER ‘YOUR_SYSTEM_USER’@’localhost’ IDENTIFIED BY ”;
mysql:~ GRANT ALL PRIVILEGES ON * . * TO ‘YOUR_SYSTEM_USER’@’localhost’;
mysql:~ UPDATE user SET plugin=’auth_socket’ WHERE User=’YOUR_SYSTEM_USER’;
mysql:~ FLUSH PRIVILEGES;
mysql:~ exit;

$ service mysql restart

Remember that if you use option #2 you’ll have to connect to mysql as your system username (mysql -u YOUR_SYSTEM_USER)

Short further steps
create database,tables,attributes, insert data
MySQL Connector/J use it inside your java project
connect with the path

Nguồn: https://keralafolkloreakademy.com/

Xem thêm bài viết khác: https://keralafolkloreakademy.com/giai-tri/

admin

RELATED ARTICLES

38 COMMENTS

  1. Suman Astani Posted on July 6, 2020 at 4:54 pm

    DO SUBSCRIBE CHANNEL. For more interesting content.

    Reply
  2. Amponsah Adom Isaac Nana Kwesi Posted on July 6, 2020 at 4:54 pm

    you've saved me bro

    Reply
  3. velie a Posted on July 6, 2020 at 4:54 pm

    i think I am the only one who failed. I am using ubuntu 18.04, i do not get any respond back after I enter the commands 🙁

    Reply
  4. Sergey Kornilov Posted on July 6, 2020 at 4:54 pm

    thanks bro!

    Reply
  5. Haidar Mehsen Posted on July 6, 2020 at 4:54 pm

    You saved me man, 1Million thanks 🙂

    Reply
  6. Salman Asif Posted on July 6, 2020 at 4:54 pm

    Thank you , It helped a lot!!.

    Reply
  7. Yugandhara Rao M Posted on July 6, 2020 at 4:54 pm

    Thanks for your detailed explanation, very helpful

    Reply
  8. Sujan Humagain Posted on July 6, 2020 at 4:54 pm

    Those of you who are having problem with method 2,
    use "mysqladmin -u [YOUR_USER] password" to create new password for user and that may work.

    Reply
  9. Gowtham Nimmagadda Posted on July 6, 2020 at 4:54 pm

    Hi. Nice video with good content. Can you please let me know how can get password for root. I forgot root password

    Reply
  10. Dumidu Pramith Posted on July 6, 2020 at 4:54 pm

    thanks it workes for me

    Reply
  11. Samuel Rodriguez Posted on July 6, 2020 at 4:54 pm

    Thanks, mate! I was starting to get really frustrated by not being able to open it

    Reply
  12. Maria Paula Sabogal Posted on July 6, 2020 at 4:54 pm

    ty bro!! you saved me!! 🙂

    Reply
  13. Sunday Binakin Posted on July 6, 2020 at 4:54 pm

    Thank you. the first solution worked for me

    Reply
  14. Enrique Mascote Posted on July 6, 2020 at 4:54 pm

    which version of workbench are you using?

    Reply
  15. sagar kudu Posted on July 6, 2020 at 4:54 pm

    Thankssssssss

    Reply
  16. Armando Ríos Gallego Posted on July 6, 2020 at 4:54 pm

    Thanks u Bro, u saved me :DDD

    Reply
  17. Abhishek Singh Posted on July 6, 2020 at 4:54 pm

    Thanks sir , its worked

    Reply
  18. Fabio Alexandrino Posted on July 6, 2020 at 4:54 pm

    I love you

    Reply
  19. Sr Random Posted on July 6, 2020 at 4:54 pm

    works on version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6, thx buddy

    Reply
  20. Santiago Medina Figuera Posted on July 6, 2020 at 4:54 pm

    You are the best dude! God bless you!

    Reply
  21. Miguel Arquejada Posted on July 6, 2020 at 4:54 pm

    Thank u!!

    Reply
  22. Ivan Pasciucco Posted on July 6, 2020 at 4:54 pm

    gracias amigo!

    Reply
  23. Nhân Hữu Posted on July 6, 2020 at 4:54 pm

    method 1 help me kill error. Tks youuuuuu!

    Reply
  24. Chinthana Wickramaarachchi Posted on July 6, 2020 at 4:54 pm

    Thanks Suman.. you solved my problem..

    Reply
  25. Infinite HUANG Posted on July 6, 2020 at 4:54 pm

    thanks a lot!

    Reply
  26. Dorin Pogor Posted on July 6, 2020 at 4:54 pm

    Many thanks for this 🙂

    Reply
  27. Alexander Klepach Posted on July 6, 2020 at 4:54 pm

    Great explanation and solutions. Sol1 helped solve my problem.

    Reply
  28. Spotty McBumble Fuck Posted on July 6, 2020 at 4:54 pm

    I love you so much, you have saved my ass on this one!

    Reply
  29. Gezierri Smaniotto Posted on July 6, 2020 at 4:54 pm

    Mestre

    Reply
  30. IFTHIKAR ALI A Posted on July 6, 2020 at 4:54 pm

    Thanks bro..!

    Reply
  31. stong Mendoza Posted on July 6, 2020 at 4:54 pm

    Thanks friend

    Reply
  32. eike Posted on July 6, 2020 at 4:54 pm

    When i maked my installation, i used ( alter user 'root'@'localhost' identified with mysql_native_password by 'password here' ) and this auth_sockt didn't happen to me. Could be a way, idk

    Reply
  33. gezierri smaniotto Posted on July 6, 2020 at 4:54 pm

    What a great help! Thanks a lot.

    Reply
  34. sergio lopez Posted on July 6, 2020 at 4:54 pm

    thanks bro! you are amazing!

    Reply
  35. Mathieu Cha Posted on July 6, 2020 at 4:54 pm

    I wish I could upvote this more than once.
    Thanks a lot!

    Reply
  36. Emanuele Mancinelli Posted on July 6, 2020 at 4:54 pm

    I'M REALLY GRATEFUL. THANK YOU VERY MUCH!!!

    Reply
  37. Ricardo Nascimento Posted on July 6, 2020 at 4:54 pm

    Thanks!!! This help me so much!

    Reply
  38. Giovanni Di Stefano Posted on July 6, 2020 at 4:54 pm

    Your Conky is interesting, would it be possible to have the .conkyrc file?

    Reply
LEAVE A COMMENT