473,325 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

phpMyAdmin connect problem

Hi,

I am trying to use phpMyAdmin but not getting past the start up screen.
I am getting the following error:

#1045 Access denied for user: root@localhost (Using Password: NO)

I have went through config.inc.php to ensure that I have entered the
correct host, username and password. It is the part in the error
message, 'Using password: NO', that I dont understand. How do I
configure it to use passwords if that is the problem?

Does anybody recognise this problem, it would be great to hear.

Cheers

Burnsy

Aug 25 '05 #1
3 15441
I'd also like to add that I am using Apache, PHP and MySQL from my home
computer. It is a pretty default installation of all.

Burnsy

Aug 26 '05 #2
bi******@yahoo.co.uk wrote:
Hi,

I am trying to use phpMyAdmin but not getting past the start up screen.
I am getting the following error:

#1045 Access denied for user: root@localhost (Using Password: NO)

I have went through config.inc.php to ensure that I have entered the
correct host, username and password. It is the part in the error
message, 'Using password: NO', that I dont understand. How do I
configure it to use passwords if that is the problem?

Does anybody recognise this problem, it would be great to hear.

Cheers

Burnsy


There are two passwords - see your config.inc.php file and look for the entires:

$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Aug 26 '05 #3
On 25 Aug 2005 16:03:26 -0700, bi******@yahoo.co.uk wrote:
Hi,

I am trying to use phpMyAdmin but not getting past the start up screen.
I am getting the following error:

#1045 Access denied for user: root@localhost (Using Password: NO)

I have went through config.inc.php to ensure that I have entered the
correct host, username and password. It is the part in the error
message, 'Using password: NO', that I dont understand. How do I
configure it to use passwords if that is the problem?

Does anybody recognise this problem, it would be great to hear.

Cheers

Burnsy


First check your config.inc.php file to see what type of authentication is
used. look for $cfg['Servers'][$i]['auth_type'] you have three to choose
from, HTTP, cookie or config.

Because if you use HTTP or cookie authentication you don't need to put your
user/password in the config.inc.php file. you enter it when you start up
phpMyadmin.

If you use the config method you only need to enter your user/pass into the
following two fields $cfg['Servers'][$i]['user']= '';
$cfg['Servers'][$i]['password'] = '';
Check that the input is *Between* the two single quotes, I spent ages the
first time I set this up because I had brain fade and thought that they
were a single double quote :-0.

The other two areas that ask for authentication
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = ''; are only needed to open up
further features in phpMyadmin, check the documentation that comes with the
program to see if you want this activated, because if you do, you will need
to follow the instructions provided to create a number of tables.
Aug 27 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Richard White | last post by:
Hi, I've got a localhost (ie. my PC) installation of Apache MySQL WinXP-Pro and I'm trying to get the MySQL administration program {phpMyAdmin} to run.
4
by: JimC | last post by:
I have PHP installed on a Windows XP platform using IIS as server. When updating a MySQL database field set to MEDIUMTEXT in phpMyAdmin, the transaction seems to fail if the text contains more...
0
by: Mechphisto | last post by:
Not sure if this is truly a mySQL issue or a PHP issue, since the problem started when I reconfigured/made a PHP upgrade:We're using RedHat ES2.1. With PHP 4.1.3 and phpMyAdmin 2.5.6, it was...
0
by: Marko | last post by:
Hello, Don't know if this is the right group... On our LAN, we have PhpMyAdmin 2.5.7-pl1 installed and PmaAbsoluteURI is set to http://192.168.1.200:81. When accessed from LAN, it works great....
2
by: Daniel Mercier | last post by:
Hi, I'm new to mysql and just installed phpmyadmin. Here is the versions info: System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1 PHP Version 4.3.8
5
by: Marcus | last post by:
Hello, I am having a problem with a query in phpMyAdmin... it works fine on my localhost, but the exact same query produces an error in phpMyAdmin on my server: localhost: PHP 4.3.11, MySQL...
4
tolkienarda
by: tolkienarda | last post by:
Hi all I work for a small webdesign company and we have remote hosting. i built a mysql database with phpmyadmin on the server. i then downloaded and modified a php login page. i am continuing to...
4
by: shadow123763 | last post by:
I cannot access phpMyAdmin it comes up with this.... Welcome to phpMyAdmin 2.10.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the...
0
by: ballygowanboy | last post by:
i'm sure this is a password issue.... i can view my site, so sql is running. but, when i try to get into phpMyAdmin... i'm getting this message phpMyAdmin tried to connect to the MySQL server,...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.