Tag Archives: mysql

Configure Navicat to Access Remote Mysql – dedicated server

i got this error messages when access mysql from navicat tools ssh tunnel server does not support diffie-hellman-group1-sha1 for keyexchange the solution is : you have to provide the correct key exchange with your ubuntu dedicated server sudo nano /etc/ssh/sshd_config add this line at the bottom of our sshd config files : KexAlgorithms diffie-hellman-group1-sha1,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1 Ciphers 3des-cbc,blowfish-cbc,aes128-cbc,aes128-ctr,aes256-ctr save it… Read More »

php insert google analytics script into database mysql

i have some google analytics sample code like this : <script> (function(i,s,o,g,r,a,m){i[‘GoogleAnalyticsObject’]=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,’script’,’//www.google-analytics.com/analytics.js’,’ga’); ga(‘create’, ‘UA-xxxxxxxxxxxx’, ‘auto’); ga(‘send’, ‘pageview’); </script> and i want to insert it into database … this is how i do it . i use addslashes to escape the single quotes from the content of the google analytics scripts then i allow the… Read More »