I have a very similar problem. I'm running Ubuntu 10.04 LTS with mysql 5.1.
I have not created any users other than the defaults.
Server version: 5.1.41-3ubuntu12.1 (Ubuntu)
I can do this:
mysql
mysql> create database foobar;
I can't do this:
mysql> grant create temporary tables on *.* to public;
ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)
Here are all grants:
mysql> show grants;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for @localhost
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
PROCESS, FILE, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW, CREATE
ROUTINE, ALTER ROUTINE, CREATE USER ON *.* TO ''@'localhost' WITH GRANT OPTION |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Something seems to be somewhat off in the packet setup, though:
# grep -C2 mysql /var/log/daemon.log:
Jul 7 16:37:18 jwatte-hello-ubuntu init: apport post-stop process (883)
terminated with status 1
Jul 7 16:37:18 jwatte-hello-ubuntu acpid: waiting for events: event logging is
off
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[917]: Upgrading
MySQL tables if necessary.
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]:
/usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]: Looking for
'mysql' as: /usr/bin/mysql
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]: Looking for
'mysqlcheck' as: /usr/bin/mysqlcheck
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]: Running
'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock' '--host=localhost'
'--socket=/var/run/mysqld/mysqld.sock' '--host=localhost'
'--socket=/var/run/mysqld/mysqld.sock'
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]:
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user
'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[920]: FATAL ERROR:
Upgrade failed
Jul 7 16:37:18 jwatte-hello-ubuntu /etc/mysql/debian-start[929]: Checking for
insecure root accounts.
Jul 7 16:37:18 jwatte-hello-ubuntu acpid: client connected from 934[0:0]
Jul 7 16:37:18 jwatte-hello-ubuntu acpid: 1 client rule loaded
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
