Mombu the GNU Linux Forum sponsored links

Go Back   Mombu the GNU Linux Forum > GNU_Linux > #1045 - Access denied for user 'root'@'localhost' (using password:NO)
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 19th July 03:09
rob
External User
 
Posts: 1
Default #1045 - Access denied for user 'root'@'localhost' (using password:NO)


Trying to login to phpMyAdmin and I get:

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

Anyone know how to fix this?

Thanks
--
Rob
  Reply With Quote


  sponsored links


2 19th July 03:10
elfi gill
External User
 
Posts: 1
Default #1045 - Access denied for user 'root'@'localhost' (using password: NO)


- open config.inc.php in your favourite editor
- find the line "$cfg['Servers'][$i]['auth_type']"
- change the current value "config" to "http"
- save config.inc.php
  Reply With Quote
3 19th July 11:17
rob
External User
 
Posts: 1
Default #1045 - Access denied for user 'root'@'localhost' (using password:NO)


Yes, even if I change, config.inc.php login from auth to http and get
prompted for a pwd it does not accept it. I think the problem was that
when we first got phpMyAdmin up it warned us to set a pwd for root and
we set it to something other that the machine root pwd. My
understanding is that the pwd should be the same for mySql as for linux
root. We did not do that. Is there a way to delete the password file
for mySql and start over? We've tried:

mysqladmin -u root flush-privileges password "newpwd"

but get another error message:

#2002 - Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

The file mysql.sock is not there when I go to look for it.

Any ideas?

Thanks.

Rob


--
Rob Proctor Marine.com & Cyber-Marine.com
<robp@marine.com>
602 Blue Hills Road
Durham
CT
06422
USA
Cellular: 860-214-0278
Fax: 928-962-1049
Toll Free: 800-597-1781
Work: 860-349-9499
  Reply With Quote
4 19th July 11:18
achim z.
External User
 
Posts: 1
Default #1045 - Access denied for user 'root'@'localhost' (using password: NO)


That's right.
Btw:
You do not need the user "root" in MySQL. Choose another username to have full access to MySQL.


(re-)start MySQL via /etc/init.d/mysqld


Kind regards,
Achim
--
Diktatur Deutschland:
http://de.wikipedia.org/wiki/Überwachungsstaat
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666