PnTutorials by Pradnyankur Nikam
PnTutorials by Pradnyankur Nikam
  • Видео 69
  • Просмотров 1 674 865

Видео

Download & Import Sample Database | Example Database to Learn SQL
Просмотров 475 месяцев назад
If you have recently started learning SQL, You'll need sample databases and data. So that you can run example SQL statements, and practice learning SQL on your computer. In this video tutorial, we will import or add example databases, tables and data rows in our MySQL database server. Check out my some important video tutorials on SQL What is Database? ruclips.net/video/bGrGJgSUywQ/видео.html W...
Top 10 Databases to Learn in 2024
Просмотров 2495 месяцев назад
Check out our Top 10 Databases for 2024 list. If you are planning to learn Database Development or Database Administration, you must review this list. We have included top and demanding databases list for the year 2024. 00:20 Dynamodb Database 00:50 Oracle Database 01:22 Elasticsearch 01:44 MariaDB RDBMS 02:12 Redis NoSQL DB 02:30 Microsoft SQL Server DB 03:01 MongoDB NoSQL Database 03:22 SQLit...
Difference Between DDL & DML | Data Definition Language, Data Manipulation Language
Просмотров 945 месяцев назад
In this video tutorial, we will learn the Difference Between DDL & DML. We will understand what are DDL (Data Definition Language) and What are DML (Data Manipulation Language) Statements. Then we will learn the different types of DDL & DML SQL Statements. We will also learn the Difference and Benefits of DDL and DML. And, finally we will see some Example DDL Statements and Example DML Statemen...
A Standard Database SQL Statement | Keywords, Identifiers, Constants & Clauses
Просмотров 435 месяцев назад
In this video tutorial, we will learn what is a standard database SQL statement. We will also understand Keywords, Identifiers, Constants & Clauses in SQL statement. A SQL Statement is used to execute some actions. And a SQL command or syntax or statement is made up of different elements like keywords, identifiers, constants & clauses. This video tutorial will explain about each element using e...
Add Data Rows to Database Table | SQL Insert Statement
Просмотров 265 месяцев назад
In this video tutorial, we will see how to add or insert data rows in a database table. Learn SQL and INSERT INTO SQL statement. If the video tutorial was helpful to you, like the video and subscribe to PnTutorials RUclips Channel. What is a Database Table? ruclips.net/video/ltyPgKfdyOA/видео.html #Insert, #SQL, #MySQL, #LearnSQL, #PnTutorials
What is a Database Table? Create and Use a Database Table.
Просмотров 965 месяцев назад
Let's learn, What a database table is? and how you can create and use a database table. A database table is used to store data. It is a systematic structure of columns and rows. The vertical structures are columns or fields and data rows or records are horizontal. Each column represents the property of an item, while each row is an item. # Database Table SQL Statements # 01:25 Create a new scho...
Learn SQL in 100 Seconds?
Просмотров 406 месяцев назад
Learn SQL in 100 Seconds? Learn SQL 2024. Learn SQL Statements in 100 Seconds. Course Link: bit.ly/47NJZDo * MySQL Installation Tutorials * Download & Install MySQL 8 Database Server on Windows 11 ruclips.net/video/y09znAT9el8/видео.html Download & Install MySQL 8 Database Server on Windows 10 ruclips.net/video/1lC6I-4o_8A/видео.html Install MySQL 8.0.32 on MacOS 12 Monterey ruclips.net/video/1...
What is Database? Learn about #database @PnTutorialsbyPradnyankurNikam
Просмотров 337 месяцев назад
If you are completely new to databases. Then the very first question comes to your mind is, What is database? That's what we will cover in this video tutorial. A database is an organized collection of structured data or information. The data is stored inside tables. And tables contain columns and rows which actually holds the data. Types of Databases: Based on different technologies, there are ...
SQL Tutorials | Learn SQL MySQL in 2 Hrs | Practically!!!
Просмотров 943Год назад
Buy Now: bit.ly/3MKQrT6 Full Course $19 USD ONLY (Original Price $189 USD) Learn SQL with MySQL Database. If you want to learn SQL using MySQL database, then this tutorials is for you. This video tutorial gives you a brief introduction to SQL in 2 Hours. You can ask me questions in the comment section of this video. #SQL #MySQL #Database #Learn #DBMS #RDBMS #structuredquerylanguage
Setup Environment Variable for MySQL 8 Database in windows 10 & Windows 11
Просмотров 3,6 тыс.Год назад
In this video tutorials, we will learn how to customize the PATH for MySQL 8 database server. If we want to directly (without using MySQL bin folder path) access MySQL 8 database server via Windows command prompt, then we must create MySQL database shortcut. To make it easier to invoke MySQL programs, we can add the path name of the MySQL bin directory to Windows system PATH environment variabl...
Uninstall MySQL 8 from Windows 11
Просмотров 172Год назад
While re-installing MySQL 8 database, you might be getting errors. OR you might want to completely uninstall MySQL 8 from your Windows 11 computer. In both the case, you must have properly & completely uninstall existing MySQL 8 database server from your Windows 11 PC. But before we complete remove MySQL 8 database server, we must take back up of our existing database. This video tutorial step ...
Download & Install MySQL 8 Database Server on Windows 11
Просмотров 671Год назад
If you want to learn SQL or work on MySQL projects, you must have MySQL installed on your computer. In this video we will step by step learn how to Download & Install MySQL 8 Database Server on Windows 11. In case of Windows 11 users, this tutorial will be useful for MySQL 8 database server installation. The installation steps in this video would also work on Windows 7 and Windows 10 operating ...
Uninstall OR Remove MySQL 8 from Windows 10
Просмотров 127Год назад
Uninstall OR Remove MySQL 8 from Windows 10
Download & Install MySQL 8 Database Server on Windows 10 [Step-by-Step]
Просмотров 420Год назад
Download & Install MySQL 8 Database Server on Windows 10 [Step-by-Step]
Uninstall MySQL 8 Database from Ubuntu 22.04 LTS
Просмотров 3 тыс.Год назад
Uninstall MySQL 8 Database from Ubuntu 22.04 LTS
How to Install MySQL 8 in Ubuntu 22.04 LTS [Step-by-Step]
Просмотров 9 тыс.Год назад
How to Install MySQL 8 in Ubuntu 22.04 LTS [Step-by-Step]
How to create Database in MySQL & How to create Table in MySQL?
Просмотров 231Год назад
How to create Database in MySQL & How to create Table in MySQL?
Uninstall MySQL 8 Database from macOS 12 Monterey
Просмотров 520Год назад
Uninstall MySQL 8 Database from macOS 12 Monterey
Install MySQL 8.0.32 on MacOS 12 Monterey [Step-by-Step Tutorial]
Просмотров 17 тыс.Год назад
Install MySQL 8.0.32 on MacOS 12 Monterey [Step-by-Step Tutorial]
What is DBMS? What is RDBMS? DBMS vs RDBMS!
Просмотров 88Год назад
What is DBMS? What is RDBMS? DBMS vs RDBMS!
MySQL Tutorial 1: What is SQL & MySQL? Benefits of learning SQL
Просмотров 242Год назад
MySQL Tutorial 1: What is SQL & MySQL? Benefits of learning SQL
Reset MySQL 8 Database root user password on MacOS Big Sur
Просмотров 26 тыс.2 года назад
Reset MySQL 8 Database root user password on MacOS Big Sur
SQL vs MySQL | Difference between sql and mysql database
Просмотров 20 тыс.2 года назад
SQL vs MySQL | Difference between sql and mysql database
How to Create/Rename/Alter/Drop new user in MySQL 8 Database [Practically]
Просмотров 8052 года назад
How to Create/Rename/Alter/Drop new user in MySQL 8 Database [Practically]
How to Login & Connect to MySQL 8 Database Server on Windows, Mac & Linux
Просмотров 8 тыс.2 года назад
How to Login & Connect to MySQL 8 Database Server on Windows, Mac & Linux
Completely Remove or Uninstall MySQL 8 database from Windows 11
Просмотров 5 тыс.2 года назад
Completely Remove or Uninstall MySQL 8 database from Windows 11
How to Install MySQL on Windows 11 | MySQL 8 Database Installation on Windows 11 [Latest]
Просмотров 3,9 тыс.2 года назад
How to Install MySQL on Windows 11 | MySQL 8 Database Installation on Windows 11 [Latest]
Completely Uninstall OR Remove MySQL 8 from Windows 10
Просмотров 4,4 тыс.2 года назад
Completely Uninstall OR Remove MySQL 8 from Windows 10
MySQL 8 Download & Install for Windows 10 64 bit [Step-by-Step]
Просмотров 27 тыс.2 года назад
MySQL 8 Download & Install for Windows 10 64 bit [Step-by-Step]

Комментарии

  • @mtbmtbmtbcycle8797
    @mtbmtbmtbcycle8797 9 дней назад

    one more thing ** if you have installed mysql via terminal like conda or brew.... and forget about it , first doo remove that before resetting pass for server gui version (dmg installed one).

  • @TasnuvaNusratTahsin
    @TasnuvaNusratTahsin 9 дней назад

    thanks saved my life

  • @onepercentdaily
    @onepercentdaily 10 дней назад

    thanks so much. savior

  • @kongpopkeattireangwattana6113
    @kongpopkeattireangwattana6113 10 дней назад

    I use mysql -u root but error 2002(HY000)

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 10 дней назад

      Hi, If you recently installed MySQL 8 on your computer and getting ERROR 2002 (HY000) error while logging in, then you should uninstall MySQL 8 (If you don't have any important data). You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. ruclips.net/video/Y33uhgh5eOc/видео.html Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnynkur

  • @ankushsahani7367
    @ankushsahani7367 10 дней назад

    thanks boss

  • @adyasamishra3392
    @adyasamishra3392 13 дней назад

    Amazing tutorial sir. It worked.

  • @442trash
    @442trash 14 дней назад

    THANK YOU SO MUCH

  • @AliHasan-q9o
    @AliHasan-q9o 15 дней назад

    Hi sir for me its showing access denied to the bin folder. Can you help ?

  • @jolo8830
    @jolo8830 15 дней назад

    Hello i aml following the steps for Reset MySQL database root user account password. I opened a new terminal, enetered this: mysql -u root and got this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 15 дней назад

      Hi Jolo, If you recently installed MySQL 8 on your computer and getting ERROR 2002 (HY000) error while logging in, then you should uninstall MySQL 8 In order to fix the issue. You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. ruclips.net/video/Y33uhgh5eOc/видео.html Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnynkur

  • @kylekim2847
    @kylekim2847 15 дней назад

    Thank you

  • @shivashankarirajaram8628
    @shivashankarirajaram8628 17 дней назад

    OH MY GOD!!! YOU ARE A SAVIOUR!!! Out of severalllll like honestly several videos that lead me nowhere, this was the most useful video that helped me reset my MySQL root password!! IT WORKED!!! I'm super excited because the struggle is REAL!!

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 17 дней назад

      Thank you Shiva for the positive feedback. Glad to know the video tutorial was helpful to you. 😊🙏

  • @lorenamilheiro6664
    @lorenamilheiro6664 17 дней назад

    I've watched many videos but it was still not working... Till I found you. Completely amazingg!!!!! Tks for your help

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 17 дней назад

      Thank you Lorena for the positive feedback. Glad to know the tutorial was helpful to you. 😊🙏

  • @yt-1161
    @yt-1161 17 дней назад

    great explanation mate

  • @zhenbinchong6186
    @zhenbinchong6186 19 дней назад

    hi, I follow your step to turn on skip networking, and now my root veriables skip-networking value is ON, and my port value become 0. incase now i need to use port 3306, how do I fix it?

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 19 дней назад

      Hi zhenbin, I didn't get your question. Can you provide commands that you used to reset the password? Were you able to reset the root user password? Provide more details so that I can understand your question and help you fix the issue.

    • @zhenbinchong6186
      @zhenbinchong6186 19 дней назад

      @@PnTutorialsbyPradnyankurNikam HI, I already fix out the problem by download the older version MYSQL. I guess is because the new version MYSQL still unstable for now.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 18 дней назад

      Glad to know you were able to fix the issue.

  • @ashmitgupta5303
    @ashmitgupta5303 20 дней назад

    Thanks!

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 20 дней назад

      Thank you Ashmit for the "Super Thanks". Glad to know the video tutorials was helpful to you. 😊🙏

  • @jonluis2647
    @jonluis2647 22 дня назад

    legend, thank you

  • @arpitasarang2870
    @arpitasarang2870 22 дня назад

    ekdam mast bataya h

  • @udaykiranblogging
    @udaykiranblogging 23 дня назад

    Thank you very much for this bro, it really helped me to connect to the server.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 22 дня назад

      You are welcome Uday, Glad to know the tutorial was helpful to you. Thanks for the feedback 😊🙏

  • @imamimroni8343
    @imamimroni8343 29 дней назад

    I tried to start mySQL in 10.39, but it's turn green for a second and go back to red, and I cannot start it, can you help me?

    • @imamimroni8343
      @imamimroni8343 29 дней назад

      And I installed MySQL version macOS 14 (x86, 64-bit), DMG Archive, I used big sur as yours.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 29 дней назад

      Hi Imam, * Most probably, latest MySQL version might not be supporting on your computer. I would suggest you to downgrade your MySQL version. * Checkout following tutorial to completely un-install MySQL from your computer. ruclips.net/video/PBAnWXKIps8/видео.html * Once you remove MySQL from your computer. Go to following URL, downloads.mysql.com/archives/community/ * On MySQL Product Archives page, from "Product Version", select 8.0.24 and for "Operating System" select "macOS". And download "macOS 11 (x86, 64-bit), DMG Archive" file. (Only if you are using macOS Big Sur). If you are using different version of macOS. Let me know you macOS version and I would suggest you a proper MySQL version. * Once you download dmg file, follow installation steps from this video. And it would work without any issue. Let me know if it works. If it still doesn't work. Regards, Pradnyankur

  • @Resistance2u
    @Resistance2u 29 дней назад

    its showing me ethis error "SELECTED PATH ALREADY EXIST" can you help me with this please

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 29 дней назад

      You are getting this error while installing or un-installing? In case of uninstall, follow the steps carefully, and everything will get uninstalled. Then you can start with a fresh installation.

    • @Resistance2u
      @Resistance2u 27 дней назад

      @@PnTutorialsbyPradnyankurNikam i am getting this error after unistalling the software from control panel now when i install it again its showing this error i cannot use your method as i have already uninstalled it ☹☹

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 27 дней назад

      Check out un-install video carefully. You can skip the un-install steps that already done by you. But you might not have deleted the directories/folders I've given in the un-install steps. So go through the video and remove the directories that exits on your computer. Once you un-install everything properly, you can start with a fresh installation. Let me know if that works.

  • @kunal5077
    @kunal5077 Месяц назад

    not working sir

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Kunal, are you getting any error message? Let me know more details so that I can help you fix the issue.

  • @shyamjeetsharma
    @shyamjeetsharma Месяц назад

    I tried but not worked

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi SHYAMJEET, Are you getting any error message? Let me know more details so that I can help you fix the issue.

    • @shyamjeetsharma
      @shyamjeetsharma Месяц назад

      @@PnTutorialsbyPradnyankurNikam how can we connect

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Try the steps given in the video, and let me know if you get any error message. I'll check your error message and provide you the solution here, as I get time.

  • @anishkulshreshtha4780
    @anishkulshreshtha4780 Месяц назад

    i forget root user password in mac - can I restore or reset it ?

  • @edrod8807
    @edrod8807 Месяц назад

    Thank you man! You're the boss! I had a few school projects I wanted to get back to and could not remember my password for the life of me.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Thank you Ed Rod for the feedback. Glad to know the video tutorial was helpful to you. If you haven't subscribe the channel, I would add more content soon. Also, check out my SQL course on Udemy If you are interested in learning SQL with MySQL database. Thanks again 😊🙏

  • @MantapJon
    @MantapJon Месяц назад

    Thanks sir

  • @AppuAbhi
    @AppuAbhi Месяц назад

    My system "Active Instances" shows red. Please suggest

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi ABHILASH, 1) Which macOS version are you using? 2) Which MySQL version did you install? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur

    • @AppuAbhi
      @AppuAbhi 27 дней назад

      @@PnTutorialsbyPradnyankurNikam It is not a fresh installation, i have tried multiple times but ended up with the error below: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 26 дней назад

      Hi Abhilash, In order to fix the issue, you'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version or older version. Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. ruclips.net/video/Y33uhgh5eOc/видео.html Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnynkur

    • @AppuAbhi
      @AppuAbhi 24 дня назад

      @@PnTutorialsbyPradnyankurNikam thanks now installation done successfully but getting “Local instance 3306 - Warning - not supported”

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 24 дня назад

      Which macOS version you are using?

  • @geraldinesalleskobilanski8357
    @geraldinesalleskobilanski8357 Месяц назад

    Excellent!! Thank you so much!

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      You are welcome, Geraldine Salles Kobilanski 😊🙏 I see you also sent me LinkedIn connect request and I accepted. Thanks for the connect request.

  • @KishoreKumar-fp6hn
    @KishoreKumar-fp6hn Месяц назад

    Thanks very much for the video. However, after successful resetting root password, I am still getting error message while loggin with new password. "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" Kindly help me resolving this issue. Thank you.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi Kishore, 1) Which macOS version are you using? 2) Which MySQL version did you install? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur

    • @KishoreKumar-fp6hn
      @KishoreKumar-fp6hn Месяц назад

      @@PnTutorialsbyPradnyankurNikam Hi Pradnyankur, Thanks for your reply I have added my replies to your questions .. 1) Which macOS version are you using? MACOS Sonoma Version 14.5 2) Which MySQL version did you install? MySQL Community Server 8.4.0 LTS [ macOS 14 (ARM, 64 bit) ] 3) Do you have any previous data in your MySQL database or it's a fresh installation? Yes, but not important Let me know if anything needed. Regards, Kishore

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi Kishore, In order to fix the issue, you'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. ruclips.net/video/Y33uhgh5eOc/видео.html Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnynkur

    • @KishoreKumar-fp6hn
      @KishoreKumar-fp6hn Месяц назад

      Hi Pradnyankur, Thanks for sharing details. In the first step which you have mentioned to uninstall MySQL part .. I could successfully uninstall MySQL from system preferences. And in the terminal, when I enter this code (sudo rm -rf /usr/local/mysql) it is asking for root password. On loging in with root password it says "Sorry, try again". This is where I am unable to login (though I am using my correct root password). Kindly help. Regards, Kishore

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Kishore, on the password prompt you are supposed to enter your computer root user password (not MySQL root user password). You can also use the remove command without sudo, like rm -rf /usr/local/mysql

  • @farsikogama6114
    @farsikogama6114 Месяц назад

    woww.. I know it is basic. But thanks sir!!

  • @B4BUNNYop
    @B4BUNNYop Месяц назад

    my sql server getting close immediately when i started the server from setting, what to do ?

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi b4bunny, Sorry for the late response. Due to weekend I was busy offline. Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur

    • @B4BUNNYop
      @B4BUNNYop Месяц назад

      ​@@PnTutorialsbyPradnyankurNikam I'm using the M3 14.5 version at the moment. When I first installed 8.4 MySQL, I was receiving this problem (ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)) But for now, I've only installed the previous version, so everything is OK. I appreciate your response.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Good to know that you were able to fix the issue on your own. Please note: sometimes the latest MySQL installer doesn't support all system configuration. In that case, it's best practice to go with previous stable release. If you need any other help feel free to ask me. I would be my best to help you ASAP.

  • @ayushsharma9158
    @ayushsharma9158 2 месяца назад

    My sql server gets active for just 2-3 seconds and then it gets stopped…What should I do now sir?

    • @B4BUNNYop
      @B4BUNNYop Месяц назад

      same to me 🥲

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam Месяц назад

      Hi Ayush and b4bunny, Sorry for the late response. Due to weekend I was busy offline. Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur

  • @Miki-fr8bu
    @Miki-fr8bu 2 месяца назад

    i have a problem that when i start mysql server from the settings, its just remain 2-3 seconds and stoped alone, it keep starting and stoping, how can i solve this sir?

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Hi Mik, I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnynkur

    • @bhuvanbopanna4564
      @bhuvanbopanna4564 Месяц назад

      I have the same problem

    • @Miki-fr8bu
      @Miki-fr8bu Месяц назад

      @@PnTutorialsbyPradnyankurNikam latest version, mysql latest version as well for mac, don’t have a previous installation. However, i found a solution that worked out, simply run this command in terminal: sudo /usr/local/mysql/support-files/mysql.server start I think turn it on it from settings does not really start it. Thanks 🙏🏽

  • @johnflanagan6367
    @johnflanagan6367 2 месяца назад

    Very helpful video! Thank you for posting!

  • @kishanpatel7334
    @kishanpatel7334 2 месяца назад

    Hi Pradnyankur. Whenever I am trying to run the mysql server it's automatically stop's running server will you please help me out for this?

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Hi Kishan, Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur

    • @kishanpatel7334
      @kishanpatel7334 2 месяца назад

      Yes Thanks a lot brother Currently I am working on Mac 14 sonoma

    • @kishanpatel7334
      @kishanpatel7334 2 месяца назад

      MySQL version - 8.4.0 LTS Mac M1 MacBook Pro 2021 version - Mac 14 sonoma I already installed before at that same problem happened. MySQL server not running at all. Thanks a lot and appreciate.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Alright, if it's a fresh installation and you don't have any data. You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8 Follow my previous video tutorial to completely remove MySQL from your computer. ruclips.net/video/Y33uhgh5eOc/видео.html Step 2: Install MySQL 8 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnynkur

    • @kishanpatel7334
      @kishanpatel7334 2 месяца назад

      I just wanted to ask you so what’s the actual reason why lastest version is not working in Mac right now?

  • @rosatendola5515
    @rosatendola5515 2 месяца назад

    hi, im can't enter my password in 12:40 can you please help me.

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Hi Rosa, * Most probably, latest MySQL version might not be supporting on your computer. I would suggest you to downgrade your MySQL version. * Checkout following tutorial to completely un-install MySQL from your computer. ruclips.net/video/PBAnWXKIps8/видео.html * Once you remove MySQL from your computer. Go to following URL, downloads.mysql.com/archives/community/ * On MySQL Product Archives page, from "Product Version", select 8.0.24 and for "Operating System" select "macOS". And download "macOS 11 (x86, 64-bit), DMG Archive" file. (Only if you are using macOS Big Sur). If you are using different version of macOS. Let me know you macOS version and I would suggest you a proper MySQL version. * Once you download dmg file, follow installation steps from this video. And it would work without any issue. Let me know if it works. If it still doesn't work, let me know your operating system version, so that I can suggest you proper MySQL version that would support your operating system. Regards, Pradnyankur

    • @rosatendola5515
      @rosatendola5515 2 месяца назад

      @@PnTutorialsbyPradnyankurNikam Hi Thanks for your answer sir Im using macOS ventura version 13.1

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Hi Rosa, Thanks for providing your system information. 1) In your case go to following page, downloads.mysql.com/archives/community/ Product Version: 8.0.33 Operating System: macOS OS Version: ARM or X86 (select based on your process) And download the "DMG Archive" file. 2) Before starting the installation, make sure you un-install previous failed/un-successful installation. Follow instructions given in this video. ruclips.net/video/Y33uhgh5eOc/видео.html 3) Now follow installation step in the given video. ruclips.net/video/11B8Ori9ArA/видео.html Let me know if it works. Regards, Pradnyankur

    • @rosatendola5515
      @rosatendola5515 2 месяца назад

      Yes it’s good now Thank you sooo much sir Be blessed!

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      You are welcome Rosa 😊🙏 If you are interested in learning SQlL, you can check out my 11 hours SQL & MySQL course on Udemy. Also feel free to subscribe to my this RUclips channel for database related tutorials. Thank you 🙏

  • @Riya_offical_channel
    @Riya_offical_channel 2 месяца назад

    Thanks 👍

  • @ackmadelfanpurnama6580
    @ackmadelfanpurnama6580 2 месяца назад

    sangat membantu bangettttt😘😘

  • @murzagaliyev
    @murzagaliyev 2 месяца назад

    what about mysql workbench?

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 2 месяца назад

      Hi Alikhan, You can download MySQL workbench separately from following link dev.mysql.com/downloads/workbench/

  • @nawwintphyu1873
    @nawwintphyu1873 3 месяца назад

    Thank you so much for sharing!

  • @StudyMail-xn1ju
    @StudyMail-xn1ju 3 месяца назад

    After installing Mysql ,when i am trying to open a new connection i am getting unsupported server & i am not able to open it Please help🥺🥺🥺

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Hi, If you are using macOS 12 then I would recommend you to try MySQL 8.0.30 Here are the steps you should follow. 1) First of all completely uninstall & remove MySQL from you computer. Follow the uninstall steps given in my another tutorial. ruclips.net/video/Y33uhgh5eOc/видео.html 2) Go to following URL, downloads.mysql.com/archives/community/ 3) On product archives page, from Product Version drop-down, select 8.0.30, 4) Then for Operating System drop-down select macOS 5) And for OS Version select either ARM (If your computer has arm processor) or X86 (for intel processor) 6) You will get a list of files. Download the DMG Archive file with large file size. Once download is complete, start the installation, and follow instructions given in this video tutorial. Let me know if it works. Regards, Pradnyankur

  • @blossomofsnow4267
    @blossomofsnow4267 3 месяца назад

    you're the only one who solved my mysql issues twice. subscribed

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Glad to know, the video tutorial was helpful to you, thanks for the sub I appreciate it 😊🙏

  • @snehasgowda8726
    @snehasgowda8726 3 месяца назад

    HI I AM gettingn error that mysqld_safe command not found

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Hi Sneha, First of all you'll have to change the directory to MySQL bin folder using, cd /usr/local/mysql/bin Then execute mysqld_safe command. Let me know if it works. Regards, Pradnyankur

  • @Finding-NEMO-14
    @Finding-NEMO-14 3 месяца назад

    amazing. Thank you

  • @aneesharaj789
    @aneesharaj789 3 месяца назад

    Thankyou so much sir . easy to understand , it took 2 hrs to find but by watching this video it makes so simple

  • @howtostepbystep3756
    @howtostepbystep3756 3 месяца назад

    Thank so much for this video...

  • @anakmit5494
    @anakmit5494 3 месяца назад

    You saved my time! thank you brother

  • @SireeshaYarlagadda-qy8li
    @SireeshaYarlagadda-qy8li 3 месяца назад

    Thank you so much sir, I will learn your udemy course

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Thank you Sireesha for the positive feedback and interest in my Udemy Course. Check out following link to get my Udemy course (includes active coupon code with discount) www.udemy.com/course/sql-tutorial-learn-sql-with-mysql-database-beginner2expert/?couponCode=970755425144C9EF6BB5

  • @armandogutierrez2880
    @armandogutierrez2880 3 месяца назад

    Very Helpful video, thanks a lot. I was decided to resign but... I saw your video is really great tool and thanks for sharing. I will look for you in Udemy thanks

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Thank you Armando for the positive feedback, I appreciate it. Glad to know the video tutorial was helpful to you. Check out following link to get my Udemy course (includes active coupon code with discount) www.udemy.com/course/sql-tutorial-learn-sql-with-mysql-database-beginner2expert/?couponCode=970755425144C9EF6BB5

  • @vipul2736
    @vipul2736 3 месяца назад

    hey bro..mera vs code DataBase connect ho raha..command Prompt ma run ho raha ha....lakin vs code ma nahi..

    • @PnTutorialsbyPradnyankurNikam
      @PnTutorialsbyPradnyankurNikam 3 месяца назад

      Hi Vipul, You'll have to instlal VS Code extension. Check out the link below. dev.mysql.com/doc/mysql-shell-gui/en/mysql-shell-for-vscode-setup.html