Then like Richard Davey sent earlier to the list, try:
shell> mysql -u root

If you haven't created the users yet with the mysql tool, then your user
won't have access to it. First, change the root password using:
shell> mysqladmin -u root password 'new_password'

Then log into mysql and use:
mysql> Create database 'database_name';
mysql> grant all on 'database_name'.* to 'username'@'%' identified by
'password' using grant option;

You can also download the MySQL Control Center to do this for you if you
don't want to mess with the command line options.
(www.mysql.com/downloads/index.html)

The ODBC "error" that you are getting is simply because the WinMySQLAdmin
tool doesn't see that you are using it yet. If you haven't already, download
and install it. Then add it to a System DSN and use Access (or other
program) to view your database via linked tables. Then you will see that
WinMySQLAdmin will see your ODBC connector.

J.R.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to