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]
