Hello,
I have installed MySQL 5.0. I have also installed PHP5 and phpMyAdmin.
The problem is that phpMyAdmin cannot use MySQL because of error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I am *nearly* sure that during MySQL setup I have entered my private email
address instead of root@localhost, so this is probably reason of this error.
Thus, I have a question: can I change email without reinstalling MySQL 5.0?
Please , I have little experience. Thanks a lot in advance.
/RAM/

R.A.M. wrote:
> Hello,
> I have installed MySQL 5.0. I have also installed PHP5 and phpMyAdmin.
> The problem is that phpMyAdmin cannot use MySQL because of error:
> #1045 - Access denied for user 'root'@'localhost' (using password: NO)
> I am *nearly* sure that during MySQL setup I have entered my private email
> address instead of root@localhost, so this is probably reason of this error.
> Thus, I have a question: can I change email without reinstalling MySQL 5.0?
> Please , I have little experience. Thanks a lot in advance.
> /RAM/
>
>
>

Your email address is not necessarily your userid.

But what you need to do is change the configuration file for phpMyAdmin.
See the install documentation for it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

R.A.M. wrote:
> Hello,
> I have installed MySQL 5.0. I have also installed PHP5 and phpMyAdmin.
> The problem is that phpMyAdmin cannot use MySQL because of error:
> #1045 - Access denied for user 'root'@'localhost' (using password: NO)
> I am *nearly* sure that during MySQL setup I have entered my private
> email address instead of root@localhost, so this is probably reason
> of this error. Thus, I have a question: can I change email without
> reinstalling MySQL 5.0? Please , I have little experience. Thanks
> a lot in advance. /RAM/

root@localhost is not an amail address. It says that the userid "root" may
access mysql from "localhost"

U¿ytkownik "Paul Lautman" <paul.lautman@btinternet.com> napisa³ w wiadomo¶ci
news:5tvmcsF1fbrevU1@mid.individual.net...
> root@localhost is not an amail address. It says that the userid "root" may
> access mysql from "localhost"

Thanks.
I am nearly sure that I have entered my provate email instead of
root@localhost during setup. Can I change this information now?
/RAM/

Uzytkownik "Jerry Stuckle" <jstucklex@attglobal.net> napisal w wiadomosci
news:zLedncAUe9JTD-fanZ2dnUVZ_oninZ2d@comcast.com...
> Your email address is not necessarily your userid.
>
> But what you need to do is change the configuration file for phpMyAdmin.
> See the install documentation for it.

Thanks, but...
I want to have root@localhost instead of my private email in MySQL
configuration. Can I change it now in MySQL?
/RAM/

Uzytkownik "Jerry Stuckle" <jstucklex@attglobal.net> napisal w wiadomosci
news:zLedncAUe9JTD-fanZ2dnUVZ_oninZ2d@comcast.com...
> But what you need to do is change the configuration file for phpMyAdmin.

I had no config.inc.php so I created it using setup script:

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.11.3 setup script by Michal Cihar
<michal@cihar.com>
* Version: $Id: setup.php 10748 2007-10-10 07:30:59Z cybot_tm $
* Date: Wed, 02 Jan 2008 06:31:38 GMT
*/

/* Servers configuration */
$i = 0;

/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mysql';

/* End of servers configuration */

$cfg['blowfish_secret'] = 'phpmyadmin';
$cfg['ForceSSL'] = false;
$cfg['ShowPhpInfo'] = false;
$cfg['ShowChgPassword'] = false;
$cfg['AllowArbitraryServer'] = false;
$cfg['LoginRecall'] = 'something';
$cfg['LoginValidity'] = 1800;
?>

But when I am trying to open phpMyAdmin
(http://localhost/phpMyAdmin/index.php) I still receive the same error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I don't understand why "using password" is NO while in config.inc.php I have
a line:

$cfg['Servers'][$i]['password'] = 'mysql';

(and this is correct password to my MySQL).
When I click "Open new phpMyAdmin window" I receive error that configuration
file requires blowfish_secret. But I have a line:

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

in my config.inc.php.
I don't know what to do. Please .
Thank you.
/RAM/

R.A.M. wrote:
> Uzytkownik "Jerry Stuckle" <jstucklex@attglobal.net> napisal w wiadomosci
> news:zLedncAUe9JTD-fanZ2dnUVZ_oninZ2d@comcast.com...
>> But what you need to do is change the configuration file for phpMyAdmin.
>
> I had no config.inc.php so I created it using setup script:
>
> <?php
> /*
> * Generated configuration file
> * Generated by: phpMyAdmin 2.11.3 setup script by Michal Cihar
> <michal@cihar.com>
> * Version: $Id: setup.php 10748 2007-10-10 07:30:59Z cybot_tm $
> * Date: Wed, 02 Jan 2008 06:31:38 GMT
> */
>
> /* Servers configuration */
> $i = 0;
>
> /* Server localhost (config:root) [1] */
> $i++;
> $cfg['Servers'][$i]['host'] = 'localhost';
> $cfg['Servers'][$i]['extension'] = 'mysqli';
> $cfg['Servers'][$i]['port'] = '3306';
> $cfg['Servers'][$i]['connect_type'] = 'tcp';
> $cfg['Servers'][$i]['compress'] = false;
> $cfg['Servers'][$i]['auth_type'] = 'config';
> $cfg['Servers'][$i]['user'] = 'root';
> $cfg['Servers'][$i]['password'] = 'mysql';
>
> /* End of servers configuration */
>
> $cfg['blowfish_secret'] = 'phpmyadmin';
> $cfg['ForceSSL'] = false;
> $cfg['ShowPhpInfo'] = false;
> $cfg['ShowChgPassword'] = false;
> $cfg['AllowArbitraryServer'] = false;
> $cfg['LoginRecall'] = 'something';
> $cfg['LoginValidity'] = 1800;
> ?>
>
> But when I am trying to open phpMyAdmin
> (http://localhost/phpMyAdmin/index.php) I still receive the same error:
>
> #1045 - Access denied for user 'root'@'localhost' (using password: NO)
>
> I don't understand why "using password" is NO while in config.inc.php I have
> a line:
>
> $cfg['Servers'][$i]['password'] = 'mysql';
>
> (and this is correct password to my MySQL).
> When I click "Open new phpMyAdmin window" I receive error that configuration
> file requires blowfish_secret. But I have a line:
>
> $cfg['blowfish_secret'] = 'phpmyadmin';
>
> in my config.inc.php.
> I don't know what to do. Please .
> Thank you.
> /RAM/
>
>
>

It looks like phpMyAdmin isn't finding your config.inc.php. Is it in
the phpMyAdmin root directory?

Start with the documentation. I don't use the setup script - it doesn't
set all of the variables. Also, I findit's much easier for me to just
edit the file directly, starting with the config.default.php as a template.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Wed, 2 Jan 2008 06:48:51 +0100, "R.A.M."
<r_ahimsa_m@poczta.onet.pl> wrote:

>U¿ytkownik "Paul Lautman" <paul.lautman@btinternet.com> napisa³ w wiadomo¶ci
>news:5tvmcsF1fbrevU1@mid.individual.net...
>> root@localhost is not an amail address. It says that the userid "root" may
>> access mysql from "localhost"
>
>Thanks.
>I am nearly sure that I have entered my provate email instead of
>root@localhost during setup. Can I change this information now?
>/RAM/

You have to perform the procedure to reset a root
password:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
--
( Kees
)
c[_] RAM disk is *not* an installation procedure. (#444)