Getting Error on Connect MySQL Host

This topic is empty.

Viewing 10 reply threads

Author

Posts
- November 8, 2004 at 8:35 am #8645
  
  kamcap
  Member
  
  I have Installed MySQL 5.1 Alpha version and i have win2000 professionl with NTFS … when i installed it and run the server and opened the WinMySQLAdmin 1.4 it showed MyODBC driver is not found..so i read the help that it need MyODBC.dll under c:wintsystem32 but i checked it there no file like this name so i downloaded MyODBC 3.15 version from MySQL site and installed it and it copies 2 files (MyODBC3.DLL and MyODBC3S.DLL) in this directory c:wintsystem32. When i restart my pc and run the server it picked up the Driver/Setup but still showed MyODBC status as “NOT FOUND” and also not showing Driver Version, API LVEL and SQL Level in WinMySqlAdmin 1.4 so after that i m not able to create Databse from this interface although in the help it is described in the help of this GUI that user can create db, tables and indexes on tables.
  
  My one friend said me that use SQLYog which is best GUI as mysql manager, so i downloaded it and install it perfectly, on the creating on new connection with MySQL i entered the connection description, MySQL Host/Address, username, password, database name while i did not creat any dabatse yet so i entered MyFirstDB and press connect then i got a message
  
  SQLyog
  
  Error No. 1045
  
  Access denied for user: 'Kamil'@'localhost' (Using password: YES)
  
  OK
  
  Plz help me in this regard and tell me that wat is the actual problem ? I m sending u the snapshot of WinMySqlAdmin 1.4. I hope this snap shot will help to fix my problem.
  
  Regards
  
  Kamil
- November 8, 2004 at 4:35 pm #16513
  
  peterlaursen
  Participant
  
  As far as I know the ODBC-driver is not ready for MySQL ver. 5 yet.
  
  To create users try the program “MySQL Administrator” from http://www.mysql.com. (don't know if YOG will work with the new user SCHEMA.
  
  How did you create the use KAMIL 'Kamil'@'localhost' (Using password: YES)?
  
  With a fresh install only use ROOT exists!
  
  MySQLAdmin was writen for older versions of MySQL and I too have experienced missing or wrong informatiom in it.
- November 8, 2004 at 4:41 pm #16514
  
  Ritesh
  Member
  
  The error you are getting simply means that you are giving wrong password.
- November 8, 2004 at 10:49 pm #16515
  
  Shadow
  Member
  
  You cannot connect to any MySql 4.1.x and 5.x via ODBC with a user that has an assigned password. Create a user with no password and you'll be able to connect swiftly.
- November 9, 2004 at 7:40 pm #16516
  
  peterlaursen
  Participant
  
  > Shadow …
  
  I have 4 users alle with password om my 4.1.7 installtion, and I can connect through ODBC.
  
  I believe it needs the latest my-ODBC, and I don't think there is any ODBC for MySQL 5 yet …
- November 11, 2004 at 7:43 am #16517
  
  Shadow
  Member
  
  You must be using the old password scheme then. I don't know if MySql 5.x still has that option… The latest MyODBC is not even 4.0 compliant yet!
- November 11, 2004 at 3:43 pm #16518
  
  Ritesh
  Member
  
  I think they have not even updated winmysqladmin for a long time.
- November 12, 2004 at 10:58 am #16519
  
  Shadow
  Member
  
  Quote:
  
  I think they have not even updated winmysqladmin for a long time.
  
  Very true, it's replaced by MySqlAdminsitrator.
- November 12, 2004 at 5:51 pm #16520
  
  peterlaursen
  Participant
  
  Agreed!
  
  However there is one facility in Winmysqladmin that's not in MySQLAdministrator: You can not only stop the server but also uninstall the service from Winmysqladmin without uninstalling the application. I'd allways preferred to uninstall the service that way before upgrading. But with the new Win-installer it probably isn't necessary.
  
  Further you'll have to get MysQl running before you can use MySQLadministrator – you can't bypass the logon-screen.
  
  In general I think the people MySQL are very performng vey bad as far as documenting what utilities fit what version of MySQL. I think it called “Version's Management” (it is in Danish!)
  
  And what happened to “MySQL Control Center” ??
  
  Concerning the ODBC issue: I really rigoriously followed the instruction when I first upgraded from a 4.0 to a 4.1 version. So the user's and password's scema shoul be updated as well.
- November 12, 2004 at 6:37 pm #16521
  
  Ritesh
  Member
  
  Development of MyCC has been ceased. With time it will be replaced by MySQL Admin and MySQL Query Browser.
- November 15, 2004 at 5:23 pm #16522
  
  Ritesh
  Member
  
  Quote:
  
  However there is one facility in Winmysqladmin that's not in MySQLAdministrator: You can not only stop the server but also uninstall the service from Winmysqladmin without uninstalling the application. I'd allways preferred to uninstall the service that way before upgrading. But with the new Win-installer it probably isn't necessary.
  
  With a nice installer being provided with MySQL 4.1.7, I guess all the above problems will be solved 🙄
Author

Posts