Re: php/mysql connection
| From: | Anthony Ritter | Date: | Mon, 03 Feb 2003 15:15:33 +0000 |
| Subject: | Re: php/mysql connection | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134127@lists.php.net to get a copy of this message | ||
John W. Holmes wrote in message :
> Because a default install of MySQL includes an anonymous user, one with
> no username or password. There is also a root user with no password.
> Read the MySQL manual on Installation and the GRANT command on how to
> fix this.
>
> ---John W. Holmes...
.......................................................
John,
I was under the impression that the mysql database had as default user when
installed:
..............
anonymous
root
................
And that the _anonymous_ user could only create a database that began with
the word - test.
Using the following commands:
...........................
C:\WINDOWS\cd c:\mysql\bin
C:\mysql-shareware --standalone
C:\mysql\bin>mysqladmin CREATE houses
Database houses created
C:\mysql\bin>mysql
Welcome to the mysql monitor...
mysql>USE houses
Database changed
........................
And the database "houses" was created _without_ the word "test".
Why is this?
Thanking you,
Tony Ritter