the grant statements does nobody interest maybe use phpmyadmin for a clearer display
mysql> select * from mysql.user where user='root' limit 1; +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ | 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 | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ | localhost | root | ********* | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | | +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ 1 row in set (0.00 sec) Am 05.06.2011 23:05, schrieb ag...@airpost.net: > > hi, > > On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald" > <h.rei...@thelounge.net> wrote: >> have you checked you permissions-table if all privileges are active for root > > i've got, > > mysql> show grants for 'root'@'localhost'; > > +----------------------------------------------------------------------------------------------------------------------------------------+ > | Grants for root@localhost > > | > > +----------------------------------------------------------------------------------------------------------------------------------------+ > | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED > BY PASSWORD '*3...4' WITH GRANT OPTION > | > | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION > > | > > +----------------------------------------------------------------------------------------------------------------------------------------+
signature.asc
Description: OpenPGP digital signature