[PHP] phpMyAdmin : password and user (Help)

[Iguider]

Hi
Please I need a help, I used to work with asp and now I am migrating to php, my site 
web works perfectly on my PC (windows). I am runing phpMyAdmin 2.2.6,  and easyphp on 
local machine . 
when my host give me a username and password, I want to change the file 
phpMyAdmin/config.inc.php  from user=root to user=username and from password=  
 to password=password, the phpMyAdmin show me Host 'localhost' is not allowed to 
connect to this MySQL server even if i setup the default values.


the phpMyAdmin/config.inc.php is :
$cfgServers[$i]['host']  = 'localhost'; // MySQL hostname
$cfgServers[$i]['port']  = '';  // MySQL port - leave blank for 
default port
$cfgServers[$i]['socket']= '';  // Path to the socket - leave blank 
for default socket
$cfgServers[$i]['connect_type']  = 'tcp';   // How to connect to MySQL server 
('tcp' or 'socket')
$cfgServers[$i]['controluser']   = '';  // MySQL control user settings
// (this user must have read-only
$cfgServers[$i]['controlpass']   = '';  // access to the mysql/user
// and mysql/db tables)
$cfgServers[$i]['auth_type'] = 'config';// Authentication method (config, http 
or cookie based)?
$cfgServers[$i]['user']  = 'root';  // MySQL user
$cfgServers[$i]['password']  = '';  // MySQL password (only needed
// with 'config' auth_type)
$cfgServers[$i]['only_db']   = '';  // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
$cfgServers[$i]['verbose']   = '';  // Verbose name for this host - leave 
blank to show the hostname
$cfgServers[$i]['bookmarkdb']= '';  // Bookmark db - leave blank for no 
bookmark support
$cfgServers[$i]['bookmarktable'] = '';  // Bookmark table - leave blank for no 
bookmark support
$cfgServers[$i]['relation']  = '';  // table to describe the relation 
between links (see doc)
//   - leave blank for no 
relation-links support

$i++;
$cfgServers[$i]['host']  = '';
$cfgServers[$i]['port']  = '';
$cfgServers[$i]['socket']= '';
$cfgServers[$i]['connect_type']  = 'tcp';
$cfgServers[$i]['controluser']   = '';
$cfgServers[$i]['controlpass']   = '';
$cfgServers[$i]['auth_type'] = 'config';
$cfgServers[$i]['user']  = 'root';
$cfgServers[$i]['password']  = '';
$cfgServers[$i]['only_db']   = '';
$cfgServers[$i]['verbose']   = '';
$cfgServers[$i]['bookmarkdb']= '';
$cfgServers[$i]['bookmarktable'] = '';
$cfgServers[$i]['relation']  = '';

$i++;
$cfgServers[$i]['host']  = '';
$cfgServers[$i]['port']  = '';
$cfgServers[$i]['socket']= '';
$cfgServers[$i]['connect_type']  = 'tcp';
$cfgServers[$i]['controluser']   = '';
$cfgServers[$i]['controlpass']   = '';
$cfgServers[$i]['auth_type'] = 'config';
$cfgServers[$i]['user']  = 'root';
$cfgServers[$i]['password']  = '';
$cfgServers[$i]['only_db']   = '';
$cfgServers[$i]['verbose']   = '';
$cfgServers[$i]['bookmarkdb']= '';
$cfgServers[$i]['bookmarktable'] = '';
$cfgServers[$i]['relation']  = '';

[PHP] phpMyAdmin 2.2.6

[Iguider]

Hi
I am running normally a phpMyAdmin 2.2.6, until yesterday it shows me :
Host 'localhost' is not allowed to connect to this MySQL server

please help

Re: [PHP] phpMyAdmin please help

[Iguider]

Hi
thanks a lot John Nichel and Stephan , I understand now. I put blank in
password and it works.
thanks.
but after that in the next day (as I said my previous email) : Mysql stop
working and shows  : Host 'localhost' is not allowed to connect to this
MySQL server

thanks for help

- Original Message -
From: John Nichel [EMAIL PROTECTED]
To: Iguider [EMAIL PROTECTED]
Cc: PHP List [EMAIL PROTECTED]
Sent: Tuesday, November 12, 2002 12:20 AM
Subject: Re: [PHP] phpMyAdmin please help


 See below

 Iguider wrote:
  in my dtabase.php :
  $dbHost = ;
  $dbUser = Amazigh;
  $dbPassword = mcamca;
  $dbName = Forum;
  $db = mysql_connect($dbHost, $dbUser, $dbPassword);
  mysql_select_db($dbName, $db);

 $dbHost is empty.  If the script is on the same machine as the MySQL db,
 set it to localhost.  If the script is on a different machine, set it
 to the name of that machine (and make sure that your $dbUser has rights
 to access the database remotly).  MySQL usernames and passwords are case
 sensitive.

  and in phpMyAdmin's config.inc.php :
 
  $cfgServers[$i]['user']  = 'root';  // MySQL user
  $cfgServers[$i]['password']  = '';  // MySQL password

 If you have a root password, fill it in.  Seeing that it won't let you
 connect via phpMyAdmin, the db probably has a root password.

  - Original Message -
  From: Stephen [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Cc: PHP List [EMAIL PROTECTED]
  Sent: Monday, November 11, 2002 10:14 PM
  Subject: Re: [PHP] phpMyAdmin please help
 
 
 
 You may also want to check your forum's database.php after checking the
 phpMyAdmin's config.inc.php.
 
 
 - Original Message -
 From: John Nichel [EMAIL PROTECTED]
 To: Iguider [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, November 11, 2002 4:47 PM
 Subject: Re: [PHP] phpMyAdmin please help
 
 
 
 Look at the config.inc.php file in the phpMyAdmin install directory.
 
 Iguider wrote:
 
 Hi
 I have a furom working under php 4.0  and when I upgrade it to php 4.2
 
 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is
 2.2.6 .
 
 when I run the forum or I tried to re-create a tables in mySQL
 
  database
 
 with a install.php it shows me the following errors :
 
 Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program
 
 files\easyphp\www\forum\database.php on line 7
 
 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL'
 
  (22)
 
 in e:\program files\easyphp\www\forum\database.php on line 7
 
 Warning: mysql_select_db(): supplied argument is not a valid
 
  MySQL-Link
 
 resource in e:\program files\easyphp\www\forum\database.php on line 8
 
 are there in phpMyAdmin where to give a database username and password
 
  ?
 
 when I copy the old database and i try to start the forum it shows me
 
  acces
 
 denied to  name@localhost  (password : ok) .
 
 Please help
 
 
 
 
 
 
 --
 By-Tor.com
 It's all about the Rush
 http://www.by-tor.com
 
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 __
 Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo !
 Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w
 
 
 
  __
  Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo !
  Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w
 
 


 --
 By-Tor.com
 It's all about the Rush
 http://www.by-tor.com


 __
 Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo !
 Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w



__
Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! 
Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] phpMyAdmin please help

[Iguider]

Hi
I have a furom working under php 4.0  and when I upgrade it to php 4.2  by installing 
the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 .
when I run the forum or I tried to re-create a tables in mySQL database  with a 
install.php it shows me the following errors :

Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program 
files\easyphp\www\forum\database.php on line 7

Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program 
files\easyphp\www\forum\database.php on line 7

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in 
e:\program files\easyphp\www\forum\database.php on line 8

are there in phpMyAdmin where to give a database username and password ? when I copy 
the old database and i try to start the forum it shows me acces denied to  
namelocalhost  (password : ok) .
Please help


 

Re: [PHP] phpMyAdmin please help

[Iguider]

in my dtabase.php :
$dbHost = ;
$dbUser = Amazigh;
$dbPassword = mcamca;
$dbName = Forum;
$db = mysql_connect($dbHost, $dbUser, $dbPassword);
mysql_select_db($dbName, $db);

and in phpMyAdmin's config.inc.php :

$cfgServers[$i]['host']  = 'localhost'; // MySQL hostname
$cfgServers[$i]['port']  = '';  // MySQL port - leave blank
for default port
$cfgServers[$i]['socket']= '';  // Path to the socket -
leave blank for default socket
$cfgServers[$i]['connect_type']  = 'tcp';   // How to connect to MySQL
server ('tcp' or socket')
$cfgServers[$i]['controluser']   = '';  // MySQL control user
settings
// (this user must have
read-only
$cfgServers[$i]['controlpass']   = '';  // access to the
mysql/user
// and mysql/db tables)
$cfgServers[$i]['auth_type'] = 'config';// Authentication method
(config, http or cookie based)?
$cfgServers[$i]['user']  = 'root';  // MySQL user
$cfgServers[$i]['password']  = '';  // MySQL password (only
needed
// with 'config' auth_type)
$cfgServers[$i]['only_db']   = '';  // If set to a db-name, only

thanks


- Original Message -
From: Stephen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: PHP List [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 10:14 PM
Subject: Re: [PHP] phpMyAdmin please help


 You may also want to check your forum's database.php after checking the
 phpMyAdmin's config.inc.php.


 - Original Message -
 From: John Nichel [EMAIL PROTECTED]
 To: Iguider [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, November 11, 2002 4:47 PM
 Subject: Re: [PHP] phpMyAdmin please help


  Look at the config.inc.php file in the phpMyAdmin install directory.
 
  Iguider wrote:
   Hi
   I have a furom working under php 4.0  and when I upgrade it to php 4.2
 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is
 2.2.6 .
   when I run the forum or I tried to re-create a tables in mySQL
database
 with a install.php it shows me the following errors :
  
   Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program
 files\easyphp\www\forum\database.php on line 7
  
   Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL'
(22)
 in e:\program files\easyphp\www\forum\database.php on line 7
  
   Warning: mysql_select_db(): supplied argument is not a valid
MySQL-Link
 resource in e:\program files\easyphp\www\forum\database.php on line 8
  
   are there in phpMyAdmin where to give a database username and password
?
 when I copy the old database and i try to start the forum it shows me
acces
 denied to  name@localhost  (password : ok) .
   Please help
  
  
  
  
 
 
  --
  By-Tor.com
  It's all about the Rush
  http://www.by-tor.com
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


 __
 Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo !
 Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w


__
Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! 
Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Fw: esayphp

[Iguider]

Hi
I have installed esayphp v 1.4.0.0 on my pc  (windows 98) . How can I know the version 
of PHP and of mysql ?

Thanks

Re: [PHP] Fw: esayphp

[Iguider]

thanks a lot

- Original Message -
From: Maxim Maletsky [EMAIL PROTECTED]
To: Iguider [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 10:48 PM
Subject: Re: [PHP] Fw: esayphp



 ? phpinfo(); ?

 --
 Maxim Maletsky
 [EMAIL PROTECTED]


 On Sun, 10 Nov 2002 22:42:59 - Iguider [EMAIL PROTECTED] wrote:

 
 
  Hi
  I have installed esayphp v 1.4.0.0 on my pc  (windows 98) . How can I
know the version of PHP and of mysql ?
 
  Thanks


 __
 Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo !
 Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w


__
Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! 
Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] how to redirect from one page to an other page in PHP ?

[Iguider]

Hi

please how to redirect from one page to an onther in php ?  ( like it is in ASp : 
redirect(../index.asp)
exemple 
switch (condition1) {
case 1;
   go to page page1.php;
case 2;
   go to page page2.php;
}

thanks in advance

[PHP] borders in dreamwever please Help

[Iguider]

Hi
I setup Easy php on my PC (windows 98) , I try to use dreamweaver 4.0 to
make borders as it is done with frontpage. I used (SSI ) like that  :
!--#include virtual=/OnLine/borders/Left/left.htm --
but the pb the borders (top , left  and bottom.htm) appears in my
dreamweaver but in local host they don't appear (the local host is apache
1.3.20 )
please can some one help me


__
Pour mieux recevoir vos emails, utilisez un PC plus performant !
Découvrez la nouvelle gamme DELL en exclusivité sur i (france)
http://www.ifrance.com/_reloc/signedell


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] From ASP to PHP please help

[Iguider]

Hi
I have a site web made in ASP ( using frontpage software), After I read
about php I decided to re-do all my site with PHP, but still new in php
script I need help to show me the best way to change borders in ASP to php .
as you know frontpage software put  the borders in _borders, I can still
let left.htm, top.htm and bottom.htm and made necessary changes .
After that I can check database connect.
thanks in advance



__
Pour mieux recevoir vos emails, utilisez un PC plus performant !
Découvrez la nouvelle gamme DELL en exclusivité sur i (france)
http://www.ifrance.com/_reloc/signedell


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php