6 messages in com.mysql.lists.win32Re: ANNOUNCE: MyVCC-0.3.2.pre-alpha r...| Subject: | Re: ANNOUNCE: MyVCC-0.3.2.pre-alpha released |
|---|---|
| From: | John Dean (jo...@mysql.com) |
| Date: | 08/20/2001 03:53:21 AM |
| List: | com.mysql.lists.win32 |
Hi
At 02:12 20/08/2001 -0700, Shu Xiao wrote:
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.
The database "mysql" contains user access privileges, so the first database to be queried after connecting is "mysql". If you don't have the correct privileges the error you mentioned is returned
Is there any debug flag I can open to see what is going on behind?
MyVCC is compiled with debug libraries but you would need a working copy of MS VC++ V6.0 in order to view the debug output
I think MySQL VCC would be better from my impression on the help file. But so far I just get stuck here.
Can you send me some information regarding the version of MySQL you are using and any start up variables you have set for the server - check out my.cnf and/or my.ini and I will run some tests to see if I can find out the problem.
Anyway, thanks a lot for your time.
No problem, I am always available to help
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 <jo...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ 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 <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-sxiao=cisc...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php