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.

Articles:

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

Question:

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

Answer:

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 8:00:31 on Jun 27, 2017