Is this something new with mysql 5, a bug, or something I'm missing? I'm
not able to switch databases.
[EMAIL PROTECTED] 5.0.15-0-es4]# rpm -ivh
MySQL-client-standard-5.0.15-0.rhel4.i386.rpm
MySQL-devel-standard-5.0.15-0.rhel4.i386.rpm
MySQL-server-standard-5.0.15-0.rhel4.i386.rpm
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql');
Query OK, 0 rows affected (0.20 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.16 sec)
mysql> exit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u root -p
mysql> CREATE DATABASE FOO;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON FOO.* TO 'bar'@'localhost' IDENTIFIED BY
'bar' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> use FOO;
ERROR 1049 (42000): Unknown database 'FOO;'
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| FOO |
| mysql |
| test |
+--------------------+
4 rows in set (0.06 sec)
mysql> exit
[EMAIL PROTECTED] 5.0.15-0-es4]# ls /var/lib/mysql/FOO/
db.opt
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar -p
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql>
mysql> use FOO;
ERROR 1044 (42000): Access denied for user 'bar'@'localhost' to database
'FOO;'
mysql> exit;
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar FOO -p
mysql> show tables;
Empty set (0.00 sec)
mysql>quit;
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u root -p
mysql> create database BLA;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON BLA.* TO 'bar'@'localhost' IDENTIFIED BY
'bar' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar -p
mysql> use FOO;
ERROR 1044 (42000): Access denied for user 'bar'@'localhost' to database
'FOO;'
mysql> use BLA;
ERROR 1044 (42000): Access denied for user 'bar'@'localhost' to database
'BLA;'
mysql> quit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar FOO -p
mysql> show tables;
Empty set (0.00 sec)
mysql> use BLA;
ERROR 1044 (42000): Access denied for user 'bar'@'localhost' to database
'BLA;'
mysql> quit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar BLA -p
mysql> show tables;
Empty set (0.00 sec)
mysql>
Thanks !
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
