Re: No "MYSQL" database created on installation

"Announce" <[email protected]> wrote on 01/24/2006 10:20:02 PM:

> Hi,
> 
> I just (re)-installed MySQL 4.0.25 WinXP Pro. I previously had it 
installed
> but decided to do a clean install because I never really used it the 
first
> time.
> 
> I downloaded the installer from mysql's site "mysql-4.0.25-win32.zip" 
and
> ran the install file as I did a few months ago (setup.exe). When I do 
this
> and get to the point where it asks me to do a "mysqlshow", I see the 
"test"
> database, but not the "mysql" database that the docs have pictured:
> 
> C:\mysql\bin>mysqlshow.exe
> +-----------+
> | Databases |
> +-----------+
> | test      |
> +-----------+
> 
> I also couldnt setup the any access privileges (because I dont have the
> 'mysql' database?) and got errors on the (2nd) command:
> SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd');
> 
> What the problem is??
> 
> 
> By the way, I am using 4.0.25 because this is the same version that my 
ISP
> is using and I want to keep my dev env as similar to prod as possible.
> 
> Thanks in advance!
> 

I believe the problem is that you are not connecting as a MySQL user with 
sufficient privileges to see the `mysql` database.  By default, two 
accounts are created during installation, one of them has full privileges 
(the account called "root") and the other does not (also known as the 
anonymous account). If you connect without providing any login 
information, you get this second, unprivileged account. 

Please read and follow the installation instructions in the manual. Pay 
careful attention to the parts that describe how to properly uninstall a 
previous installation and how to configure the security system.

General: http://dev.mysql.com/doc/refman/4.1/en/installing.html
Windows: http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine