Jul 20, 2008

Finding Mysql Database Password? - please help

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Finding Mysql Database Password? - please help

cse-icons
hi,
I have installed Coppermine Gallery using fantastico.
I want to bridge it with mambo. and for that configuration, I need the password for the database Coppermine uses.

Can anyone tell me how to find out the database password in this case? I tried the coppermine admin panel but could not find it there.
Does anyone know which config file does coppermine use to store database password.

I can create another user with the same permissions and use it but there must be a way to determine the password set for the databases created by fantastico?? any help would be appreciated.

Cheers.

Reply

Hamtaro
More than likely, the password for that database is the same as your Cpanel password. Unless Fantastico created a new user, which I wouldn't count on. Just try your Cpanel password and see if that works for you.

Reply

badinfluence
another way, you can query thru mySql database or phpMyadmin under site management tools..

Reply

cse-icons
QUOTE(Hamtaro @ Jun 29 2005, 06:27 PM)
More than likely, the password for that database is the same as your Cpanel password.  Unless Fantastico created a new user, which I wouldn't count on.  Just try your Cpanel password and see if that works for you.
*



Fantastico has created a new user and so the cpanel password would not work. I also tried giving permission to mambo user and using the same username for the coppermine mod but it is giving an error.
Also I donno much php.. that adds to the problem.


QUOTE(badinfluence @ Jun 29 2005, 09:32 PM)
another way, you can query thru mySql database or phpMyadmin under site management tools..
*



I did not get you, what query would give me the password to a user in the mysql database?

Cheers.

 

 

 


Reply

whyme
I haven't installed CopperMine, however, (If I'm not mistaken) the passwords are encrytped via md5 hashes(http://en.wikipedia.org/wiki/MD5) (in Mambo also.).

Therefore, you won't be able to find these "raw" password lists in your MySQL queries

You instead will find long strings of numbers and letters. (viz. d41d8cd98f00b204e9800998ecf8427e)

They are encryted by the scripts and merging Mambo and Coppermine together to share the same password would create a large compatiblity issue.

I may be wrong on this, but I am pretty sure that this is the case.

Your best solution would be to just keep these two scripts seperate.

Reply

miCRoSCoPiC^eaRthLinG
Most of these CMS/Forums/Wiki CLones - all store their DB Login/Passwords in a file called config.php - it's almost like a rule... search for some file like that in your coppermine directory.

The fie should contain just a few lines of code like:
CODE

<?php
$user = 'something'
$pass='something'
$dbname='someotherthing'
?>


If you can't spot the file, try looking into the coppermine login script - you'll get an idea what the login/pass variables are - that are used to connect to your db. You can then go a grep of your coppermine files and see if any file comes up with a matching pattern. (You need shell access for this - which you can make a request for in the hosting forum)...

Regards,
m^e

Reply

cse-icons
QUOTE(whyme @ Jul 1 2005, 02:05 AM)
I haven't installed CopperMine, however, (If I'm not mistaken) the passwords are encrytped via md5 hashes(http://en.wikipedia.org/wiki/MD5) (in Mambo also.).

Therefore, you won't be able to find these "raw" password lists in your MySQL queries

You instead will find long strings of numbers and letters. (viz. d41d8cd98f00b204e9800998ecf8427e)

They are encryted by the scripts and merging Mambo and Coppermine together to share the same password would create a large compatiblity issue.

I may be wrong on this, but I am pretty sure that this is the case.

Your best solution would be to just keep these two scripts seperate.
*



yeah, as far as pwd storage is concerned they are stored in encrypted form. so you cannot retrieve the plaintext. Moreover in mysql, the databases, tables info and users are stored in a separate database which has admin rights. I dont think we have access to browse that database.


QUOTE(microscopic^earthling @ Jul 1 2005, 02:14 AM)
Most of these CMS/Forums/Wiki CLones - all store their DB Login/Passwords in a file called config.php - it's almost like a rule... search for some file like that in your coppermine directory.

The fie should contain just a few lines of code like:
CODE

<?php
$user = 'something'
$pass='something'
$dbname='someotherthing'
?>


If you can't spot the file, try looking into the coppermine login script - you'll get an idea what the login/pass variables are - that are used to connect to your db. You can then go a grep of your coppermine files and see if any file comes up with a matching pattern. (You need shell access for this - which you can make a request for in the hosting forum)...

Regards,
m^e
*



yeah, I got it now.. I found a config.php file which included two other files from the include directory. In that there was another config file.
All this while I was looking at the config file in the root directory of my installation. Now I got the password.
Thanks

Also thanks everyone for the help..

Cheers.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : finding, mysql, database, password

  1. Is The Database System Gone Again?
    Errors on PHPMyAdmin again (9)
  2. How Do I Find My Mysql Password? [resolved]
    Cannot access my MySQL (5)
    After all the recent problems, my account has been restored. I have setup my parked domain agin, and
    that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
    that's all). I had to create a new user for my databases, and created the user with exactly the
    same username and password I had before, but some of my web pages do not let me access the pages I
    have associated with my databases. Where could i find out what my DB password is? (Although I am as
    good as sure I am using the right one). I have tried my old password, the new c....
  3. Remote Access Mysql
    (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies.....
  4. Phpmyadmin
    Create new database: No Privileges (6)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ....
  5. I Need Help Transferring Sql Database?
    (3)
    ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
    database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
    QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia`
    DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access
    denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to
    give my user all rights, but it gave me this also. QUOTE SQL query: GRANT A....
  6. My Site's Ip Address
    Finding out my numerical IP address (5)
    Hi, I was wondering how I can find the numerical IP address of my site. I have my site hosted at
    Trap 17, but instead of a subdomain i use my own (parked) domain name. Can anyone tell me how I can
    find the address of my web site in the shape of 81.200.30.55 (this is just a random example) instead
    of in the shape of http://www.vlaanderen-flanders.org.uk ? Thanks for any advice. ....
  7. Question About The Upgrade And The Mysql Usage ?
    question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
  8. Changes In Phpmyadmin
    Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ....
  9. Weird Password Problem
    Password change failed (8)
    I haven't really used my cPanel because my hosting is mainly used for a mailing list (for the
    time being). When I headr of the potential password breach I tried to log on but my attempts failed.
    I know the details are right since I saved the details in a txt file. Even more peculiar is that I
    can still log in via FTP. I tried to reset my password but got a error message stating that my
    password could not be changed. Any insight would be much appreciated.....
  10. How To Retrieve My Cpanel Password?
    (10)
    I need to get my cpanel password. I've competly lost, I normally rely on my computer to
    automatically save it. But I hadn't loged into my cpanel for ages so it had forgot all the data.
    So could one of the admins send me my password, or someone else give me a link to the password
    recovery system, cause I can't find it.....
  11. Now I Cant Change Password [resolved]
    (6)
    Since the password to my hosting account has been screwed up i tried to use alex advice on changing
    the password for the 10 credits but im getting this error: User Data Verfied Successfully!
    Changing password.. This can take time... Please be patient..(Do not hit Reload or Back) Password
    Change Failed! Wth is going on??.......
  12. My Password
    changed? (34)
    Heyhey, I just tried to log in into my cpanel, but my pass does not work anymore. Yesterday I had
    no problems logging in and I haven't changed it myself. Can I reset my pass somehow? my domain
    is http://www.ancient-armada.com ....
  13. Need Help With My Database
    I cannot transfer my old site's database (19)
    I Couldn't import my database info via Import from php my admin and i got the .sql file from the
    php my admin of my old hosting and every time i try to import it give me an error that i don't
    have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" /> What shall i do?? I need Help Please....
  14. Question About Adding Message Board To Site
    Using mysql? (5)
    Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
    how can I set up a messageboard. Thanks. std split from another topic ....
  15. Need Help Installing Smf
    It's not finding the files I upload. (5)
    I downloaded the zip version of the SMF, from www.simplemachines.org I am using SmartFTP, to upload
    the files. I created a folder, named Forum, and uploaded all the SMF files there. On the
    simplemachines site, it tells me to type my site url followed by /forum/install.php, or whatever the
    directory I installed it on is called. I tried that, and I come up with this on the page. Not
    Found The requested URL /forum/smf1.1/install.php was not found on this server. Additionally, a 404
    Not Found error was encountered while trying to use an ErrorDocument to handle the re....
  16. Installing Phpbb
    database problem (0)
    Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
    the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
    is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
    connect to the database Im not sure why this has happened as i have never really used mysql for
    ....
  17. Phpbb2.17 Mysql Problems
    Just this week they started (4)
    The forum has been up and running for about a year and a half. It has been through numerous server
    upgrades, etc, including the recent HDD change, but for some reason, just this week it started
    throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
    SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
    be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
    u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,....
  18. Database Connection Problem
    phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?....
  19. 99 Mysql Databases?
    (2)
    I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
    lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
    have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
    just prefix my tables, but I was just wondering why it would say that. If for some reason it was
    letting me get more than one database, and I wasn't supposed to, I don't want to get my
    account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m....
  20. Database Errors!
    Started after HDD change.. (5)
    Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
    refresh site, they not that often but still i get them. It says "could not connect to database". And
    i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
    database! This is a notice email to let you know that SMF could not connect to the database,
    contact your host if this continues. so i am contacting my host......
  21. Mysql Access Error[resolved]
    (5)
    The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
    never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
    Please kindly look into this.....
  22. Mysql Server Problems [resolved]
    (3)
    hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
    ERRORS, like that the server is going down so now and often is it due to my cms or is the server
    having some probs ? this is what i just saw from the statistics: QUOTE Service Status
    named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
    (5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
    Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17....
  23. Password Problems
    Please Help I can't access my CP (5)
    I have entered my password, I have reset my password and entered the new one and it still won't
    let me onto my control panel, the login box just sits there. Staring at me. I know the password I
    entered was right as it was working fine yesterday and the day before. I changed my domain name
    before the password problem. Thanks....
  24. Cpanel And Mysql Problem. [resolved]
    (3)
    hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
    to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
    ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
    loads with a blank page. however both worked earlier today. so is there a problem with the server?
    and if there is, will it be fixed?....
  25. Lost Ftp Password Somehow?
    (3)
    In my FTP program I save all my settings for logging in to my site. So when I went to log in and it
    said the password was wrong I was pretty suprised. I don't remember messing with my log in
    information and I use the same password for basically everything. I need to know how to reset my FTP
    password. Can anybody help?....
  26. Is It Possible To Access The Mysql Remotely?
    (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?....
  27. How To Crate Mysql Database?
    urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ....
  28. Installing Apache, Mysql, Phpmyadmin Locally
    Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
  29. Windows Xp Pro
    Password Help (6)
    I lost my admin's password. I have Windows XP Pro, Can anyone tell me how to recover my Admins
    Password!!....
  30. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....

    1. Looking for finding, mysql, database, password

Searching Video's for finding, mysql, database, password
Similar
Is The
Database
System Gone
Again? -
Errors on
PHPMyAdmin
again
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Remote
Access Mysql
Phpmyadmin -
Create new
database: No
Privileges
I Need Help
Transferring
Sql
Database?
My
Site's
Ip Address -
Finding out
my numerical
IP address
Question
About The
Upgrade And
The Mysql
Usage ? -
question
about the
upgrade and
the mysql
usage?
Changes In
Phpmyadmin -
Access to my
database
from program
not working
anymore.
Weird
Password
Problem -
Password
change
failed
How To
Retrieve My
Cpanel
Password?
Now I Cant
Change
Password
[resolved]
My Password
- changed?
Need Help
With My
Database - I
cannot
transfer my
old
site's
database
Question
About Adding
Message
Board To
Site - Using
mysql?
Need Help
Installing
Smf -
It's not
finding the
files I
upload.
Installing
Phpbb -
database
problem
Phpbb2.17
Mysql
Problems -
Just this
week they
started
Database
Connection
Problem -
phpBB2
installation
error
99 Mysql
Databases?
Database
Errors!
- Started
after HDD
change..
Mysql Access
Error[resolv
ed]
Mysql Server
Problems
[resolved]
Password
Problems -
Please Help
I can't
access my CP
Cpanel And
Mysql
Problem.
[resolved]
Lost Ftp
Password
Somehow?
Is It
Possible To
Access The
Mysql
Remotely?
How To Crate
Mysql
Database? -
urgent help
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
Windows Xp
Pro -
Password
Help
Mysql
Database
Setup :
Setting Up
Mysql
Database -
Guide to use
MySQL
database in
your site
advertisement



Finding Mysql Database Password? - please help



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE