No "MYSQL" database created on installation

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!


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: No "MYSQL" database created on installation

--=_alternative 004E4C5085257101_=
Content-Type: text/plain; charset="US-ASCII"

"Announce" 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


--=_alternative 004E4C5085257101_=--