Hi Shu,
At 20:08 19/08/2001 -0700, Shu Xiao wrote:
>John,
>
>I got problem using this new release. When I opened the connection
>dialog, I typed in the host name, database name and user name * password.
>I specified a database other than mysql. But I always got the error saying
>"Access denied for user 'xxxxxx' to database 'mysql'".
This error indicates that you may have entered a wrong password. Section
6.16: "Causes of Access denied Errors" in the MySQL User Manual gives full
details and solutions to this problem.
>I think mysql is
>the default database if the user doesn't enter the database name in the
>dialog, but I did.
>Why it always tries to access 'mysql'?
The database "mysql" is where user privileges are stored. If this is a new
installation try to log on as root with no password.
I have the MySQL Server running on both remote Linux and Windows machines
on my local network and I am able to connect to either locally - localhost
or remotely without a problem therefore I believe your problem relates to
the setup of your user privileges
>I checked the MySQL server log and saw connection log, which was a real
>connection request to 'mysql'. This is not correct. My server is running
>on the other machine.
>
>Please have a look at this.
>
>Thanks,
>
>Shu
>
>
>At 08:44 AM 8/18/2001 +0100, John Dean wrote:
>>Hi
>>I have released a new version of MySQL Visual Control Center for Windows.
>>This release includes the following revisions:-
>>1. Help viewer with help files in HTML format. These help files can also
>>be viewed outside of MyVCC using your favorite web browser so they can
>>also be used as the project documentation
>>2. Fixed bug in Create Fields Dialog which limited the field length to 99
>>characters. The limit on field length is now dependent on Data Type
>>3. Submit Button on startup is now disabled until a connection has been
>>established
>>4. Tools Menu on startup is now disabled until a connection has been
>>established
>>5. Fixed bug related to submitting queries. Previously the query would
>>fail if there was no WHERE and/or ORDER BY clause. This has now been fixed.
>>6. The problem relating to MyVCC not being able to find the SQL drivers
>>has been fixed.
>>7. This release includes libmysql.dll from the V3.23.40 release of MySQL.
>>Therefore, provided mysqld is running MyVCC will work without having to
>>copy the DLLs to your Windows system directory.
>>
>>To download this release, please visit the MyVCC project at
>>http://sourceforge.net/projects/mycc
>>
>>Regards
>>John
>>
>>--
>>
>>MySQL Development Team
>> __ ___ ____ __ __
>> / |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]>
>> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
>>/_/ /_/\_, /___/\___\_\____/ Mansfield, England, UK
>> <___/
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>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
>
>
---------------------------------------------------------------------
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