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 [email protected]:
>
> hi,
>
> On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald"
> <[email protected]> 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
