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

Viewing 3 reply threads
  • Author
    Posts
    • #11873
      WyleySam
      Member

      When I try to make a new connection to to a server I'm getting the following error message:

      Error No. 1045

      Access denied for user 'neilswar'@'98.193.92.228' (using password: YES)

      When I connect to an existing connection on a different server and try to restore a database I'm getting the errors below. When I try to edit users there are none.

      Can anyone help???

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 09:43:49

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 09:48:08

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 09:48:14

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 09:53:54

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 10:22:27

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 12:36:18

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 17:17:59

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

      Query:

      CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

      Error occured at:2010-02-11 17:29:29

      Line no.:15

      Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

    • #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.

    • #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.

    • #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!!!

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