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

Error 1044 Access Denied All Database's

forums › forums › SQLyog › Using SQLyog › Error 1044 Access Denied All Database's

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 23, 2012 at 7:53 am #12605
      carbon-uk
      Member

      Hi there,

      Just looking at the trial of SQLyog as database work is increasing. Usually use the MySql Admin & Query Browser but thought i'd give this a go.

      All my database's work with remote access I'm using the same logins but they all return Error 1044 Access denied.

    • February 23, 2012 at 8:34 am #33163
      peterlaursen
      Participant

      Does this FAQ help: http://www.webyog.com/faq/content/23/42/en/error-no-1044-access-denied.html

      From any client that works (coomand line, phpMyAdmin or whatever execute as root (or another privileged user)

      SELECT user, host FROM mysql.user

      .. for the list returned identify the user and host that match the connection details you use from SQLyog. Next

      SHOW GRANTS FOR 'user'@'host';

      Replace 'user' and 'host with the ones that apply for the settings you use with SQLyog. What is returned?

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.