MySQL

Dieses Tutorial beschreibt wie MySQL unter Linux (Ubuntu) eigerichtet wird.

Install

sudo apt-get install mysql-server

Start / Stop

sudo /etc/init.d/mysql start
sudo /etc/init.d/mysql stop

Change Password

sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables &
mysql -u root mysql

UPDATE user SET Password=PASSWORD('newpass') WHERE User='root';
FLUSH PRIVILEGES;
exit;

PhpMyAdmin

sudo apt-get install phpmyadmin

Cache

show variables like '%cache%';
show status like 'Qc%';