79437

Assigning Anonymous Account Passwords

The mysql commands in the following instructions include a -p option based on the assumption that

you have set the root account passwords using the preceding instructions and must specify that password when connecting to the server.

To assign passwords to the anonymous accounts, connect to the server as root, then use either set

PASSWORD or UPDATE. Be surę to encrypt the password using the PASSWORD () [1283] function.

To use set password on Windows, do this:

shell>raysql -u root -p

Enter password:    (enter root password here)

mysql>SET PASSWORD FOR * ' 6 ' localhost' = PASSWORD (' newptrd') ;

To use set password on Unix, do this:

Shell>rnysql -u root -p

Enter password:    (enter root password here)

mysql>SET PASSWORD FOR ''6'localhost' = PASSWORD('newpwd'); mysql>SET PASSWORD FOR ' ' 6 ' host_name' = PASSWORD (' newpwd') ;

To set the anonymous-user account passwords with a single update

statement, do this (on any

platform):

shell>mysql -u root -p

Enter password:    (enter root password here)

mysql>UPDATE mysql.user SET Password = PASSWORD('newpwd')

->WHERE User inysql>FLUSH PRIVILEGES;

The flush statement causes the sen/er to reread the grant tables.

Without it, the password change

remains unnoticed by the server until you restart it.