Jupyter Magic SQL
%load_ext sql
%sql mysql://root:password@localhost/sakila
%sql select * from actor
%sql mysql://root:password@localhost/sakila
%sql select * from actor
Reset root password on MySQL on Windows 10 laptop
Stop SQL Server Create a text file "mysql-init.txt" in C:\temp directory and paste in this content ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; Open a command prompt window and run this command mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file="C:\\temp\\mysql-init.txt"
Comments
Post a Comment