Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : PHP MY Admin

[lemonox]

Hey Guys...

Few weeks ago I purchased a dedicated server. I Installed PHP and MY SQL. Now I need to Install a PhpMyAdmin. I'm bit confused with phpmyadmin. Please help me to install Phpmyadmin.

I want to Install Phpmyadmin on IIS ( Windows Server )

Kind Regards
Jenny
Lemonox

[SevenL_Networks]

Where exactly are you getting stuck? Installing phpmyadmin is fairly straight-forward as it's all php. There are only one or two configuration files that you need to enter MySQL details into.

Have you checked out the documentation for PHPMyAdmin yet?

[lemonox]

Hey SevenL_Networks..

Thanks for your reply. Can you provide me some Video Tutorial Links or Guide links for Phpmyadmin.

I'm waiting 4 ur reply.

Best Regards
jenny

[Techno]

Are you using a Control panel like Cpanel, DirectAdmin or Plesk? PhpMyAdmin should be included in their distribution packages.

[lemonox]

Don't you have Yahoo Messenger, MSN, Or Skype , Google Talk. If you have please let me know. I can Talk with you.

Kind Regards
Jenny

[lemonox]

Hi Thanks for your reply. I'm using Helm3.

Originally Posted by Techno

Are you using a Control panel like Cpanel, DirectAdmin or Plesk? PhpMyAdmin should be included in their distribution packages.

[trix909]

Phpmyadmin is quite unsecure.
I suggest adding extra security to your config.inc.php

[mihd]

Use Navicat and connect to the DB server via SSH....

[arun_kris]

Pls try this & this is esp for helm-

Pls download the latest copy from www.phpmyadmin.net - and then extract it, upload it all onto your website or server in a folder named phpmyadmin, edit the file named config.inc.php and then edit this line which is on line no 39

$cfg['PmaAbsoluteUri'] = '';

and put in your absolute url address to the phpmyadmin folder. for example mine is

$cfg['PmaAbsoluteUri'] = 'http://yourdomain.com/phpmyadmin/';

then go to line 60 and edit this line

$cfg['blowfish_secret'] = '';

change that to

$cfg['blowfish_secret'] = '-';

then go to line 69

and enter your settings. Put in your server ip, or localhost if the files are on the server you wish to use. Put in your port if you use one,but leave it blank as default.

Mine looks like this:-

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection


Then on line 75 and 77 enter your controluser and controlpass if you know what they are, if you don't know simple leave these blank. It will work just aswell without them, as they are for http secure logins.So i leave mine blank.

Then on line 82 of the confic.inc.php edit that line by doing this:

change

$cfg['Servers'][$i]['auth_type'] = 'config';

to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

leave the user and password below that as they are... mine looks like this

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

Also you may want to consider doing this, after you have created this and got your url to it, say http://yourdomain.com/phpmyadmin then you should login into helm as admin, and go to:-

Home > System Settings > Servers > yourservername > MySQL

That is of course assuming you have installed MySql. Then in there for the connection info field put this in...

Click Here to manage Database.

Where yourdomain.com is your domain etc...

This will mean that when a user creates a mysql database and adds users instead of saying please contact your administrator for the connection info, it will give them a link to phpmyadmin were they can login.

Hope this helps

Thanks,
Arun

[arun_kris]

Also you can connect thro' third party MySQL connector tools like MySQL Administrator, SQL Yog, Navicat etc.. And this doesn't requires any additional setup in helm. Any user can connect to your MySQL directly thro' MySQL connector tools.

Thanks,
Arun

[lemonox]

Hey Guys.


I want to thanks for all. Now I got a Error.

Please check this

http://67.18.248.98/phpmyadmin/index.php

Kind regards

[arun_kris]

Is the MySQL extension enabled in php.ini file? If not pls search for

;extension=php_mysql.dll

and uncomment it by removing ';' (Semi colon), so it looks like-

extension=php_mysql.dll

Thanks,
Arun

[lemonox]

Hi Arun

Still same error. Have to change php.ini on Windows Folder or C drive?

Regards
Jenny

Originally Posted by arun_kris

Is the MySQL extension enabled in php.ini file? If not pls search for

;extension=php_mysql.dll

and uncomment it by removing ';' (Semi colon), so it looks like-

extension=php_mysql.dll

Thanks,
Arun

[arun_kris]

Yes, correct. You can find the path to php.ini by creating info.php-

<?
phpinfo();
?>

under phpmyadmin folder and access it through-

http://67.18.248.98/phpmyadmin/info.php

Thanks,
Arun

[lemonox]

Arun

Once I type http://67.18.248.98/phpmyadmin/info.php

its The page cannot be found.

Thanx

jenny

Originally Posted by arun_kris

Yes, correct. You can find the path to php.ini by creating info.php-

<?
phpinfo();
?>

under phpmyadmin folder and access it through-

http://67.18.248.98/phpmyadmin/info.php

Thanks,
Arun