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: [root@uk ~]#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 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?
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.
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 | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+