Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participantyou just repeat yourself. 🙁
What do you mean “Ive check the port and 3306 is running”
and this “SSH to edit the xml's to my needs” ?????
ParticipantMySQL has a description here:
Participant“still get access denied”
I see two possibilities
1)
that looks like host, UID or PW is wrong (though you claim it is correct).
Sometimes there is a prefix needed on a webhotel like mywebhotel_mydatabase
2)
“Ive check the port and 3306 is running”
What do you mean “port is running” ?
It's not certain that you are allowed to logon to the MySQL database on port 3306 from an externaal connection ( even if the port is open or “running”. You could try tunnelling with the Entreprise version.
Participantto clarify my point:
With this special setup of two OS's running simutaneously on the same machine, I don't know if the normal MySQL port 3306 is accessible for Linux or if it can be accessed “from outside”. But since you can connect til your Apache server running on Linux port 80 is accessible!!!
Therefore HTTP-tunnelling should work, if direct connection is not possible!
But of course I don't know this special configuration. Do the 2 OS's share an ip or not for instance …
Participantjust one more question: the port number is standard 3306 ?
For a test you could try to use HTTP-tunnelling (uses HTTP-port 80)
And rememer that under Linux the letter case is sognifikant not only in password but everywhere.
ParticipantWell, I would prefer It was complete, totally free and without nagscreens too … but that's not how the World works. For some strange reason even nerds want to eat a little bit from time to time 😎 .
Personally I think the webyog company is quite generous. Of course they do it for their own benefit (THAT IS how the World works!) >>> when we get to love the program we might buy it one day. But the free version is quite useful. And add to that that high-quality beta's and RC-versions with full functionality are avilable quite often too.
The only thing I would say about it, is that I think it is somewhat inconsequent that SJA for Linux is free and at the same time syncronization is not included in the free Windows version.
Concerning nag-screens, I would propose this model for sometime in the future (other programs have it):
When the program is only used very little (say a couple a times a week) there are no nag-screens. The more extensive the use of the program the more nag-screens. If you use a program several times a day I think it's OK that the amount and size/impact of nagscreens become unbearable as long as it is a commercial product.
ParticipantMaybe the MySQLadministrator script will work in ANSI-mode ?
With MySQL up to 4.0 the ansi-mode is specified in the server section of the my.ini/my.cnf (and will thus apply to all connections)
With MySQL 4.1 and above each connection could specify individually that ansi-mode should be used for that connection.
ParticipantI don't agree.
But of course it's very unfortunate that you lose data. But it's the very common way to do things. MySQLAdministrator does the samme as well as the backup utilities for popular forum's software such as phpBB2, and other clients that I know.
If you are running the scirpt the base is “reset” to the state it was, when the script was created. You could use the “syncronize” function instead – provided that you have another MySQL installation each table has a Primary Key.
Participant“However, if the Mysql service is restarted after Enterprise has been closed, and Plink has also been closed, then the local server lets you in again without a reboot.”
Sorry, but I don't know what Enterprise and Plink is !?
Undoubtedly thereis something wrong with your local MySQL-installation or maybe another MySQL-client running locally. Has your current MySQL been upgraded from a previous version ? And what version(s) are we talking about ?
ParticipantAgreed!
However there is one facility in Winmysqladmin that's not in MySQLAdministrator: You can not only stop the server but also uninstall the service from Winmysqladmin without uninstalling the application. I'd allways preferred to uninstall the service that way before upgrading. But with the new Win-installer it probably isn't necessary.
Further you'll have to get MysQl running before you can use MySQLadministrator – you can't bypass the logon-screen.
In general I think the people MySQL are very performng vey bad as far as documenting what utilities fit what version of MySQL. I think it called “Version's Management” (it is in Danish!)
And what happened to “MySQL Control Center” ??
Concerning the ODBC issue: I really rigoriously followed the instruction when I first upgraded from a 4.0 to a 4.1 version. So the user's and password's scema shoul be updated as well.
Participant> Shadow …
I have 4 users alle with password om my 4.1.7 installtion, and I can connect through ODBC.
I believe it needs the latest my-ODBC, and I don't think there is any ODBC for MySQL 5 yet …
ParticipantAs far as I know the ODBC-driver is not ready for MySQL ver. 5 yet.
To create users try the program “MySQL Administrator” from http://www.mysql.com. (don't know if YOG will work with the new user SCHEMA.
How did you create the use KAMIL 'Kamil'@'localhost' (Using password: YES)?
With a fresh install only use ROOT exists!
MySQLAdmin was writen for older versions of MySQL and I too have experienced missing or wrong informatiom in it.
Participantwith 4.1.7 I was not able to choose the installation directory!
ParticipantIf that was a question for me, I can tell that I use Mysql 4.1.6 locally. My webhotel operates a 4.0.of-some-kind right now I think .. My sqlyog version is 4.0 B5.
The picture that showed my “drop-down-box” was quite a tricky one. The Internet domain dyndns.dk is a domain where you can have a subdomain for free. Mine is deepeter.dyndns.dk, and it points to the ip of my local machine. Thus I was able to simulate a copy operation from localhost to a server, although it really was copying from localhost over the internet back to the samme MySQL-installation on my local machine. Tunneling of either kind was not active. And since you were using the term “localhost” I thought that was an illustration of a situation similar to yours. But I didn't imagine/realize that SSL could influence that. I've been using the “copy DB” quite extensively without tunnelling and also somewhat with HTTP-tunneling but didn't realize the difference to your “project”.
I was quite confused by your original question, so I might have spread this confusion to the forum and to you. Sorry for that.But since nobody else had answered your question for a couple of days I decided to ask the inital questions just in order to clarify the question. And don't ask me to correct anything about SSH-tunneling. I know practically nothing about it! And by the way – why do you (have to) use it ?
Is your dropdown-box OK (show DB's from both servers) if you do NOT use SSH-tunnelling ? It should be!
And I do think you have a point in that “by referencing the name of the connection” a lot of confusion could have been avoided in this case. With the transition from sqlyog from 3.x to 4.x maybe the “copy DB” should have a facelift. And there could be a drop-down-box showing active connections …
ParticipantI'm messing things up – of course it works through MySQL. I've just been working with the Sync. agent recently and was in another world …
Try this:
1) Cancel the popupscreen when the program starts.
2) Then connect to the severs individualy from file .. connect (use tunnelling if you need/like).
3) you may cascade the windows belonging to each server …
4) And the you should be able to Copy or Sync and all the program offers …
If you want to use HTTP-tunneling the SQLyogTunnel.php – file (from sqlyog directory) should be copied to the server (THAT would be a web server) and it is the URL to that file that should be entered as the connection URL.
If have no experience with SSH-tunnelling – sorry
You ran into trouble because of your use of your subsstituion of a remote server with localhost. That made the program behave unpredictably. by the way: I there a MySQL server running on your local machine right now ?
-
AuthorPosts
