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
|
+----------------------------------------------------------------------------------------------------------------------------------------+
and,
mysql> show grants for 'drupal_admin'@'localhost';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for drupal_admin@localhost
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'drupal_admin'@'localhost' IDENTIFIED BY
PASSWORD '*D...D'
|
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `drupal6`.* TO
'drupal_admin'@'localhost' |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
17 rows in set (0.00 sec)
are these sufficient? these permissions worked fine as far as i could
tell for the v5.1.x install i had.
> and have you started "ymsql_upgrade" after all updates?
yes, i'd already executed 'mysql_upgrade', following the instructions
here:
http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html
checking,
mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
This installation of MySQL is already upgraded to 5.5.12, use --force
if you still need to run mysql_upgrade
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
