Re: mysql/php query - wrox

Chris Shiflett" wrote in message: > Your query returns two rows because you have two rows in > the database that match the condition: > > host='localhost' > > -- > Chris ...................................... Chris, 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 ........................ As it is, I'm reading Meloni's tutorial on mysql/PHP so the question might also apply to others in this PHP ng. Anyway, the database "houses" was created _without_ the word "test" as the anonymous user. Why is this? Thanking you, Tony Ritter