Hi,
This morning, I wanted to add a new database to mysql for a web based
application. However, I don't seem to be able to grant any privileges to
the database. This is what I do
# mysql -uroot -p
mysql> use mysql
Database changed
mysql> select * from user where user='root' and host='localhost';
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+
+ | Host | User | Password | Select_priv | Insert_priv | Update_priv |
+Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv |
+File_priv |
++-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+
| localhost | root | XXXXXXXXXXXXXXXX | Y | Y | Y | Y |
|Y | Y | Y | Y | Y | Y |
|+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+
|
mysql> create database try;
Query OK, 1 row affected (0.00 sec)
mysql> create table hallo (aaa TEXT);
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON try.* to dummy@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
ERROR 1044: Access denied for user: 'root@localhost' to database 'try'
mysql> GRANT ALL PRIVILEGES ON try.* to root@localhost;
ERROR 1044: Access denied for user: 'root@localhost' to database 'try'
mysql> drop database try;
Query OK, 0 rows affected (0.00 sec)
So, while I can create, edit and drop databases as user root, I cannot
grant priviliges on the database to a new user, or even to
root@localhost. Am I making any mistakes? I remember this used to work
perfectly, but now it won't. For the record, I'm using version 3.22.32
on a Debian system.
Regards,
Wouter
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
