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

cannot login

forums › forums › cannot login

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • June 29, 2003 at 8:32 pm #8070
      mixmaster
      Member

      Hi all

      My mysql was working with root and no pass.

      i used sqlyog to set a password for root and now i cant connect, even with the password. I tried using the mysql.exe in a dos window but it says cannot connect to DB. My 2 forums need the DB on the mysql so i need to know is there a way to fix this?

      thanks

    • June 30, 2003 at 4:38 am #14604
      Ritesh
      Member

      Greetings

      What version of MySQL and SQLyog are your running? Are you sure you are giving the correct password.

    • June 30, 2003 at 5:26 am #14605
      mixmaster
      Member

      HI, it took me forever to figure this out and ultimatley i couldnt. apparently i no longer have tcp connection via localhost. and odbc says wrong user. This all happened after i changed the root password.

      Mysql is 4.1.2 and syslog is trial version of whatever is posted on the site right now.

      Anyway i had to reinstall the mysql. i now have root access again but still when i use mysql.exe via dos command, it says no tcp connection via localhost.

      really frustrating.

    • June 30, 2003 at 6:59 am #14606
      Shadow
      Member

      The problem is that you use MySql 4.1. This version applies a new binary protocol not supported by many front-ends. Thus the older front-ends may connect to MySql 4.1 in that case only when there is no password. Upgrade your SQLyog to v3.5 which support MySql 4.1 login with passwords.

      Unfortunately MyODBC, MySql's ODBC driver does not support 4.1 completely, so you cannot use passwords with MyODBC either. MySql says that MyODBC 3.52 (currently in alpha) will support 4.1.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.