{"id":51,"date":"2007-07-19T01:05:30","date_gmt":"2007-07-19T01:05:30","guid":{"rendered":"http:\/\/hosting-marketers.com\/news\/archives\/51"},"modified":"2020-04-28T19:10:50","modified_gmt":"2020-04-28T19:10:50","slug":"using-mysql-in-a-hosting-environment","status":"publish","type":"post","link":"https:\/\/hosting-marketers.com\/news\/2007\/07\/19\/using-mysql-in-a-hosting-environment\/","title":{"rendered":"Using MySQL in a Hosting Environment"},"content":{"rendered":"<p>Most of you know that <strong>MySQL <\/strong>is a database server that<br \/>\nis heavy-duty.\u00c2\u00a0 It can be used with PHP and other assorted software<br \/>\nlanguages and is a part of the family known as LAMP which stands for<br \/>\nLinux, Apache, MySQL, and PHP.<\/p>\n<p>Hosting Marketers supports on its cpanel, MYSQL and PHPmyAdmin which allows you to edit database tables entries. Read more about <a href=\"https:\/\/hosting-marketers.com\/news\/2010\/06\/28\/mysql-database-collation-utf-8-or-latin-on-phpmyadmin\">MYSQL DATABASE COLLATION<\/a>.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Most of you know that MySQL is a database server that is heavy-duty.\u00c2\u00a0 It can be used with PHP and other assorted software languages and is a part of the family known as LAMP which stands for Linux, Apache, MySQL, and PHP. Hosting Marketers supports on its cpanel, MYSQL and PHPmyAdmin which allows you to [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2,57],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-hosting-marketers-news","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9Yxzd-P","jetpack-related-posts":[{"id":211,"url":"https:\/\/hosting-marketers.com\/news\/2010\/06\/28\/mysql-database-collation-utf-8-or-latin-on-phpmyadmin\/","url_meta":{"origin":51,"position":0},"title":"MySQL database collation &#8211; UTF 8 or latin on phpmyadmin","author":"Admin","date":"June 28, 2010","format":false,"excerpt":"Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below: \u00a0 1. Enter your cPanel\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/hosting-marketers.com\/news\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":59,"url":"https:\/\/hosting-marketers.com\/news\/2008\/04\/07\/installing-phpmotion-v2-rc1\/","url_meta":{"origin":51,"position":1},"title":"Installing PHPmotion V3","author":"Admin","date":"April 7, 2008","format":false,"excerpt":"The following instructions only apply to Version 3 of PHPmotion. For V1 please refer to the instructions provided inside the downloaded zip file Download the the zipped file from PHPmotion, the version for PHP 5.x is the one which will work on our servers: http:\/\/downloads.phpmotion.com\/V3.5\/php5.2.x\/phpmotion.zip Before you begin Ensure that\u2026","rel":"","context":"In &quot;Hosting Marketers News&quot;","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":426,"url":"https:\/\/hosting-marketers.com\/news\/2013\/11\/15\/suphp-and-server-error\/","url_meta":{"origin":51,"position":2},"title":"suPHP and &#8220;Server Error&#8221;","author":"Admin","date":"November 15, 2013","format":false,"excerpt":"why you may get 500 Server Error on your site?","rel":"","context":"In &quot;security&quot;","block_context":{"text":"security","link":"https:\/\/hosting-marketers.com\/news\/category\/security\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":358,"url":"https:\/\/hosting-marketers.com\/news\/2012\/03\/30\/gyaro-video-chat\/","url_meta":{"origin":51,"position":3},"title":"Gyaro Video Chat","author":"Admin","date":"March 30, 2012","format":false,"excerpt":"Recently a new script for video chat come out, Gyaro, it looks a bit like Gchats, but the big advantage is that the red5 app doesn't connect to the script database, this renders it more stable. We tested also the new script Gyaro with wowza and it works great, this\u2026","rel":"","context":"In &quot;Hosting Marketers News&quot;","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6,"url":"https:\/\/hosting-marketers.com\/news\/2006\/09\/08\/what-is-the-difference-between-windows-and-unix-web-hosting\/","url_meta":{"origin":51,"position":4},"title":"What is the difference between Windows and UNIX web hosting?","author":"Admin","date":"September 8, 2006","format":false,"excerpt":"Windows and UNIX are in fact two different systems and of course we are referring to computer systems. A web host uses computers, (we shall refer to them as servers, just computers, but sometimes larger) to host websites, and all computers need a operating system, so Windows and UNIX are\u2026","rel":"","context":"In &quot;Hosting Marketers News&quot;","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27,"url":"https:\/\/hosting-marketers.com\/news\/2005\/03\/25\/comparing-servers\/","url_meta":{"origin":51,"position":5},"title":"Comparing servers","author":"Hosting Marketers","date":"March 25, 2005","format":false,"excerpt":"Almost 70% of sites on the internet are served by Apache, a completely Open Source, free web server. Quite an achievement for open source software, especially considering Microsoft's share is less than 20% There are other web servers of course, which all provide various other features... I considered quite a\u2026","rel":"","context":"In &quot;Hosting Marketers News&quot;","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/comments?post=51"}],"version-history":[{"count":1,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":898,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/51\/revisions\/898"}],"wp:attachment":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/media?parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/categories?post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/tags?post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}