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 can I connect to mysql? I need to update the helpdesk backend


I have got to reset the password in the MySQL helpdesk database, but I don’t know how to connect to it.


What you need to know:
- database name
- mysql root password or any user name / password combination

What is the database name?

Each database is stored in a directory, typically under

It could be a slightly different location. Try

$ mysqladmin variables | grep datadir

I suspect that your database will be named 'helpdesk'.

Don't know the mysql root password or any other login?

You can find it out by looking at the perl or php scripts that connect to it. The db connection info must be stored in some configuration file.

So, once you have the database name and the password, then you can go into the sql shell with this command at the command prompt:

$ mysql <databasename> -uroot -p<PASSWORD>

There you can enter your SQL to update helpdesk user passwords.

update staff set password='' where username='admin';

Generated 12:00:26 on Oct 27, 2020