dark

如何設置MySQL root用戶密碼lynda.com教程

Total
0
Shares
0
0
0



在http://www.lynda.com/MySQL-5-tutorials/installing-apache-mysql-and-php/77958-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-lynda-77958上免費觀看整個課程-0205。本教程演示了如何在Mac OS X上創建MySQL root用戶密碼。

該特定教程只是lynda.com作者David Gassner提出的「安裝Apache，MySQL和PHP」課程第二章的一部電影。完整的安裝Apache，MySQL和PHP課程總共需要2個小時5分鐘，並且描述了如何在本地開發計算機上安裝和執行Apache，MySQL和PHP的初始配置。

安裝Apache，MySQL和PHP目錄：

介紹
1.在Windows上安裝單獨的組件
2.在Mac OS X上安裝單獨的組件
3.在Windows上安裝WampServer
4.在Mac OS X上安裝MAMP
5.安裝XAMPP
6.安裝BitNami
7.故障排除
結論。

19 comments

  3. Good tutorial, but be aware of `ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)` or `ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)` 🙂

  5. MacBook-de-Miguel:bin Miker$ ./mysql -u root
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    I cant get that point

  6. Hey guys! I found my own, fast way to change password.

    1. Navigate to the MySQL bin folder (my path to this folder is "C:Program FilesMySQLMySQL Server 5.7bin")
    2. Open Command Window there like this:
    2.1. Hold SHIFT and right click on empty space in the bin folder
    2.2. Select "Open command window here"
    3. Write this command:
    mysqladmin.exe -u root -p password
    4. Write your old password and it will prompt you to enter new password and to confirm it

    I hope this helps 🙂
    (if it does, please like it so more people see it 🙂 )
    Cheers!

  10. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). Does anyone know the solution please?

  13. +Thainá Rodrigues ANYONE help please! I use Mac and installed mysql and didn't not jot down the temporary password, and now trying to set up or reset password.

    So, stuck at 1.24 of this video.

    after ls

    I type in the terminal

    ./mysql -u root
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Orujs-MacBook-Pro:bin orujgadimov$

    or if continue with the video and type in the following step; it gives me this

    ./mysqladmin -u root password 'password'
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    Orujs-MacBook-Pro:bin orujgadimov$

    I am stuck at this for days and would be very grateful if anyone could jump in and help. I am very new with MySQL. Thanks million beforehand!

  18. Thank you! I had been struggling a while with my passwords and could not find clear instructions to fix them/get them set up. Thanks for being so clear! 

Comments are closed.