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

Error No. 1045

forums › forums › SQLyog › Using SQLyog › Error No. 1045

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • February 3, 2003 at 9:15 am #7648
      JPP
      Member

      Hi,

      Very good job ! It works perfect for my localdatabase(s) ! Great work !… 🙂

      But, something's wrong when I want to administer the remote (ISP) one's.

      On the New connection assistant, everything run Ok, and I can connect to the database, query datas… but, the object browser give me the error 1045 : access denied for user 'username@mail.oneofmydomain.com' (Using password : YES). So I can't see the database structure, etc… 😮

      Where did he take the 'username@mail.oneofmydomain.com' data to connect to the remote server ? How can I change this ?

      Thank's for your answer and be kind, excuse my poor english (I'm French)

    • February 3, 2003 at 11:28 am #13615
      Ritesh
      Member

      When are you getting the error?

      Even if you dont have access to any database, SQLyog will show you the all the database object.

      Quote:
      error 1045 : access denied for user 'username@mail.oneofmydomain.com' (Using password : YES). So I can't see the database structure, etc…

      What are you giving for Host Address and UserName in the connection details dialog box?

    • February 3, 2003 at 10:04 pm #13616
      devaholik
      Member
      Quote:
      Where did he take the 'username@mail.oneofmydomain.com' data to connect to the remote server ? How can I change this ?

      username is what you provided sqlyog as the login name, and the mail.oneofmydomain.com is your hostname that is automaticly added by default to connecto to a mysql table. Make sure mysql has given grant access to *@mail.oneofmydomain.com or *@*

      hope that helps 😀

    • February 4, 2003 at 3:14 am #13617
      allan
      Member

      I have the same problem. If I try to connect using the command line (eg. mysql -hhostname dbname) it acts the same way, by appending a derived hostname. How do other products avoid this problem? MySQL Front and dbVisualizer both connect as expected.

    • February 4, 2003 at 1:28 pm #13618
      Ritesh
      Member

      Bothe the mysql client and SQLyog uses the same way i.e. the MySQL C API to connect to host.

      Dont know about other products.

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