Questions in MySQL

• How to change MySQL user password?

  Connect to your database and run the following command: update mysql.user set password=PASSWORD("ENTER-PASSWORD-HERE") where User='ENTER-USERNAME';  After that you might want to
  29111 views
• How to recover the MySQL root password?

  Well, this happens from time to time and is actually easy to fix, so here you are: /etc/init.d/mysql stopmysqld_safe --skip-grant-tables & mysql
  28857 views
• How to show MySQL version?

  just run this query: select version();
  28446 views
• How do I convert / change / delete more then one MySQL table?

  Well, a quite simple task but still with a few dozen tables this might become quite some work in phpMyAdmin
  28460 views
• How do I install MySQL 4.1 on Debian Etch / Debian 4.0?

  Hi Folks,I ran into that problem and here is a quite easy solution, thanks to www.mytso.net:   edit /etc/apt/sources.list add the following line: deb
  30251 views
• How to create MySQL dumps?

  As you have to move a MySQL database from one server to another you might run into troubles. Tools like
  30877 views

Daemon