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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php