Setting a root password for MySQL
- start your command line by going to the Start Menu > Run and typing cmd or type command if you are using an older version of windows
change your directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
- switch to mysql command line:
C:\mysql\bin> mysql -u root mysql
- then set a default password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD('theOC');
where "theOC" is the password you want to use
Adding more users
- start your command line by going to the Start Menu > Run and typing cmd or type command if you are using an older version of windows
change your directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
- switch to mysql command line (if you have not set a root password remove the -p switch):
C:\mysql\bin> mysql -u root -p mysql
- then then add your new user:
mysql> GRANT ALL PRIVILEGES ON *.* TO rachel@localhost IDENTIFIED BY 'summer';
where "rachel" is the username and "summer" is the password you want to use. you can also limit users to specific database, allow remote hosts to connect all using the GRANT statement. however, that is outside the scope of this tutorial so search for more info on using GRANT if you are interested in those features
Navigation
Introduction
Contact
HOME