Jump to content

How to open the mysql in Tommy with Cpanel out.


fuzmic

Recommended Posts

Hi guys

I only know how to use FTP to view the website files.  Thus i don't see the mysql\data files. 

So is there any where to view/edit the tables/records in my mysql when we don't have cpanel's phpadmin.  

Link to comment
Share on other sites

Wolstech Bro

I have a phpmyadmin running in the local host, but i have no clue how to get to Tommy .. i think i am missing a few steps here.  Please enlighten.

Link to comment
Share on other sites

Oh I see .. Thank you bro.

One more mental block .. what is phpmyadmin look like to be uploaded or better still take me there to get it .. a lesson for me .. Salutations

Link to comment
Share on other sites

I am ALMOST THERE i think.  Thus if the index.php is in the public_html/phpMyAdm/setup, browsing peace2u.heliohost.org/phpMyAdm/setup/index.php will open the phpMyAdmin but still not there yet, still need my patient friends to get me across; the familiar cpanel phpMyAdmin interface is not showing.

I set the server to localhost but as the server holds all other database and users, here my question

Do i use the username and password in my configuration.php (not root & no password)

What else is missing to show up my database and tables.  Please help.

 

almostThere.jpg

almostThere2.jpg

Edited by fuzmic
higher in the ladder
Link to comment
Share on other sites

The auth section of the PMA config.inc.php on lily looks like this, and it should work on Tommy too since the server is localhost there as well. There is no username or password line at all. Change the blowfish secret line to 32 random characters.

/**
 * This is needed for cookie based authentication to encrypt password in
 * cookie. Needs to be 32 chars long.
 */
$cfg['blowfish_secret'] = '12345678901234567890123456789012'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/**
 * Servers configuration
 */
$i = 0;

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...