I was using mysqlCC
I used to get 7 databases showing up,
one of which was winestore

Now none show up although I know they still exist.
I get the error message:

[root@localhost:3306] ERROR 1045:

How can I get them to show up again?

Thisisi the config file:
<?php

// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'localhost';
$dbname = 'winestore';
$dbuser = 'root';
$dbpasswd = '';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

    i believe 1045 is an access denied error. check out for possible solutions:
    http://www.mysql.com/doc/en/Access_denied.html

    can you connect to mysql as root from the command line?

    Check this by executing
    prompt> mysql -u root mysql

    and issuing this SQL statement to check the users table:
    mysql> SELECT * FROM user;

      prompt > -u root mysql gets me in
      and all my databases are there.

      when i select host, username and p/w from the mysql databse
      i get

      localhost root
      localhost arthur 773..345635
      localhost phpuser 453..454353

      But if i set up config.php in phpbb
      and i enter file below, i canot get access.

      (config.php in mysqlcc)
      $dbms = 'mysql';

      $dbhost = 'localhost';
      $dbname = 'winestore';
      $dbuser = 'root';
      $dbpasswd = 'mysql';

      I feel close but not quite there yet !

        ok.
        first, "mysql" in the command is not a password, it is the name of the database, so don't put it in your config file as the password.

        second, why do you say "(config.php in mysqlcc)"? there is no such thing.
        your phpBB config file doesn't have anything to do with mysqlCC not being able to connect to your database.

        so you can't connect with mysqlCC OR with phpBB but you can from the command line?
        what do you have in the "MysSQL Servers" window in mysqlCC? Can you even connect to the Server?

        since you can connect as root, in mysqlCC you should at least be able to see the server tree with "Databases", "Server Admin" and "User Administration" nodes under it. And the "mysql" and "test" databases under the Databases folder.

          So here is my config file without a password

          <?php

          // phpBB 2.x auto-generated config file
          // Do not change anything in this file!

          $dbms = 'mysql';

          $dbhost = 'localhost';
          $dbname = 'mysql';
          $dbuser = 'root';
          $dbpasswd = '';

          $table_prefix = 'phpbb_';

          define('PHPBB_INSTALLED', true);

          ?>

          Connecting
          So I can't connect using mysqlCC or phpBB
          That's right. ALthough I can connect from the command line.
          In the mysql servers window i get
          root@localhost:3306
          and I can't connect.

          the error message is
          access deniued for user
          root@localhost9 [using password? yes]

          hope this helps.
          Art

            Write a Reply...