Login

You are currently not logged in! Enter your authentication credentials below to log in. You need to have cookies enabled to log in.

You don't have an account yet? Just get one: Register

Forgotten your password? Get a new one: Send new password

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';

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