DelphiFAQ Home Search:

How can I connect to mysql? I need to update the helpdesk backend

 

commentsThis 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:

2014-12-17, 00:09:27
anonymous from United States  
Hello wanted to give you a fast mangaes. The text inside your article seem to be operating off the display in Internet explorer. Im not confident that this can be a format problem or something like that related to internet browser compatibility but I thought Id publish to let you know. The look look great though! We do hope you obtain the issue solved quickly. Many thanks
2015-01-02, 01:09:13
anonymous from Bell, United States  
I guess finding useful, reliable inoarmotifn on the internet isn't hopeless after all. http://pwnsvvulrjv.com [url= http://vjwsijsc.com..ijsc[/url] [link= http://baxzulomh.co..omh[/link]
2015-01-02, 01:09:13
anonymous from Bell, United States  
I guess finding useful, reliable inoarmotifn on the internet isn't hopeless after all. http://pwnsvvulrjv.com [url= http://vjwsijsc.com..ijsc[/url] [link= http://baxzulomh.co..omh[/link]
2015-02-01, 00:09:54
anonymous  
I really coldnu't ask for more from this article.

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: