Re: newbee error (1044)

[Michael Stassen]

Shawn Sharp wrote:
I get the following error while trying to create the following database
mysql mysql < zm_cre­ate.sql.in
ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database
'mysql'

You are logged into mysql as the anonymous user, ''@'­loc­al­host'.  By default, 
the anonymous user does not have permission to create databases.

I tried to run the following script

/usr/bin/mysql_in­stall_db --user­=mysql

It does not create mysql database in the correct directory I still only see
the 2 databases

2?  I see only 1, test.  That's to be expected, though.  You can only see 
databases you have access to.  The anonymous user is not authorized to access 
the mysql db, so it is not listed.  Only dbs you have access to are listed. 
Typically, only the mysql root user has access to the mysql db, so it is only 
listed when you are logged in as root.

/us­r/bin/mysqlshow
+-----------+
| Databases |
+-----------+
| test      |
+-----------+

Thanks

Michael


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]