Hi, This is a dumb newbie question, so please bear with me:) I'm trying to connect to an existing database called 'billblac_recovery'. I want the username to be 'billblac_bill' and the password to be 'wgb'. I'm having no luck with the CLI or MySQLAdministrator. I'm using MySQL 4.1, upgraded from 3.x. I'd LIKE to grant full permissions to ALL databases on the server localhost to this user. Is there a single command that will do this?
Also, Can someone recommend a good GUI tool that allows me to CRUD databases, tables etc., query, modify and delete records, add and remove permissions - perform ALL necessary operations for a MySQL Server and its associated databases VISUALLY? Someone recommended NAVICAT. Anymore suggestions? Also, can someone recommend a good 3rd party book with a lot of CLI examples for Win 2K? I have the MySQL Bible but the screenshots are illegible. In Java, when trying to connect to my database with the following statement: Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/billblac_recovery?user=b illblac_bill&password=wgb"); The error is: Access denied for user: '@localhost' to database 'billblac_recovery'. I understand the message. I can't seem to get around it. Thanks, Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]