Hi
This error dialog is based on what is returned from the MySQL server. The
mysql driver QMYDQL3 does nothing more than pass your log on parameters to
libmysql.dll which in turn interacts with the MySQL server. If there is a
problem connecting the server returns the appropriate error and all MyVCC
does is , is display that error in a dialog.
At 00:34 20/08/2001 -0700, Shu Xiao wrote:
>John,
>
>I think I setup the privilege in my server machine correctly because
>I can connect to MySQL server and retrieve the query result with
>MySQLGUI(1.7.5) under the same setting and connection parameters.
>
>I attached two snapshots the windows. The first is 1.bmp showing
>my connection paramaters, and the second is 2.bmp, which is the
>error message I got. Please take a look.
>
>Am I setting anything wrong here? I don't think it is on server side
>since the other GUI works on the same client Win2000.
>
>Thanks,
>
>Shu
>
>
>At 06:45 AM 8/20/2001 +0100, John Dean wrote:
>>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
