<WRAP tabs>
  * [[:start|Accueil]]
  * [[:public:kb|KB]]
</WRAP>
====== MySQL ======

===== Commandes mysql externes =====

==== Changer un mot de passe ====

  mysqladmin -u user -p'oldpassword' password newpass

==== lister les DB ====
  mysqlshow -h localhost -u root -p


==== Se connecter ====

  mysql -h host -u user -p


==== Lister les commandes ====

  help
  
===== Commandes mysql internes =====

==== connexion====
  mysql -h localhost -u root -p
  
==== Lister les databases ====
  show databases;

==== utiliser une db précise====
  use ma_db;
  
==== lister les tables de la db ====
  show tables;