Linux + MySQL

apt-get -y install mysql-server

mysql -u root -p

mysql -u root -p --xml                                 = XML output 

ls /var/cache/apt/archives/                           = apt-get autoclean

show databases

use mysql;

selsect user, host from user;

update user set password = password('parole') where user = 'root' limit 3;  = paroles maiņa

exit or quit 

flush privileges;

exit

apt-get install mysql-admin                         = GUI

sqlyog = sql admin for Windows

paroles atjaunoana, bez tikla reima 

1. stop mySql serveri 

/etc/init.d/mysql stop

2. 

/usr/sbin/mysqld --skip-grant-tables --skip-networking &

3. 

mysql -u root                                         = bez paroles

4.

update user set password = password('parole') where user = 'root' limit 3;  = paroles maiņa

5.

flush privileges;

6.

Quit

7.

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