InterBase (28)
MS-SQL (5)
mysql (36)
Oracle (1)
Exchange Links
About this site
How can I connect to mysql? I need to update the helpdesk backend
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:
I have got to reset the password in the MySQL helpdesk database, but I don’t know how to connect to it.Answer:
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
/var/lib/mysql/<databasename>
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';
Comments: