Add new FAQ
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
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
How to show MySQL version?
just run this query: select version();
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
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
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
mysql tips and tricks