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

[omanicool]

hi everyone..
its a very annoying msg tht am getting in phpmyadmin.. i have set everything correctly but i dont know why i can not access to the mysql through phpmyadmin. i have set a password for the root@localhost and i can access it through terminal

 [root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.22
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> 
  

and the settings in my.cnf are

 [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
    
[mysql.server]
user=mysql
basedir=/var/lib
 
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid 
  

when i put the command line skip-grant-tables in my.cnf .. i can access correctly.and using databases fine.
this is the phpmyadmin config file

 $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
 
/**
 * Disable the default warning that is displayed on the DB Details Structure page if
 * any of the required Tables for the relationfeatures could not be found
 */
$cfg['PmaNoRelation_DisableWarning']  = FALSE;
 
/**
 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
 * at least one server configuration uses 'cookie' auth_type, enter here a
 * passphrase that will be used by blowfish. The maximum length seems to be 46
 * characters.
 */
$cfg['blowfish_secret'] = 'passphrase';
 
/**
 * Server(s) configuration
 */
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysqli';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = 'pma';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = 'pmapassword';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                    // this db is displayed in left frame
                                                    // It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['hide_db']       = '';          // Database name to be hidden from listings
$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
 
$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';          // Database used for Relation, Bookmark and PDF Features
                                                    // (see scripts/create_tables.sql)
                                                    //   - leave blank for no support
                                                    //     DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';          // Bookmark table
                                                    //   - leave blank for no bookmark support
                                                    //     DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['relation']      = 'pma_relation';          // table to describe the relation between links (see doc)
                                                    //   - leave blank for no relation-links support
                                                    //     DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info']    = 'pma_table_info';          // table to describe the display fields
                                                    //   - leave blank for no display fields support
                                                    //     DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords']  = 'pma_table_coords';          // table to describe the tables position for the PDF schema
                                                    //   - leave blank for no PDF schema support
                                                    //     DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages']     = 'pma_pdf_pages';          // table to describe pages of relationpdf
                                                    //   - leave blank if you don't want to use this
                                                    //     DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info']   = 'pma_column_info';          // table to store column information
                                                    //   - leave blank for no column comments/mime types
                                                    //     DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history']       = 'pma_history';          // table to store SQL history
                                                    //   - leave blank for no SQL query history
                                                    //     DEFAULT: 'pma_history'
$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
                                                    // are up to date. This prevents compatibility
                                                    // checks and thereby increases performance.
$cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
$cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
                                     = '';
$cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
                                     = array(); 
  

i created new user pma and i did all the configuration as u see above..
i wish i can get help.. and any help would be appreciated

[omanicool]

not even one reply
thts tooooooo sad .....

[Skiboy]

not even one reply
thts tooooooo sad .....

This is not really a OS type problem. It is more like a MTSQL or PHP issue.
You may do better asking this in a SQL or PHP form.

[2006]

Did you resolve this? I have a similar problem:

Just a few days ago got a new server and spent 2 days trying to connect to MySQL. I create a DB, grant privileges to some user...

 <?php
mysql_connect ("localhost","mysqluser","2345ASDeTr") or die(mysql_error());
?>  

The output:

  Access denied for user 'admin'@'localhost' (using password: NO) 
  

Why "admin" instead of "mysqluser"???????
"admin" is the last user added to the system. If I add one more user "admin2", the output will be:

  Access denied for user 'admin2'@'localhost' (using password: NO) 
  

I even tried to grant access to this DB to user "admin". Doesn't help - the same error.

Somehow mysql ignores connection parameters...

Any ideas how to fix it?

I have Fodora Core5
mysql 5.0.22
PHP Version 5.1.4

Thank you.

[2006]

P. S. At the same time I can login as "mysqluser" via command line.

[tAK]

seriously sorry to drag up an old topic guys, but did anyone try this?
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

ive had similar issues myself in the past, this has usually helped, something to do with the authentication method changing between MySQL 4 and 5

[scanya]

check your firewall settings

[atreju]

My grain of sand here:

If you see this problem using phpMyAdmin, and you have a Headache trying to configure "congi.inc.php" in root or config folder. After you put this useful line direct in your MYSQL "SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');" go to /libraries and configure your user and pass direct there.
atreju

[atreju]

i mean: "[phpMyAdmin_root]/libraries/config.default.php"