- log onto your system from a command-line interface (Terminal)
- move to the mysql/bin or just mysql directory, depending upon your O/S
ex.:
cd /usr/local/mysql/bin ( Unix )
or
cd c:\mysql\bin ( Windows )
- enter the following, replacing thepassword with the password you want to use
syntax:
mysqladmin -u root password 'thepassword'
ex.:
mysqladmin -u root password destiny
keep in mind that passwords within MySQL are case-sensitive, so Kazan and kazan are not interchangeable. The term password that precedes the actual quoted password tells MySQL to encrypt that string
|