| View previous topic :: View next topic |
| Author |
Message |
hamzie
-
Joined: 09 Aug 2006
Posts: 6
|
 Posted: Wed Aug 09, 2006 3:38 pm Post subject: phpmyadmin password problem |
 |
|
Im about to launch my new site using e107 powered by AWS x1, but im still having problem securing phpmyadmin. Everyone can view my phpmyadmin site even if i have set config.inc.php to use cookie and password. You only need to put username even w/o pass and everyone can enter.
Here's my config.inc.php
| Quote: | $cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'mypassword'; // MySQL password (only needed
// with 'config' auth_type)
|
okay i openned WinMySQLadmin/my.ini Setup to verify if i have placed a mysql password
| Quote: | #This File was made using the WinMySQLAdmin 1.4 Tool
#8/7/2006 3:35:49 AM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
#bind-address=192.168.0.1
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=mypassword |
what did i miss?
Last edited by hamzie on Wed Aug 09, 2006 6:34 pm; edited 1 time in total |
|
| Back to top |
  |
 |
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Wed Aug 09, 2006 4:31 pm Post subject: |
|
|
You did not set a password for MySQL. You should use phpMyAdmin to set a password for the root account.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
 |
|
hamzie
-
Joined: 09 Aug 2006
Posts: 6
|
| Posted: Wed Aug 09, 2006 6:32 pm Post subject: |
|
|
Thx for the quick reply and it did solve the problem using phpmyadmin to add/change a password by editing privileges/root.
Its kind of odd because i did make a root password when i intalled mysql and i can see my password at WinMySQLadmin/my.ini Setup. Maybe i messed up my db when i uninstalled mysql,php, phpmyadmin, etc. and not deleting the remaining files.
Again thanks for the reply and more power to abyss web server. |
|
| Back to top |
|
|
|
