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

Users Are Missing

forums › forums › SQLyog › Using SQLyog › Users Are Missing

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
    • February 12, 2010 at 4:23 am #30488
      peterlaursen
      Participant

      does this help:

      http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

      “Alternatively, on any platform, you can set the new password using the mysql client (or any client like SQLyog – my addition)… stop mysqld and restart it with the –skip-grant-tables option.”

      Now you can connect without password, add/edit users (with SQLyog or whatever). Now again start server normally.  But you will need privileges to stop and start MySQL of course.

    • February 12, 2010 at 2:18 pm #30489
      WyleySam
      Member
      'peterlaursen' wrote on '12:

      does this help:

      http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

      “Alternatively, on any platform, you can set the new password using the mysql client (or any client like SQLyog – my addition)… stop mysqld and restart it with the –skip-grant-tables option.”

      Now you can connect without password, add/edit users (with SQLyog or whatever). Now again start server normally.  But you will need privileges to stop and start MySQL of course.

    • February 12, 2010 at 2:19 pm #30490
      WyleySam
      Member

      No this will not help. I do not have access to other online servers.

      The server folks found and fixed some problem. I can now connect, add new connections, and restore databases.

      But, SQLyog is still not showing any users!!!

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