Hi John,
I can understand what you are explaining. But I am puzzled by the fact that
the other GUI client works but MySQL VCC doesn't, although I don't like the
other one much (it is somewhat slow). You can see from the first snapshot that
I specified database name as "samp_db". In what sense was it trying to access
the database 'mysql' instead of the "samp_db"? I checked the server log and
could not find any action to access "mysql" when I used the other GUI client.
Is there any debug flag I can open to see what is going on behind?
I think MySQL VCC would be better from my impression on the help file.
But so far I just get stuck here.
Anyway, thanks a lot for your time.
Shu
At 09:49 AM 8/20/2001 +0100, you wrote:
>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