Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Getting Error on Connect MySQL Host

forums › forums › SQLyog › Using SQLyog › Getting Error on Connect MySQL Host

  • This topic is empty.
Viewing 9 reply threads
  • Author
    Posts
    • 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
Viewing 9 reply threads
  • You must be logged in to reply to this topic.