Login

SELECT User,Password,Host FROM mysql.user;

CREATE USER user;

SET PASSWORD FOR 'user'@'host' =PASSWORD('yourpassword');

GRANT ALL ON *.* TO 'user'@'host';

==Delete User==
<code>DELETE FROM mysql.user WHERE User='user' AND Host='host';

 mysqldump -u username --password=thepassword thedatabase > thedatabase.sql

Binary logs can become quite large in MySQL, so unless database replication is running, it's often best to reduce the default logging.

in /etc/mysql/my.cnf reduce the length of time logs are stored for.

expire-log-days 3

If logs have built up, they can be removed from mysql command line

PURGE MASTER LOGS TO 'mysql-bin.010';

or

PURGE MASTER LOGS BEFORE '2003-04-02 22:46:26';