Problems installing MySQL on debian 5

Discussion in 'Installation/Configuration' started by donix, Apr 29, 2010.

  1. donix

    donix New Member

    I'm working on installing ISPConfig 3 on my XEN VPS(Debian 5.0 64bit Minimal). I have a problem installing mysql. It is not possible to login to mysql.

    Code:
    [[email protected] ~]#mysql -u root -p
    Enter password:
    I enter the root password given during the install and then it returns:
    Code:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    I can't install ISPConfig(obviously) cause of the same error. I've tried to reset my root password:
    Code:
    dpkg-reconfigure mysql-server-5.0
    Does not help :confused:

    I've tried this guide: http://www.cyberciti.biz/tips/recover-mysql-root-password.html

    When I update user table it returns:
    Code:
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 0  Changed: 0  Warnings: 0
    And still doesn't work.. Anyone know what to do?
     
  2. charlesrg

    charlesrg New Member

    After you login with --skip-grant-tables
    type
    use mysql;
    and try:
    select * from user WHERE User="root";

    You should have some results. It can be that your password is correct but you disabled access from localhost.

    Check the table "User" all the parameters are in there.
    If you have a problem read the mysql manual and add another with all the permissions just like root.
     
  3. donix

    donix New Member

    It returns:
    Code:
    Empty set (0.00 sec)
    select * from user; returns:

    Code:
    +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
    | Host      | User             | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |
    +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
    | localhost | debian-sys-maint | *F4D282E67F888B5101B1DE00C53BE1C6A608A29D | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | N                | N              | N                   | N                  | N                |          |            |             |              |             0 |           0 |               0 |                    0 |
    +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
     

Share This Page