I have just come to realise that mysql on centos has a user account sa and I want to remove this account or set a password on it. There is no entry in the mysql.user table so a set password statement doesn't work.
Is it possible to set a password?
mysql -u sa
will get you to a mysql> prompt with limited access.