All categories
Add new FAQ
Add question
Open questions
Login
Sign up
Login
Search
Advanced search
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
17988 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
17623 views
How to show MySQL version?
just run this query: select version();
17504 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
17738 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
18329 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
19578 views
Daemon
MySQL
mysql tips and tricks
Subcategories