[PHP] phpMyAdmin : password and user (Help)
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] From ASP to PHP please help
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
[PHP] borders in dreamwever please Help
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 : 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] how to redirect from one page to an other page in PHP ?
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] Fw: esayphp
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
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 > > > > -- > 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] phpMyAdmin please help
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
Re: [PHP] phpMyAdmin please help
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] phpMyAdmin 2.2.6
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
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
