I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2.
I am trying to learn MySQL and PHP. I am using PHP & MySQL for dummies.
I am having a problem. Look:
mysql> SELECT * FROM user -> ; ERROR 1046: No Database Selected mysql>
Ok so the book says " This message means your account is not allowed to slect the mysql database"
That's not actually correct. The message means that there is no default database (so MySQL is unable to determine which database contains the user table).
It may well be that your account cannot select the mysql database, but that's not something that can be inferred from the preceding error message. You can find out if you have access to the mysql database by issuing this statement:
USE mysql;
You can also specify the database name in the SELECT query:
SELECT * FROM mysql.user;
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
