如何设置MySQL root用户密码lynda.com教程



在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
  1. 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)` 🙂

  2. 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

  3. 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!

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

  5. +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!

  6. 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.