phpMyAdmin-2.10.2

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Trying to get this running on my home server. Its a Windows server running Small Business Server 2003 with IIS.

I have PHP and MySQL running but I keep getting this error when trying to access phpMyadmin.

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

My config.inc file has

$cfg['Servers'][$i]['auth_type']= 'http';

since I want to use the browser for access.

Anybody have expierence setting this up?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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

Posted: Sun Jun 24, 2007 10:05 pm

I have been for a couple hours now.

Posted: Sun Jun 24, 2007 10:10 pm

Donovan, what exactly are you trying to get working?

Posted: Sun Jun 24, 2007 10:21 pm

Trying to setup phpMyadmin on a server located at my feet.

I am able to serve pages to the outside world.

I have both MySQL and PHP running however I have been getting this for an hour.

http://www.donovanfamily.us/phpMyAdmin-2.10.2/index.php

I created the config.inc.php and it is located in the phpMyadmin directory.

I can access to scripts/setup.php if I wanted to but would rather set it up manually.

Once I get phpMyadmin up and running I will lock it down.

Posted: Sun Jun 24, 2007 11:18 pm

Using the MYSQL command line tool to update the password doesn't seem to like me either.

Code:

Enter password: ******


Welcome to the MySQL monitor.  Commands end with ; or \g.


Your MySQL connection id is 5


Server version: 5.0.41-community-nt MySQL Community Edition (GPL)





Type 'help;' or '\h' for help. Type '\c' to clear the buffer.





mysql> mysql -u root -p mysql


    -> --skip-grant-tables --user=root


    -> USE mysql


    -> UPDATE user


    -> SET password=password("Permit1")


    -> WHERE user="root";


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that


corresponds to your MySQL server version for the right syntax to use near 'mysql


 -u root -p mysql


USE mysql


UPDATE user


SET password=password("Permit1")


WH' at line 1


mysql>

registered · Posted: Mon Jun 25, 2007 7:18 am

Not sure you're doing the command right. Once you get into the mysql shell, you don't need to type "mysql" again

Looks like that command was to use outside the mysql shell, so just don't log into mysql and run the command with the proper username, password.

You really should create your own user/passwords within mysql and disable the root login, esp if others are going to have access to your machine.

Posted: Mon Jun 25, 2007 8:20 am

Still no difference. Gives me the same error.

Code:

Enter password: ******


Welcome to the MySQL monitor.  Commands end with ; or \g.


Your MySQL connection id is 6


Server version: 5.0.41-community-nt MySQL Community Edition (GPL)





Type 'help;' or '\h' for help. Type '\c' to clear the buffer.





mysql> -u root -p mysql


    -> --skip-grant-tables --user=root


    -> USE mysql


    -> UPDATE user


    -> SET password=password("Permit1")


    -> WHERE user="root";


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that


corresponds to your MySQL server version for the right syntax to use near '-u ro


ot -p mysql


USE mysql


UPDATE user


SET password=password("Permit1")


WHERE us' at line 1


mysql>

Posted: Mon Jun 25, 2007 9:36 am

OK..

Making some headway.

I wanted to use 'http' for the auth so I am prompted to login.

I created a user and assigned privledges but am unable to login as that user.

Should I use 'cookie' as the auth type.

Should I use this

$cfg['Servers'][$i]['host'] = 'http://www.donovanfamily.us';

or

$cfg['Servers'][$i]['host'] = 'localhost';

Posted: Mon Jun 25, 2007 10:16 am

evaders99 wrote:

You really should create your own user/passwords within mysql and disable the root login, esp if others are going to have access to your machine.

How do I disable the root login.

..Never mind I think I found...

$cfg['Servers'][$i]['AllowRoot'] = FALSE;

Posted: Mon Jun 25, 2007 11:29 am

Within the mysql command line, you don't even need the other parameters for the user login. Just use the SQL statement itself