McAfee® Network Security Platform 6.0
Hardening the Manager Server for Windows 2003
7
Remove test database
Remove the ‘test” database from the server.
1. Start My SQL.
mysql> use mysql;
2. Backup db table to do
dbbackup before changing it.
mysql> create table db_backup as
select * from db;
3. Validate that the backup table
was created and row count
matches that of the mysql.db table.
mysql> select count(*) from
db_backup;
4. Check all the databases on the
Manager server.
mysql> show databases;
5. Remove the test db, Keep only
the MYSQL and Network Security
Platform (for example, lf)
databases.
mysql> drop database test;
6. You should see only two
databases (MYSQL and LF) if you
are using the default Network
Security Platform installation of
MySQL.
mysql> show databases;
Remove local anonymous users
To remove local anonymous users:
1. Look for blank entries for user.
mysql> select host,db,user from db;
2. Remove anonymous access to databases
mysql> update db set
host="localhost" where user="";
3. Remove anonymous/blank accounts
mysql> flush privileges;
4. Validate that “localhost” replaced % entry
under the host column. You will also notice
you will now need to qualify username and
password on the local machine to get into
mysql shell from the mysql.exe CLI.
Remove remote anonymous users
To remove remote anonymous users, you harden mysql.exe CLI access by forcing the
requirement for a username and password to get into the mysql shell as follows.
