Posted on Leave a comment

MySQL, faq

my.ini
[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mydata/data
initialize
mysqld.exe –initialize

start

mysqld.exe --console

shutdown

mysqladmin -u root shutdown

connect in another cmd window

mysql.exe -u root -p password

change password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';