Finding Mysql Database Password? - please help

free web hosting
Free Web Hosting, No Ads > General > Hosted Members Area

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. Mysql Database Not Working - (3)
  2. Ips Installer Database Details [resolved] - It wont accept localhost... (6)
    CODE Access denied for user 'skyed211_central'@'localhost' to database
    'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
    not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
    this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" />...
  3. Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site (6)
    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...
  4. Phpmyadmin - Create new database: No Privileges (7)
    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 Think I Need A Cpan Password Reset - (0)
    Hi guys, been a while since ive been around, luckily i build up a nice amount of credits so im still
    actively hosted. But Ive forgotten my cpanel password, im pretty sure i still know my username but i
    need to get my password reset. I couldnt find the automatic way to do this so i thought id throw up
    a post and hope someone can give me a linky or do it for me. Im assuming itll still cost me 10
    credits which is fine. So if anyone is able to start the process off go for it, i can afford the 10
    credits to do it /smile.gif" style="vertical-align:middle" emoid=":)" border="...
  6. It Went Well For A While - MySQL problem back in all its glory. (5)
    Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
    website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
    effect. File(include/errors.xml) is not within the allowed path(s):
    (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
    fopen(include/errors.xml) : failed to open stream: Operation not permitted in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
    incl...
  7. Is The Database System Gone Again? [resolved] - Errors on PHPMyAdmin again (12)
    I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
    again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
    failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
    Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
    current setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca...
  8. 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...
  9. 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....
  10. 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?...
  11. 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...
  12. 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...
  13. 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. ...
  14. 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!!...
  15. 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 ...
  16. 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 ...
  17. 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....
  18. 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....
  19. 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 ...
  20. 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??......
  21. 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: ...
  22. 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...
  23. 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 ...
  24. 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...
  25. 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
    ...
  26. 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,...
  27. 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?...
  28. 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.....
  29. 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...
  30. 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....



Looking for finding, mysql, database, password

Searching Video's for finding, mysql, database, password
Mysql
Database Not
Working
Ips
Installer
Database
Details
[resolved]
It wont
accept
localhost...
Mysql
Database
Setup :
Setting Up
Mysql
Database
Guide to use
MySQL
database in
your site
Phpmyadmin
Create new
database: No
Privileges
I Think I
Need A Cpan
Password
Reset
It Went Well
For A While
MySQL
problem back
in all its
glory.
Is The
Database
System Gone
Again?
[resolved]
Errors on
PHPMyAdmin
again
How Do I
Find My
Mysql
Password?
[resolved]
Cannot
access my
MySQL
Remote
Access Mysql
Is It
Possible To
Access The
Mysql
Remotely?
I Need Help
Transferring
Sql
Database?
Installing
Apache,
Mysql,
Phpmyadmin
Locally
Solving the
"php_mb
string.dll
missing"
;
My
Site's
Ip Address
Finding out
my numerical
IP address
Windows Xp
Pro Password
Help
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?
My Password
changed?
Now I Cant
Change
Password
[resolved]
How To Crate
Mysql
Database?
urgent help
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
Database
Errors!
Started
after HDD
change..
99 Mysql
Databases?
Mysql Access
Error[resolv
ed]
advertisement



Finding Mysql Database Password? - please help



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free 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