Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
0 users online | 0 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (478553 views)
- Error no. 2003: Can't connect... (394265 views)
- SQLyog Version History (246650 views)
- Error no. 1045: "Connection denied..." (206756 views)
- Error No. 2005: Unknown MySQL server host... (189371 views)
- Error no. 1251: "Client does not support authentication..." (178024 views)
- Can I use SQLyog with the WINE Windows emulator ... (169865 views)
- What is HTTP-tunneling? (144000 views)
- What Is SSH and SSH-tunneling? (115600 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (113712 views)
Latest FAQs 
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
ID #42
Tags: -
Related entries:
- SQLyog gives you the most options for connecting to MySQL
- Do I need PHP to use SQLyog with MySQL?
- Welcome to the SQLyog FAQ
- SQLyog Version History
- Error messages
You cannot comment on this entry
This is nice information however the key that I see missing from most posts is that you don't give me the "how to" part of it.
I still have no idea where to go or what SQL to type to grant the permissions.
You are kind enough to take the time to write all this information, I would suggest taking a few minutes more to type out the syntax of how the grant of permissions should be entered.
Added at: 2008-08-25 18:45
This is the SQLyog FAQ. SQLyog users will use the SQLyog GUI user management functionalities. The situations where commmand line GRANT syntax are required are 1) After server install on a remote host user may want to grant root access from remote machine 2) When creating an SSL-user
Added at: 2008-09-03 12:56
well, what if my connection outputs are ok, and the mysql database connects with no problems on the first time operating an insert but on the second time, and so on, operating that same insert gives the 1045 error? what does this means?
Added at: 2013-07-12 19:26
It still means the same. It is still a MySQL *SERVER* error. But since this happens this way I think you must be using HTTP tunnel (if you are using SQLyog)? Or it could be a server bug. What is the server version? Anyway .. this is not the best place for supporting you with this. Please use our Forums to ask support or mail to support@webyog.com (but only if you are a SQLyog user) -- Peter Laursen -- Webyog
Added at: 2013-07-12 20:34