DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

How to reset the root password on mysql


I need to reset the root password of my mysql installation to the original empty password. How can I do that?


Use the commandline tool mysqladmin - the trick is to use quotes to specify an empty password:

# go to your mysql installation
 cd /usr/local/mysql/bin
 # replace XXX with your existing root password
 ./mysqladmin -uroot -pXXX password ''

Generated 20:00:33 on Oct 23, 2020