alan4100: If you reply to this, please CC the list.
Keep reading the manual while you try things. From your questions, I am wondering if you are not reading the manual, or are just too impatient and are trying things before you read the whole story. If your processor is faster than 100MHz and has more than 64M RAM, I recommend downloading the manual.pdf (Adobe Acrobat), so you can browse it off-line. You'll need Acrobat, of course, but Acrobat is useful for reading many things, well worth the download time. You can find links to the documentation pages at mysql's main web page. To repeat what others have said, you need to understand how to set passwords, how to supply passwords when running the client, and how to GRANT access to databases to specific users. Yes, "GRANT" is a MySQL command, and you do need to understand it. It would be easier if you had someone handy to configure a database for you. Then you wouldn't need to understand the GRANT command, just how to log in with a user name and password. Actually, your initial installation should be without a root password, so you should be okay. Deleting the whole installation was a drastic step, and probably unnecessary. See below for a few comments: > Your mentioning about mysql -h host -u user prompts me to type > > mysql> select system_user(); ...the output is > > +----------------+ > | system_user() | > +----------------+ > | ODBC@localhost | > +----------------+ > 1 row in set (0.00 sec) > > I then tried mysql -h localhost -u ODBC Okay, you logged on as your ODBC driver. > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 19 to server version: 3.23.44-nt > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> use mysql > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' You didn't GRANT ODBC access to the database 'mysql', neither did you log on as root. BTW, do not grant access to the 'mysql' database to ODBC. Since that's the configuration database, that would be a major security hole. Find out the root password and login as root. In your fresh install, there shouldn't be a password yet, but it would be a good idea to set one just as soon as you know how. You may have a my.cnf (root of your system drive, I did see a c:> didn't I?) or my.ini (Windows directory) left over from the previous install. That may have a default password set in it for root. As was mentioned, you might have been able to access the 'test' database. Anyway, read that fantastic manual. And follow up on list. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
