MySQL HOWTO

aptitude install mysql-server-5.0 mysql-client-5.0

To set the root password for connections from localhost:

mysqladmin -u root password yourpassword

To create a login for other users from other hosts:

mysql -u root -p
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'user'@'host.example.com' IDENTIFIED BY 'password' WITH GRANT OPTION;

Kill a MySQL Process

mysql -u username -p
kill 123456

Tuning MySQL

SET GLOBAL max_connections = 200;
SHOW VARIABLES LIKE '%max_connections%';
SHOW STATUS LIKE '%qcache%';

Discussion

Enter your comment (wiki syntax is allowed):

Subscribe to the RSS feed for Andy's Debian HOWTOs

Article from Andy's Debian HOWTOs (http://www.besy.co.uk/debian/debian)

 
debian/how_to_install_and_configure_mysql.txt · Last modified: 2009/02/19 16:01 by andy · [Old revisions]
Recent changes RSS feed Powered by Debian Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki